Agile Dimensional Model for a Data Warehouse Implementation in a Software Developer Company

Nowadays, the increasing development of Business Intelligence (BI) solutions in organizations, has enabled executives achieve a better understanding of business information for timely and rapid decision-making in a tremendously dynamic market. Although there is an increasing interest in adopting an agile approach to the software development, the emergent need of using agile methodologies in BI solutions is undeniable. This paper discusses the importance of using agile methods in the design and development of data warehouses taking into account the business processes, requirements analysis, and organizational objectives. Thus, we present a case study derived from a real-world business project where the agile methodology Business Event Analysis and Modeling (BEAM) is used to design the data warehouse. The project is based on a billing system with about one million operations on a daily basis with more than 15,000 clients. Finally, the results of this paper include the design of the dimensional model using an agile approach, the construction of the data warehouse through the ETL processes and an interactive dashboard according to the key performance indicators defined by the business decisionmakers.