Those experienced in data warehousing generally agree that the following are typical reasons why data warehouse projects fail:
Not only do all of these groups provide valuable input for creating a data warehouse, but any one of them can cause a data warehouse to fail through their lack of support.
During the sometimes long planning stages, data warehouse designers can lose sight of the forces driving the creation of the warehouse.
A less-than-rigorous examination of the environment for a data warehouse can doom the project to failure.
As with all projects, starting the creation of a data warehouse with too short a time frame or too aggressive a scope will force the data warehouse team to cut corners, resulting in the mistakes previously mentioned.
Data warehouses, like all technologies, are not a panacea. You must make sure that all members of the team, as well as the eventual users of the data warehouse, have an appropriate set of expectations.
Although it may seem overly time-consuming at the start, you must keep in mind the long-term goals of your project, and your organization, throughout ...