Development of a Business Intelligence Model for Commercial Management in a Food Industry Company
Authors
-
Pierre Desfrancois
Universidad Tecnológica Israel. Quito, Pichincha, Ecuador.
https://orcid.org/0000-0003-2841-3272
-
José David Abad Heredia
Universidad Tecnológica Israel. Quito, Pichincha, Ecuador.
https://orcid.org/0009-0009-2029-9648
DOI:
https://doi.org/10.33936/ecasinergia.v16i3.7671Abstract
Companies generate large volumes of data through transactional systems, but they are not always able to centralize or analyze this information effectively for strategic decision- making. In the mass consumption food industry, and particularly in Ecuador´s coffee sector, the market and competition require a data-driven approach to identify trends, explore growth opportunities, and analyze consumer behavior with greater accuracy. In this context, a company dedicated to the production and commercialization of coffee faces the need to improve its commercial management through the use of business intelligence. The main problem lies in the fragmentation of information originating from various sources, which makes it difficult to access updated and interpretable reports. For this reason, this research develops a business intelligence model that facilitates data consolidation and enhances commercial management. Finally, after evaluating its implementation with the company’s strategic commercial area, the results confirmed that this solution contributes to more confident, agile, and reliable decision-making based on accurate and timely information.
Downloads
References
Almazmomi, N., Ilmudeen, A., & Qaffas, A. A. (2021). The impact of business analytics capability on data-driven culture and exploration: achieving a competitive advantage. Benchmarking: An International Journal, 29(4), 1264-1283. https://doi.org/10.1108/bij-01-2021-0021
Bhuiyan, M. R. I., Faraji, M. R., Rashid, M., Bhuyan, M. K., Hossain, R., & Ghose, P. (2024). Digital transformation in SMEs emerging technological tools and technologies for enhancing the SME’s strategies and outcomes. Journal of Ecohumanism, 3(4), 211-224.
Buri, K. A. J., Quezada, J. M., & Granda, A. D. C. V. (2023). Análisis de las exportaciones del café en el Ecuador, periodo
2017-2021. Ciencia Latina Revista Científica Multidisciplinar, 7(1), 6166-6184. https://doi.org/10.37811/cl_rcm.
v7i1.4909
Delen, D., & Ram, S. (2018). Research challenges and opportunities in business analytics. Journal of Business Analytics,
1(1), 2-12. https://doi.org/10.1080/2573234x.2018.1507324
Espinoza-Mina, M. A., Colina-Vargas, A. M., & Palacios-Miranda, J. R. (2022). Implementación de Balanced Scorecard basado en herramientas de inteligencia de negocios para PYMEs ecuatorianas. Mikarimin. Revista Científica Multidisciplinaria, 8(1), 17-46.
Fuentes Adrianzén, D. J. (2021). Modelo integrado de inteligencia de negocios como soporte a la toma de decisiones en la gestión comercial de las MYPES. Universidad Señor de Sipán. https://repositorio.uss.edu.pe/
Ganeshkumar, C., Sankar, J. G., & David, A. (2023). Adoption of big data analytics: Determinants and performances among food industries. International Journal of Business Intelligence Research (IJBIR), 14(1), 1-17.
Negro, A. R., & Mesia, R. (2020). The Business Intelligence and Its Influence on Decision Making. Journal of Applied
Business & Economics, 22(2). https://doi.org/10.33423/jabe.v22i2.2807
Niu, Y., Ying, L., Yang, J., Bao, M., & Sivaparthipan, C. B. (2021). Organizational business intelligence and decision making using big data analytics. Information Processing & Management, 58(6), 102725. https://doi.org/10.1016/j. ipm.2021.102725
O’Connor, C., & Kelly, S. (2017). Facilitating knowledge management through filtered big data: SME competitiveness
in an agri-food sector. Journal of Knowledge Management, 21(1), 156-179. https://doi.org/10.1108/jkm-08-2016-
0357
Olayinka, O. H. (2021). Data driven customer segmentation and personalization strategies in modern business intelligence frameworks. World Journal of Advanced Research and Reviews, 12(3), 711-726. https://doi.org/10.30574/ wjarr.2021.12.3.0658
Osorio, K. G. C., Montealegre, E. V. J. G., Campoverde, E. J. Q., & Romero, H. C. (2022). Tableros y gráficos automatizados:
un enfoque a la visualización de datos e inteligencia de negocio. Ciencia Latina Revista Científica Multidisciplinar,
6(4), 2624-2641. https://doi.org/10.37811/cl_rcm.v6i4.2784
Popovič, A., Puklavec, B., & Oliveira, T. (2019). Justifying business intelligence systems adoption in SMEs: Impact of systems use on firm performance. Industrial Management & Data Systems, 119(1), 210-228. https://doi. org/10.1108/imds-02-2018-0085
PRO ECUADOR. (2025, abril 25). Tendencias en el consumo de café 2025. https://www.proecuador.gob.ec/tendencias- en-el-consumo-de-cafe-2025/
Ramírez, E. B., Estrella, C. W. G., & Gárate, S. K. 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), 38-53. https://doi.org/10.51252/rcsi. v1i2.167
Seenivasan, D. (2023). Real-time data processing with streaming ETL. International Journal of Science and Research,
12(11), 1-10. https://doi.org/10.21275/sr24619000026
Shaikh, D. A. A., Kumar, M. A., Syed, D. A. A., & Shaikh, M. Z. (2021). A two-decade literature review on challenges faced by SMEs in technology adoption. Academy of Marketing Studies Journal, 25(3).
Siddharth, K., Patra, G. K., Chandrababu, K., Janardhana Rao, S., & Sanjay Ramdas, B. (2023). Data-Driven Management: The Impact of Visualization Tools on Business Performance. J Contemp Edu Theo Artific Intel: JCETAI, 101. https://doi.org/10.2139/ssrn.5029418
Singh, G., Kumar, A., Singh, J., & Kaur, J. (2023, March). Data visualization for developing effective performance dashboard with Power BI. In 2023 International Conference on Innovative Data Communication Technologies and Application (ICIDCA) (pp. 968-973). IEEE. https://doi.org/10.1109/icidca56705.2023.10100169
Slusarczyk Antosz, M. (2024). Inteligencia de negocios – Power BI (J. C. Arteaga Fernández, Ed.). Editorial Arteaga
Fernández.
Tsiu, S. V., Ngobeni, M., Mathabela, L., & Thango, B. (2025). Applications and competitive advantages of data mining and business intelligence in SMEs performance: A systematic review. Businesses, 5(2), 22. https://doi.org/10.2139/ ssrn.4958874
Uribe, J. J. M. (2024). Big data e inteligencia de negocios aplicado en el sector gastronómico. Infometric@-Serie
Ingeniería, Básicas y Agrícolas, 7(1).
Published
Issue
Section
License
Copyright (c) 2025 Pierre Desfrancois, José David Abad Heredia
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
