Business Intelligence and data analytics for financial decision-making

  • Carlos Bladimir Moreano Guerra Universidad Central del Ecuador, Ecuador
  • Edwin Ramiro Haro Haro Universidad Central del Ecuador, Ecuador
  • Paulina Alexandra Villagomez Valencia Universidad Central del Ecuador, Ecuador
  • Grace Lilián Moreano Guerra Universidad Politécnica Salesiana, Ecuador
Keywords: Financial analysis, business intelligence, data analytics, decision-making, Power BI

Abstract

Financial analysis is a key tool not only for evaluating the economic performance of companies but also for supporting decision-making. In this context, the research focused on analyzing the implementation of business intelligence and data analytics for processing and interpreting financial information—utilizing both indicators and visualization tools—during the 2021–2025 fiscal years. The study employed a quantitative approach with a descriptive and comparative scope, using a non-experimental, longitudinal design. Data were obtained from financial statements covering the analyzed period; these were processed, cleaned, and validated using Microsoft Excel before being integrated into Power BI. Nine indicators related to financial structure, profitability, and cash generation were evaluated. The results showed favorable trends in structural metrics, alongside a recovery in profit margins, growth in revenue and net income, and a strengthening of operating cash flow by the end of the 2025 fiscal year. The Power BI dashboard enabled the consolidation and visualization of these indicators, facilitating temporal comparisons and the identification of trends and relationships among key financial dimensions. In conclusion, the incorporation of business intelligence and data analytics stands as a strategic resource that complements and optimizes traditional analysis by streamlining data processing and interpretation, thereby providing analytical insights for evidence-based decision-making.

Downloads

Download data is not yet available.

References

Alsibhawi, I. A., Yahaya, J. B., & Mohamed, H. B. (2023). Business Intelligence Adoption for Small and Medium Enterprises: Conceptual Framework. Applied Sciences, 13(7), 4121. https://doi.org/https://www.mdpi.com/2076-3417/13/7/4121#

Barón Ramírez, E., García Estrella, C., & Sánchez Gárate, S. (2021). La inteligencia de negocios y la analítica de datos en los procesos empresariales. Revista Científica de Sistemas e Informática, 1(2), 37-53. https://doi.org/https://doi.org/10.51252/rcsi.v1i2.167

Castañeda Oñate, B. (2024). Gestión financiera para la toma de decisiones en la banca privada del Ecuador. Obtenido de [Tesis de maestría, Pontificia Universidad Católica del Ecuador]: https://repositorio.puce.edu.ec/server/api/core/bitstreams/a1493cbc-5678-4463-9275-ab66e0d87119/content

Coll Morales, F. (24 de Julio de 2024). Ratio de Autonomía Financiera. Obtenido de Rankia: https://www.rankia.com/diccionario/bolsa/ratio-autonomia-financiera

Comfort Idongesit, M., Oluwaseun Johnson, I., Adejoke Deborah, A., Ibrahim Oyeyemi, A., Damilola, A., Adefisayo Simon, O., & Praise Ayomide, A. (2024). Data-driven decision making in IT: Leveraging AI and data science for business intelligence. World Journal of Advanced Research and Reviews, 23(01), 472-480. https://doi.org/https://doi.org/10.30574/wjarr.2024.23.1.2010

Cordero-Naspud, E., Erazo-Álvarez, J. C., Narváez-Zurita, C., & Cordero-Guzmán, D. (2020). Soluciones corporativas de inteligencia de negocios en las pequeñas y medianas empresas. Revista Arbitrada Interdisciplinaria Koinonía, 5(10), 483-513. https://doi.org/https://doi.org/10.35381/r.k.v5i10.703

Darmawan, Y. S., Setiawan, B., & Hasan Zahrandy, M. A. (2026). Integrating balanced scorecard and analytic network process in a performance dashboard for ‘X’ bank using Power BI. Procedia Computer Science, 284, 1413-1421. https://doi.org/https://doi.org/10.1016/j.procs.2026.07.130

Escobar de la Cuadra, Y., Vargas Ortiz, O., & Villegas de la Cuadra, S. (2024). Impacto de los Indicadores Financieros en el Desempeño Económico Sectorial: Un Análisis Comparativo y Predictivo basado en Modelos de Regresión Múltiple. Ciencia Latina Revista Científica Multidisciplinar, 8(6), 92-108. https://doi.org/https://doi.org/10.37811/cl_rcm.v8i6.14534

Hawar Ghafur, H. A., Tavga Mahdi, A., & Rizgar Abdullah, S. J. (2026). The Impact of Power Business Intelligence on Financial Performance and Decision-Making Support: A Descriptive Analytical Study on a Sample of Finance Managers and IT Specialists in Industrial Companies within the Kurdistan Region of Iraq. Academic Journal of International University of Erbil, 3(2), 1185-1198. https://doi.org/https://doi.org/10.63841/iue3261185

Huacchillo Pardo, L., Ramos Farroñan, E., & Pulache Lozada, J. (2020). La gestión financiera y su incidencia en la toma de decisiones financieras. Universidad y Sociedad, 12(2), 356-362. Obtenido de https://rus.ucf.edu.cu/index.php/rus/article/view/1528/1540

Ibeh, C. V., Asuzu, O. F., Olorunsogo, T., Elufioye, O. A., Nduubuisi, N. L., & Daraojimba, A. I. (2024). Business analytics and decision science: A review of techniques in strategic business decision making. World Journal of Advanced Research and Reviews, 21(02), 1761-1769. https://doi.org/https://doi.org/10.30574/wjarr.2024.21.2.0247

