Data warehouse and its impact on agile decision-making at Best Cable Peru

• Autores: Perez Quispe, Cesar Alcides, Santos Fernandez, Juan Pedro, Sánchez Ticona, Robert Jerry
• Formato: artículo
• Fecha de Publicación: 2024
• Institución: Universidad La Salle
• Repositorio: Revistas - Universidad La Salle
• Lenguaje: español
• OAI Identifier: oai:ojs.revistas.ulasalle.edu.pe:article/146
• Enlace del recurso: https://revistas.ulasalle.edu.pe/innosoft/article/view/146; https://doi.org/10.48168/innosoft.s16.a146; https://purl.org/42411/s16/a146; https://n2t.net/ark:/42411/s16/a146
• Nivel de acceso: acceso abierto
• Materia: Data warehouse; Business Intelligence; Make Decisions; Data warehouse, Inteligencia de Negocios, Toma de Decisiones.

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.