Methodologies for the construction of business intelligence solutions




data, integration, methodologies, prosecution, solutions, warehouse


In organizations, business intelligence is a technological tool par excellence for the analysis and processing of internal historical data exploited in favor of the organization, generating timely and reliable information. Our objective is to identify the methodologies for the implementation of business intelligence solutions based on data warehouse, as well as their adaptability to different types of companies. To do this, we carry out a review of the state of the art of articles published in journals indexed in bibliographic databases such as: Web Of Science, Scopus, ScienceDirect, SciELO through Google Scholar with the purpose of having a selection of quality information that they provide us. important contributions to this review. We identify that the methodologies allow the construction of the solution efficiently through phases supported by tools, models and frameworks for its construction; The empirical methodology being the most used for the construction of these business intelligence solutions.


Download data is not yet available.


Al-Okaily, A., Al-Okaily, M., Teoh, A. P., & Al-Debei, M. M. (2022). An empirical study on data warehouse systems effectiveness: the case of Jordanian banks in the business intelligence era. EuroMed Journal of Business, May. DOI:

Ali Qhal, E. M. (2022). Role of Business Intelligence and Knowledge Management in Solving Business Problems. Tehnički Glasnik, 16(3), 371–378. DOI:

Antoniolli, A. F., Naspolini, H. F., de Abreu, J. F., & Rüther, R. (2022). Development of technical and statistical algorithm using Business Intelligence tools for energy yield assessment of large rooftop photovoltaic system ensembles. Sustainable Energy Technologies and Assessments, 49(November 2021). DOI:

Azevedo, J., Duarte, J., & Santos, M. F. (2021). Implementing a business intelligence cost accounting solution in a healthcare setting. Procedia Computer Science, 198(2021), 329–334. DOI:

Basile, L. J., Carbonara, N., Pellegrino, R., & Panniello, U. (2022). Business intelligence in the healthcare industry: The utilization of a data-driven approach to support clinical decision making. Technovation, March 2021, 102482. DOI:

Biagi, V., Patriarca, R., & Di Gravio, G. (2022). Business intelligence for IT governance of a technology company. Data, 7(1). DOI:

Bimonte, S., Billaud, O., Fontaine, B., Martin, T., Flouvat, F., Hassan, A., Rouillier, N., & Sautot, L. (2021). Collect and analysis of agro-biodiversity data in a participative context: A business intelligence framework. Ecological Informatics, 61(December 2020). DOI:

Božič, K., & Dimovski, V. (2019). Business intelligence and analytics use, innovation ambidexterity, and firm performance: A dynamic capabilities perspective. Journal of Strategic Information Systems, 28(4), 101578. DOI:

Castiblanco Montañez, R. A., Coronado Veloza, C. M., Morales Ballesteros, L. V., Polo González, T. V., & Saavedra Leyva, A. J. (2022). Hemorragia postparto: intervenciones y tratamiento del profesional de enfermería para prevenir shock hipovolémico. Revista Cuidarte. DOI:

Castillo Abarca, L., Vega Zepeda, V., & Meneses Villegas, C. (2020). Alineando el ciclo de vida de un proyecto con un modelo de madurez BI: una propuesta para la etapa de análisis preliminar. Ingeniare. Revista Chilena de Ingeniería, 28(4), 629–644. DOI:

Cerda-Leiva, L., Araya-Castillo, L., & Barrientos Oradini, N. (2020). ¿Cuánto Se Ha Avanzado En Proporcionar Analítica E Inteligencia De Negocios a Las Pymes? Investigacion & Desarrollo, 19(2), 167–175. DOI:

Cruz, L. M. H., Lao, F. J. B., Alvarez, D. C. M., Téllez, M. C., Canul, R. C. C., May, J. I. S., & Guerrero, M. D. F. (2022). Use of the Hefesto v2.0 methodology to implement a Data warehouse: Case applied COVID-19. Iberian Conference on Information Systems and Technologies, CISTI, 2022-June. DOI:

