Data warehouse and its impact on agile decision-making at Best Cable Peru
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...
| Authors: | , , |
|---|---|
| Format: | article |
| Status: | Published version |
| Publication Date: | 2024 |
| Country: | Perú |
| Institution: | Universidad La Salle |
| Repository: | Revistas - Universidad La Salle |
| Language: | Spanish |
| OAI Identifier: | oai:ojs.revistas.ulasalle.edu.pe:article/146 |
| Online Access: | 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 |
| Access Level: | Open access |
| Keyword: | Data warehouse Business Intelligence Make Decisions Data warehouse, Inteligencia de Negocios, Toma de Decisiones. |
| Summary: | 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. |
|---|