Reference Modeling for Data Analysis: The BIRD Approach

Reference models for data analysis with data warehouses may consist of multidimensional reference models and analysis graphs. Multidimensional reference models are best-practice domain-specific data models for online analytical processing. Analysis graphs are reference models of analysis processes for event-driven data analysis. Small and medium-sized enterprises (SMEs) as well as large multinational companies may benefit from the use of reference models for data analysis. The availability of multidimensional reference models lowers the obstacles that inhibit SMEs from using business intelligence (BI) technology. Multinational companies may define multidimensional reference models for increased compliance among subsidiaries and departments. Furthermore, the definition of analysis graphs facilitates the handling of business events for both SMEs and large companies. Modelers may customize the chosen reference models, tailoring the models to the specific needs of the individual company or local subsidiary. Customizations may consist of additions, omissions, and modifications with respect to the reference model. In this paper, we propose a metamodel and customization approach for multidimensional reference models and analysis graphs. We specifically address the explicit modeling of key performance indicators as well as the definition of analysis situations and analysis graphs. Keywords: Conceptual modeling; business intelligence; online analytical processing; dimensional fact model; metadata management; data warehouses