Data Mart in Business Intelligence with Ralph Kimball for Commercial Sales

Torres A.C.; Gastelu A.Q.; Soria J.J.; Manrique M.V.; Peña L.S. · Lecture Notes in Networks and Systems (2024) · DOI: 10.1007/978-3-031-53552-9_34

Resumen

Business intelligence in organizations, not exploiting the volume of their data is a problem, if they do not have technological tools that allow real-time reporting. This article presents a well-executed study on the implementation of a Data Mart in an organization, which has resulted in a remarkable increase in sales. It effectively leverages Ralph Kimball’s methodology and the star model, providing rich insight to decision makers. The research is comprehensive, valuable and could greatly benefit other organizations wishing to improve their strategic planning. Extract, Transform, Load (ETL) processes were applied for information gathering and approaches provided by the application of the Ralph Kimball methodology. The Tableau platform was used for sales reports in the areas of warehouse, management and accounting, obtaining dynamic dashboards, showing a 30% increase in sales of the categories, being the most benefited the category of small bread, which went from 42,390 units sold to 59,760 units, representing an increase of 40% sold, there was an increase of 45% in the product pan croissant, as well as an increase of more than 30% in sales in general; all these results are the comparison made from April to May 2023. It is concluded that the Data Mart is efficient in reporting with an optimum of 20% in the organization’s products. © The Author(s), under exclusive license to Springer Nature Switzerland AG 2024.

Instituciones: Universidad Tecnológica del Perú