Dahr, J. M., Hamoud, A. K., Najm, I. A., & Ahmed, M. I. (2022). Implementing Sales Decision Support System Using Data Mart Based on Olap, Kpi, and Data Mining Approaches. Journal of Engineering Science and Technology, 17(1), 275–293.

Díaz Vásquez, R. A., Espinoza Acosta, L. J., & Cabrera Checa, A. M. (2022). Power BI como herramienta de apoyo a la toma de decisiones. Revista Universidad y Sociedad, 14(S3), 195–207.

Duarte, R., Guimarães, T., & Santos, M. F. (2021). A Business Intelligence Platform for Portuguese Misericórdias. Procedia Computer Science, 198(2021), 341–346. DOI:

Duque, J., Godinho, A., & Vasconcelos, J. (2021). Knowledge data extraction for business intelligence A design science research approach. Procedia Computer Science, 204(2022), 1301–139. DOI:

Figalist, I., Elsner, C., Bosch, J., & Olsson, H. H. (2022). Breaking the vicious circle: A case study on why AI for software analytics and business intelligence does not take off in practice. Journal of Systems and Software, 184, 111135. DOI:

Fraihat, S., Salameh, W. A., Elhassan, A., Tahoun, B. A., & Asasfeh, M. (2021). Business Intelligence Framework Design and Implementation: A Real-estate Market Case Study. Journal of Data and Information Quality, 13(2). DOI:

Freitas Júnior, O. de G., de Carvalho, V. D. H., Barros, P. A. M., & Braga, M. de M. (2022). Uma Experiência com Business Intelligence para apoiar a Gestão Acadêmica em uma Universidade Federal Brasileira. RISTI - Revista Ibérica de Sistemas e Tecnologias de Informacão, 46, 5–20. DOI:

