Data warehouse and its impact on agile decision-making at Best Cable Peru
Abstract
Business intelligence provides significant assistance in decision-making by offering a comprehensive overview of the business and its workflow, presenting various alternatives to decision-makers. The research aimed to streamline decision-making within the company through the implementation of a Data Warehouse. The Kimball methodology was employed in the process, utilizing Atoti Apache Airflow and PowerBI software, which were fed with transactional data stored in a MariaDB database. Statistical analysis was conducted using R software within the RStudio environment. The study population consisted of 5 employees for the user satisfaction indicator, employing a convenience non-probabilistic sampling method, while for the indicators of report generation time and costs, the population comprised 360 management reports, sampled using a simple probabilistic method, resulting in a sample of 186 management reports. The results indicated a 94.37\% reduction in the time required for report generation, a 94.72\% decrease in associated costs, and a 72.36\% increase in user satisfaction level. Upon analysis, it was determined that the implementation of business intelligence significantly improved decision-making agility within the company, confirming its effectiveness.
Downloads
References
K. Alcázar, “Gravitar.biz,” Octubre 2022, [Último acceso: 09 Diciembre 2023]. [Online]. Available: https://gravitar.biz/datawarehouse/beneficios-data-warehouse/
L. A. Huamán, “Inteligencia de negocios en la gestión académica de la educación superior universitaria,” Rev. Investig, vol. 7, no. 2, pp. 526–536, 2018.
P. N. N. Picon, M. E. A. Valarezo, and D. M. C. Guzmán, “La inteligencia de negocios como apoyo a la toma de decisiones en el área de comercialización de la empresa azuaynet,” Polo del Conocimiento: Revista científico - profesional, vol. 7, no. 8, pp. 2460–2483, 2022.
V. Salazar and E. José, “Aplicativo datawarehouse para la toma de decisiones en la unidad de recaudación tributaria en la municipalidad distrital de punchana 2018,” Master’s thesis, Universidad Nacional de la Amazonía Peruana, 2019.
O. Rios and L. Jack, “Implementación de un data warehouse para mejorar el proceso de toma de decisiones del centro asistencial primaria de salud - essalud. iquitos,” Master’s thesis, 2020.
E. López and F. Peralta, “Desarrollo de una solución de inteligencia de negocios para mejorar el proceso de toma de decisiones en el área de rentas de la municipalidad distrital de moche,” Master’s thesis, Universidad Nacional de Trujillo, 2020.
Y. Rodríguez Cruz and M. Pinto, “Modelo de uso de información para la toma de decisiones estratégicas en organizaciones de información,” Transinformação, vol. 30, no. 1, pp. 51–64, 2018.
C. A. S. Retiz and L. R. Bello, “Toma de decisiones en empresas pequeñas que combinan varias actividades econ. construcción de un tablero de control,” Univ. Empresa, vol. 21, no. 37, p. 228, 2019.
Copyright (c) 2024 Innovation and Software
This work is licensed under a Creative Commons Attribution 4.0 International License.
The authors exclusively grant the right to publish their article to the Innovation and Software Journal, which may formally edit or modify the approved text to comply with their own editorial standards and with universal grammatical standards, prior to publication; Likewise, our journal may translate the approved manuscripts into as many languages as it deems necessary and disseminates them in several countries, always giving public recognition to the author or authors of the research.
