Business Intelligence and Analytics based tool for academic decision making. Case of Bluefields Indian & Caribbean University
DOI:
https://doi.org/10.5377/farem.v12i46.16489Keywords:
ETL, scorecard, ecision efficiency, OLAP, Higher Education InstitutionsAbstract
In recent years, organizations and Higher Education Institutions have generated large amounts of data through various computer systems. This has marked the transition of an era; now, we are in the era of Big Data where efforts are focused on what to do with the data generated; due to this, Business Intelligence and Analytics, which encompass a set of technologies and strategies that allow analyzing data and providing information to support decision making. Bluefields Indian & Caribbean University (BICU), has expressed interest in recent years in acquiring and implementing tools that allow it to minimize the management time, analysis, extraction and visualization of its academic data. The objective of this project is the development of a Business Intelligence and Analytics based tool to increase the efficiency of decision making at BICU. The development was focused on Bill Inmon’s methodology; in this way, it is guaranteed that the data are organized by topics and entity known by the workers of the institution to ensure a good interpretation of the data, the design of the Data Warehouse, was carried out in a top-down way. Satisfactory results were obtained; however, there are aspects that can be improved, among those considered is to incorporate predictive models to predict whether the academic history prior to college, location of origin, ethnicity or gender influences the academic performance of students.
Downloads
References
Arjun. (2017). Bill Inmon vs. Ralph Kimball. Data Analytics and BI WORLD. https://arjunjune.wordpress.com/2017/03/20/bill-inmon-vs-ralph-kimball/
Boulila, W., Al-kmali, M., Farid, M., & Mugahed, H. (2018). A business intelligence based solution to support academic affairs: case of Taibah University. Wireless Networks, April 2020. https://doi.org/10.1007/s11276-018-1880-3
Cardoso, E., & Su, X. (2022). Designing a Business Intelligence and Analytics Maturity Model for Higher Education: A Design Science Approach. Applied Sciences, 12(9), 4625. https://doi.org/10.3390/app12094625
Chiang, R. H. L., Goes, P., & Stohr, E. A. (2012). Business Intelligence and Analytics Education, and Program Development. ACM Transactions on Management Information Systems, 3(3), 1-13. https://doi.org/10.1145/2361256.2361257
Combita Niño, H. A., Cómbita Niño, J. P., & Morales Ortega, R. (2020). Business intelligence governance framework in a university: Universidad de la costa case study. International Journal of Information Management, 50(October 2018), 405-412. https://doi.org/10.1016/j.ijinfomgt.2018.11.012
Combita Niño, H. A., & Morales Ortega, R. C. (2016). El control interno como elemento importante dentro del sistema de gestión de la innovación: Una propuesta desde la cibernética. Espacios, 37(21), 15.
Eteng, O. (2020). Setting up ETL in Hadoop. Hevodata. https://hevodata.com/learn/etl-in-hadoop/
Farroñan, A. (2020). Implementación de Inteligencia de Negocios con uso de la herramienta Extracción, Transformación y Carga en las organizaciones para la toma de decisiones: https://orcid.org/0000-0003-3520-5076
Hussinki, H. (2022). Business Analytics and Firm Performance: A Literature Review. European Conference on Knowledge Management, 23(1), 527-532. https://doi.org/10.34190/eckm.23.1.560
Manyika, J., Chui, M., Brown, B., Bughin, J., Dobbs, R., Roxburgh, C., & Hung Byers, A. (2011). Big data: The next frontier for innovation, competition and productivity. McKinsey Global Institute, June, 156. https://bigdatawg.nist.gov/pdf/MGI_big_data_full_report.pdf
Mikalef, P., Pappas, I. O., Krogstie, J., & Pavlou, P. A. (2020). Big data and business analytics: A research agenda for realizing business value. Information & Management, 57(1), 103237. https://doi.org/10.1016/j.im.2019.103237
Quiñonez Corado, W. E. (2017). Kimball e Inmon y el Diseño de Data Warehouses. https://es.linkedin.com/pulse/kimball-e-inmon-y-el-diseño-de-data-warehouses-william-quiñonez
Rostran Francis, K. M., Davis Andrews, O. K., & Calero, J. A. (2018). Propuesta de un nuevo sitio web para la Bluefields Indian and Caribbean University (BICU) recinto Bluefields. BICU.
Toasa, R. M., & Léon Rodríguez, G. (2021). La visualización de datos académicos: Una revisión del estado actual en el contexto universitario - ProQuest. Revista Ibérica de Sistemas e Tecnologias de Informação, 45, 255-267. https://www.proquest.com/openview/c69022f1c41b57bbe3cb9c505483cc55/1?pq-origsite=gscholar&cbl=1006393
Vazquez-Ingelmo, A., Garcia-Penalvo, F. J., & Theron, R. (2019). Information Dashboards and Tailoring Capabilities - A Systematic Literature Review. IEEE Access, 7, 109673-109688. https://doi.org/10.1109/ACCESS.2019.2933472
Villachica Pérez, Y. N., Ordoñez Cuthbert, D. K., & Sambola, D. M. (2022). Modelo predictivo basado en Machine Learning dirigido a PYMES de venta, caso de estudio Bluefields. Ciencia e Interculturalidad, 30(01), 139-146. https://doi.org/10.5377/rci.v30i01.14267
Published
Issue
Section
License
Copyright (c) 2023 Revista Científica de FAREM-Esteli
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.