Designing a Framework to Standardize Data Warehouse Development Process for Effective Data Warehousing Practices

Data warehousing solutions work as information base for large organizations to support their decision making tasks. With the proven need of such solutions in current times, it is crucial to effectively design, implement and utilize these solutions. Data warehouse (DW) implementation has been a challenge for the organizations and the success rate of its implementation has been very low. To address these problems, we have proposed a framework for developing effective data warehousing solutions. The framework is primarily based on procedural aspect of data warehouse development and aims to standardize its process. We first identified its components and then worked on them in depth to come up with the framework for effective implementation of data warehousing projects. To verify effectiveness of the designed framework, we worked on National Rural Health Mission (NRHM) project of Indian government and designed data warehousing solution using the proposed framework.