García Estrella, C. W., Barón Ramírez, E., & Sánchez Gárate, S. K. (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. DOI:

Gonzales, R., & Wareham, J. (2019). Analysing the impact of a business intelligence system and new conceptualizations of system use. Journal of Economics, Finance and Administrative Science, 24(48), 345–368. DOI:

Guitarra Romero, R. (2019). Prospectiva e Inteligencia Estratégica Aplicada a la Micro, Pequeña y Mediana Empresa. Tendencias, 20(1), 107–129. DOI:

Hamoud, A. K., Hussein, M. K., Alhilfi, Z., & Sabr, R. H. (2021). Implementing data-driven decision support system based on independent educational data mart. In International Journal of Electrical and Computer Engineering (Vol. 11, Issue 6, pp. 5301–5314). DOI:

Hindle, G. A., & Vidgen, R. (2018). Developing a business analytics methodology: A case study in the foodbank sector. European Journal of Operational Research, 268(3), 836–851. DOI:

Khatibi, V., Keramati, A., & Shirazi, F. (2020). Deployment of a business intelligence model to evaluate Iranian national higher education. Social Sciences & Humanities Open, 2(1), 100056. DOI:

Lokaadinugroho, I., Girsang, A. S., & Burhanudin, B. (2021). Tableau Business Intelligence Using the 9 Steps of Kimball’s Data Warehouse & Extract Transform Loading of the Pentaho Data Integration Process Approach in Higher Education. Engineering, MAthematics and Computer Science (EMACS) Journal, 3(1), 1–11. DOI:

Lopes, J., Guimarães, T., & Santos, M. F. (2020). Adaptive business intelligence: A new architectural approach. Procedia Computer Science, 177, 540–545. DOI:

Marzouk, M., & Hanafy, M. (2022). Modelling maintainability of healthcare facilities services systems using BIM and business intelligence. Journal of Building Engineering, 46(December 2021), 103820. DOI:

Mora-Vicarioli, F. R., Arce-Solano, J. L., Padilla-Romero, K., & Muñiz-Umaña, G. (2021). Implementación de un sistema de inteligencia de negocios. Escuela de Ciencias de la Administración UNED. Revista Electrónica Calidad En La Educación Superior, 12(1), 76–103. DOI:

Moreno, V., Cavazotte, F., & de Souza Carvalho, W. (2020). Business intelligence and analytics as a driver of dynamic and operational capabilities in times of intense macroeconomic turbulence. Journal of High Technology Management Research, 31(2), 100389. DOI:

Nakhal A, A. J., Patriarca, R., Di Gravio, G., Antonioni, G., & Paltrinieri, N. (2021). Investigating occupational and operational industrial safety data through Business Intelligence and Machine Learning. Journal of Loss Prevention in the Process Industries, 73(February), 104608. DOI:

Nithya, N., & Kiruthika, R. (2021). Impact of Business Intelligence Adoption on performance of banks: a conceptual framework. Journal of Ambient Intelligence and Humanized Computing, 12(2), 3139–3150. DOI:

Niu, Y., Ying, L., Yang, J., Bao, M., & Sivaparthipan, C. B. (2021). Organizational business intelligence and decision making using big data analytics. Information Processing and Management, 58(6), 102725. DOI:

Olszak, C. M. (2022). Business Intelligence Systems for Innovative Development of Organizations. Procedia Computer Science, 207, 1754–1762. DOI:

Orcajo, J., & Fonseca, P. (2022). Business Intelligence’s Self-Service Tools Evaluation. Technologies. DOI:

Phillips-Wren, G., Daly, M., & Burstein, F. (2021). Reconciling business intelligence, analytics and decision support systems: More data, deeper insight. Decision Support Systems, 146(September 2020), 113560. DOI:

Risco-Ramos, R., Pérez-Aguilar, D., Casaverde-Pacherrez, L., & Vásquez-Díaz, E. (2022). Use of a business intelligence framework in the management of the quality of electricity supply in small and medium-sized companies. Revista DYNA, 89(221), 31–40. DOI:

Saura, J. R., & Bennett, D. R. (2019). A three-stage method for data text mining: Using UGC in business intelligence analysis. Symmetry, 11(4). DOI:

Schwade, F. (2021). Social Collaboration Analytics Framework: A framework for providing business intelligence on collaboration in the digital workplace. Decision Support Systems, 148(July 2020), 113587. DOI:

Shao, C., Yang, Y., Juneja, S., & GSeetharam, T. (2022). IoT data visualization for business intelligence in corporate finance. Information Processing and Management, 59(1), 102736. DOI:

Tardío, R., Maté, A., & Trujillo, J. (2022). Beyond TPC-DS, a benchmark for Big Data OLAP systems (BDOLAP-Bench). Future Generation Computer Systems, 132, 136–151. DOI:

Tavera Romero, C. A., Hamilton Ortiz, J., Khalaf, O. I., & Ríos Prado, A. (2021). Web application commercial design for financial entities based on business intelligence. Computers, Materials and Continua, 67(3), 3177–3188. DOI:

Tešendić, D., & Krstićev, D. B. (2019). Business intelligence in the service of libraries. Information Technology and Libraries, 38(4), 98–113. DOI:

Torres, R., & Sidorova, A. (2019). Reconceptualizing information quality as effective use in the context of business intelligence and analytics. International Journal of Information Management, 49(July 2018), 316–329. DOI:

Tunowski, R. (2020). Sustainability of commercial banks supported by business intelligence system. Sustainability (Switzerland), 12(11), 1–17. DOI:

Ulloa, P. A. G., Castillo, D. V. C., Mena, V. M. P., & Jacome, D. J. R. (2020). Business Intelligence in the Administrative Management of a Distribution Company in the Electricity Sector. 3C Tic, 9(3), 43–67. DOI:

Václav, C., Gabriel, F., Blanka, K., Libor, K., & Michal, T. (2021). Utilization of business intelligence tools in cargo control. Transportation Research Procedia, 53(2019), 212–223. DOI:

Vanegas, D. A., Tarazona Bermudez, G. M., & Rodriguez Rojas, L. A. (2020). Mejora de la toma de decisiones en ciclo de ventas del subsistema comercial de servicios en una empresa de IT. Revista Científica, 38(2), 174–183. DOI:

Varona-Taborda, M.-A., Mosquera-Ramírez, J.-C., Medina-Moreno, C.-A., Lemus-Muñoz, D.-F., Muñoz-Hernández, C.-J., Arias-Iragorri, C.-G., Varona-Taborda, M.-A., Mosquera-Ramírez, J.-C., Medina-Moreno, C.-A., Lemus-Muñoz, D.-F., Muñoz-Hernández, C.-J., & Arias-Iragorri, C.-G. (2021). Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity. Revista Facultad de Ingeniería, 30(58), 2021. DOI:

Villegas-Ch, W., Palacios-Pacheco, X., & Luján-Mora, S. (2020). A business intelligence framework for analyzing educational data. Sustainability (Switzerland), 12(14), 1–21. DOI:

Vinicio, F., Pineda, C., & Nuñez, W. (2022). Revista Ciencias Pedagógicas e Innovación Aplicación de técnicas de Business Intelligence ( BI ) y Big Data Analytics en entornos de aprendizaje virtual Applying Business Intelligence ( BI ) and Big Data Analytics techniques in virtual learning environmen. IX, 7–19. DOI:

Viteri, A. E., Cruzado, J. G., & Huaman, L. A. (2022). Methodology for Business Intelligence Solutions in Internet Banking Companies. International Journal on Advanced Science, Engineering and Information Technology, 12(3), 1173–1181. DOI:

Wang, J., Omar, A. H., Alotaibi, F. M., Daradkeh, Y. I., & Althubiti, S. A. (2022). Business intelligence ability to enhance organizational performance and performance evaluation capabilities by improving data mining systems for competitive advantage. Information Processing and Management, 59(6), 103075. DOI:

Xavier Reyes-Mena, F., Marcelo Fuertes-Diaz, W., Enrique Guzman-Jaramillo, C., Perez-Estevez, E., Fernando Bernal-Barzallo, P., & Javier Villacis-Silva, C. (2018). Application of business intelligence for analyzing vulnerabilities to increase the security level in an academic CSIRT. Revista Facultad De Ingenieria, Universidad Pedagogica Y Tecnologica De Colombia, 27(47), 21–29. DOI:

Xu, J. J., & Babaian, T. (2021). Artificial intelligence in business curriculum: The pedagogy and learning outcomes. International Journal of Management Education, 19(3), 100550. DOI:

Xu, Y., Li, X., Mustakim, F. bin, Alotaibi, F. M., & Abdullah, N. N. (2022). Investigating the business intelligence capabilities’ and network learning effect on the data mining for start-up’s function. Information Processing and Management, 59(5), 1–10. DOI:

Yasir, M., Attique, M., Latif, K., Chaudhary, G. M., Afzal, S., Ahmed, K., & Shahzad, F. (2021). Deep-learning-assisted business intelligence model for cryptocurrency forecasting using social media sentiment. Journal of Enterprise Information Management, ahead-of-print(ahead-of-print). DOI:

Yiu, L. D., Andy, C. Y., & Abe PL, J. (2020). Business Intelligence Systems and Operational Capability: An Empirical Analysis of High- Tech Sectors. 120(6), 1–42. DOI:

Zheng, W., Wu, Y. C. J., & Chen, L. (2018). Business intelligence for patient-centeredness: A systematic review. Telematics and Informatics, 35(4), 665–676. DOI:

Žigienė, G., Rybakovas, E., Vaitkienė, R., & Gaidelys, V. (2022). Setting the Grounds for the Transition from Business Analytics to Artificial Intelligence in Solving Supply Chain Risk. Sustainability, 14(19), 11827. DOI:




How to Cite

Perales-Domínguez, C., Sánchez-Calle, J. E., Lévano-Rodriguez, D., & Gallegos-Carrillo, K. (2024). Methodologies for the construction of business intelligence solutions . Revista Científica De Sistemas E Informática, 4(1), e612.

Similar Articles

1 2 3 > >> 

You may also start an advanced similarity search for this article.