Data Warehouse Discovery Framework: The Case Study

The cost of building an Enterprise Data Warehouse Environment runs usually in millions of dollars and takes years to complete. Even bigger than cost is the risk that all the design and development of the Data Warehouse and Business Intelligence Environment may not bring the result expected by the user. This was the main incentive behind author's effort of laying down the foundation for new methodology called Data Warehouse Discovery [1]. The foundation met with acceptance by some scientific groups on one hand and industry interest on the other. At that point, the author faced a major challenge. In order to get industry full acceptance as viable tool for the development and maintenance of a robust DW/BI environment, an actual implementation of the methodology in production was necessary. The DW/BI Strategy and Design Project that author was just conducting for the Canadian Federal Government was a perfect opportunity to propose and implement the methodology. This paper is presenting the conduct and results of that business case.