Designing a Data Warehouse Framework for Business Intelligence

Data warehouse (DW) and Business Intelligence (BI) provide mechanisms for companies to exploit their data reaching the goal of making better, more efficient decisions. However, from the perspective of business users, they may have difficulties and confusions in the first approach to the analytic technology. This paper presents the design and implementation of a platform for constructing Data Warehouse frameworks including Business Intelligence tools for data analytics, and designing an ETL process for populating the DW from data sources. The Fact models provided in the proposed framework include Sales, Procurement, Product Inventory, and Customer Relationship Management processes. By applying Dimensional modeling approach, the goal is to provide a platform for new business users to get use of data exploitation by helping them building fast and customizable DW. In addition, we evaluate that using a cloud-based solution would bring back more values rather than investing initial infrastructures.