Kefe, İ., Evci, S., & Kefe, İ. (2024). Data on the financial performance of companies on BIST Sustainability 25 Index: An Entropy-based TOPSIS approach. Data in Brief, 57, 110959. https://doi.org/https://doi.org/10.1016/j.dib.2024.110959

Loor Zambrano, H., Santistevan Nunura, J., Ureta Zambrano, M., & Mera Macías, R. (2023). Análisis de indicadores de desempeño financiero de la empresa ecuatoriana de balanceados Coprobalan S.A. Revista San Gregorio, 1(54), 128-146. https://doi.org/https://doi.org/10.36097/rsan.v1i54.2454

Moreno Guaita, J., Zuñiga Sanchez, I., Medina Chicaiza, P., & Calvache Vargas, C. (2024). Power BI en el sector financiero: cómo transformar datos en decisiones inteligentes. Journal Science and Research, 9(CININGEC-(2024)), 1-20. Obtenido de https://revistas.utb.edu.ec/index.php/sr/article/view/3326

Najdawi, A., & Karan Patkuri, S. (2021). Modeling Business Intelligence Process: Toward Smart Data-Driven Strategies. 2021 International Conference on Computational Intelligence and Knowledge Economy (ICCIKE), 198-202. https://doi.org/https://doi.org/10.1109/ICCIKE51210.2021.9410804

Narea Chumbi, P., & Guamán Tenezaca, G. (2021). Aplicación de indicadores financieros e inductores de valor como herramienta de optimización en las decisiones estratégicas empresariales. Revista Economía y Política (34), 95-111. https://doi.org/https://doi.org/10.25097/rep.n34.2021.06

Pinto-Cárdenas, M., Pinda-Guanolema, B., & Romero-Fernández, A. (2025). Inteligencia de negocios en el análisis financiero. Noesis Revista Electrónica de Investigación, 7(1), 288-307. https://doi.org/https://doi.org/10.35381/noesisin.v7i1.385

Quispe Yactayo, F., Roque Lanchipa, R., & Pacheco Fernández, J. (2025). Uso de herramientas de inteligencia de negocios en la toma de decisiones financieras en contextos formativos. Revista Científica Convergencia Empresarial, 14(01), 4-22. https://doi.org/https://doi.org/10.47796/ce.v14i01.1261

Reyes Mendoza, S., Romero Flores, E., Carrera Mora, O., & Ortega Petterson, N. (2023). Dashboard para el análisis de la rentabilidad de las estrategias de comercialización de café en sociedades de caficultores. Universita Ciencia, 11(31), 3-16. Obtenido de https://universita.ux.edu.mx/universita-ciencia/article/view/861

Ríos-Carrión, P., Bermeo-Pazmiño, K., & Narváez-Zurita, C. (2021). Inteligencia de negocios como estrategia para la toma de decisiones en una empresa financiera. CIENCIAMATRIA, 7(12), 487-514. https://doi.org/https://doi.org/10.35381/cm.v7i12.438

Rocha Hidalgo, N., Bermeo Moreno, M. G., Pazmiño Rocha, M. J., Tabare Casquete, T., & Vaca Montalvo, T. (2025). Gestión Financiera en la empresa: Conceptos básicos y su aplicación en la toma de decisiones. Ciencia Latina Revista Científica Multidisciplinar, 9(2), 932-945. https://doi.org/https://doi.org/10.37811/cl_rcm.v9i2.16898

Sotelo Reinoso, V., Meléndez-Mogollón, I., & García-Silvera, E. (2025). Impacto de la analítica de datos en empresas modernas, con la aplicación de optimización de procesos y experiencia del cliente. Revista Ciencia UNEMI, 18(49), 25-33. https://doi.org/https://doi.org/10.29076/issn.2528-7737vol18iss49.2025pp25-33p

Superintendencia de Compañías Valores y Seguros (SCVS). (s. f.). Tabla de indicadores técnicos. Obtenido de Supercias: https://reporteria.supercias.gob.ec/portal/samples/images/docs/tabla_indicadores.pdf

Treviño-Reyes, R., Rivera-Rodríguez, F., & Garza-Alonso, J. (2020). La analítica de datos como ventaja competitiva en las organizaciones. Vinculatégica EFAN, 6(2), 1063-1074. https://doi.org/https://doi.org/10.29105/vtga6.2-520

Tutcu, B., Kayakuş, M., Terzioğlu, M., Ünal Uyar, G. F., Talaş, H., & Yetiz, F. (2024). Predicting Financial Performance in the IT Industry with Machine Learning: ROA and ROE Analysis. Applied Sciences, 14(17), 7459. https://doi.org/https://doi.org/10.3390/app14177459

Viteri-Cevallos, C., & Murillo-Párraga, D. (2021). Inteligencia de Negocios para las Organizaciones. Revista Arbitrada Interdisciplinaria Koinonía, 6(1), 304-333. https://doi.org/https://doi.org/10.35381/r.k.v6i12.1291

Published
2026-09-19
How to Cite
Moreano Guerra, C. B., Haro Haro, E. R., Villagomez Valencia, P. A., & Moreano Guerra, G. L. (2026). Business Intelligence and data analytics for financial decision-making. GADE: Scientific Journal, 6(2), 346-374. https://doi.org/10.63549/rg.v6i2.850