CMCD: A data warehouse modeling framework based on goals and business process models

The decision making process is mainly data driven, which makes Data Warehousing play a crucial role in providing a reliable and efficient tool to meet analytical needs and provide end users and decision makers with useful insights. However, several surveys show that a significant percentage of Data Warehouse (DW) projects fail to meet their business goals. Indeed, it is mainly due to the lack of any formal relationship between the Contextual Requirements analysis and the DW conceptual modeling phase. This work is a first step towards the development of a CMCD framework (from Contextual Model to Conceptual Design) that consists of a unified approach to automatically extract the DW multidimensional model from Goal modeling frameworks and Business Process Diagrams. In order to illustrate the feasibility of our approach, we implemented it within a case study related to the development and implementation of a DW to monitor and assess good local governance in Moroccan local municipality offices.