Abstract:

In Peru, many organizations do not fully utilize the information they generate, either due to ignorance or failure to implement the tools needed to generate value from the stored data. Such information may be used for the strategic planning of companies. This article develops a business intelligence (BI) solution using the Ralph Kimball methodology for decision-making in the retention of Niubiz clients, which will support the generation of reports for the head of planning at Comdata. To achieve this objective, a series of tasks were carried out according to the methodology used, and the business requirements were defined. Based on this, a dimensional model was designed for an SQL Server, and data from OnLine Transaction Processing (OLTP) sources were entered with the extract, transform and load (ETL) tool. The next step was the creation of the information cube, which was exploited with Power BI for the generation of the dashboards. After the implementation of the BI system, the decision-making process was improved because the information was presented in a more dynamic and precise way. This can be contrasted with the results obtained.