Build a Data Warehouse on a Solid Foundation
Evaluate the need for a data warehouse and plan the project.
Send a friend or colleague a link to this article
Last Revised: July 6, 2010
- Poor planning is the root of all failed data warehouse projects.
- Project overruns are primarily a function of underestimating the importance and complexity of developing the data requirements and inadequate staffing.
- Successful warehousing strategies start with business focused requirements, the right team, and a sound project plan.
- Data warehousing (DW) is a business discipline, not an IT infrastructure project.
- The value of a DW consists in providing decision makers timely and accurate views of the business.
- DW architecture design and data modeling starts with understanding the information requirements of business users.
Impact and Result
- Assess organizational readiness and develop a game plan that prepares the organization for success.
- Establish justifiable business goals and a realistic implementation roadmap that enables early business value.
- Define the correct DW requirements and tailor your reporting/analysis needs to avoid overbuilding.
Get to Action
Build a data warehouse plan and strategy
Avoid over-engineering the data warehouse.
Assess the readiness of the organization for a DW
Ensure that the right people, processes, and technology are in place.
Craft a sound business plan
Start with a realistic scope based on clear business justification.