Business Intelligence with Data Mart to Reduce Reporting and Indicator Generation Time

Vega-Huerta H.; Nalvarte-Almeida E.; Adrianzén-Olano I.; Benito-Pacheco O.; Cabrera-Diaz J.; Gil-Calvo R.; Lázaro-Guillermo J.C. · Studies in Big Data (2026) · DOI: 10.1007/978-3-032-08765-2_31

Resumen

This project arose from the need of the users of the Customer Billing area of América Móvil Perú SAC to obtain continuous and timely information on commercial indicators associated with their various activities. Specifically, the study focused on the calculation of penalty charges related to the reinstatement of equipment, a process that varied depending on the reason for line deactivation and was constantly adjusted due to market competitiveness and regulatory changes. The objective of the project was to conduct an in-depth analysis of the different schemes used by analysts to generate their indicator reports. This analysis identified the critical data required for each scheme and ensured that all reports followed a standardized framework, establishing consistent rules for data homogenization. To achieve this, a Business Intelligence (BI) solution was developed using a data mart, allowing the automation of calculations, the integration of dispersed data sources, and the reduction of reporting times. As a result, decision-making processes were improved, and the efficiency of commercial operations was significantly enhanced. © The Author(s), under exclusive license to Springer Nature Switzerland AG 2026.

Instituciones: Universidad Nacional Mayor de San Marcos; Universidad Nacional Toribio Rodríguez de Mendoza de Amazonas; Universidad Nacional Intercultural de la Amazonia