Evaluación del rendimiento académico, utilizando herramientas de business intelligence: un enfoque basado en datos
Academic performance evaluation using business intelligence tools: a data-driven approach
DOI:
https://doi.org/10.56712/latam.v5i6.3080Palabras clave:
business intelligence, power bi, análisis de rendimiento académico, indicadores de desempeño, educación superiorResumen
Este estudio tuvo como objetivo diseñar e implementar un dashboard de Business Intelligence (BI) para analizar el rendimiento académico. Utilizando herramientas como Power BI, SQL Server Integration Services (SSIS) y SQL Server Analysis Services (SSAS), se recopilaron, transformaron y analizaron datos académicos, proporcionando una plataforma visual e interactiva para apoyar la toma de decisiones educativas. Entre los objetivos específicos estuvieron la creación de indicadores clave de desempeño (KPIs), la identificación de patrones de rendimiento estudiantil y la mejora de la visibilidad sobre el desempeño académico. El dashboard abarca datos del período 2021-2023, mostrando tasas de aprobación (89.4% en 2023), reprobación (10.6% en 2023), promedios de calificaciones por curso y rendimiento por asignatura. Además, permite segmentar la información por niveles, materias y periodos académicos, identificando áreas críticas donde los estudiantes enfrentan mayores dificultades. Esto facilita la intervención oportuna de las autoridades educativas y la optimización de estrategias pedagógicas. También se identificaron diferencias significativas en el rendimiento entre paralelos y géneros, información esencial para desarrollar estrategias educativas más inclusivas y efectivas. El uso de herramientas BI no solo mejora el análisis y seguimiento del rendimiento estudiantil, sino que también contribuye a una toma de decisiones más informada, transparente y eficiente en las instituciones educativas. En conclusión, esta solución de BI representa un recurso clave para transformar la gestión académica, optimizar recursos y fomentar un aprendizaje más efectivo.
Descargas
Citas
Al-Debei, M. M., & Avison, D. (2010). Developing a unified framework of the business model concept. European Journal of Information Systems, 19(3), 359-376. https://doi.org/10.1057/ejis.2010.21
Amigo Sañudo, R. (2022). Optimización de Modelos Estrella para Análisis de Rendimiento Académico. Revista de Ingeniería y Tecnología Educativa, 32(2), 132-146. https://doi.org/10.1016/j.rite.2022.03.001
Anderson, R., & Davis, J. (2019). Leveraging Power BI for institutional effectiveness. Information Systems Journal, 29(5), 659-674. https://doi.org/10.1111/isj.12257
Anderson, T., & Larson, R. (2020). Predictive analytics for improving student outcomes. International Journal of Education Data Science, 12(2), 156-170.
Arnott, D., Lizama, F., & Song, Y. (2017). Patterns of business intelligence systems use in organizations. Decision Support Systems, 97, 58-68. https://doi.org/10.1016/j.dss.2017.03.005
Bagby, J. W. (2024). Data Warehousing and Mining: Leveraging Big Data for Business Success. Journal of Data Science and Management, 18(1), 45-60.
Bagchi, S., & Tulinsky, A. (2019). Using predictive analytics for student performance and retention. Journal of Higher Education Management, 34(3), 53-65.
Baker, R., & Salter, B. (2021). BI dashboards and academic performance tracking in universities. Journal of Data-Driven Education, 4(1), 45-58.
Brown, K. M., & Martin, R. T. (2021). Power BI applications in education management. Journal of Data Science Education, 5(3), 89-103.
Calof, J., Arcos, R., & Sewdass, N. (2018). Competitive intelligence practices of European firms. Technology Analysis & Strategic Management, 30(6), 658-671. https://doi.org/10.1080/09537325.2017.1402229
Chaudhuri, S., Dayal, U., & Narasayya, V. (2011). An overview of business intelligence technology. Communications of the ACM, 54(8), 88-98. https://doi.org/10.1145/1978542.1978562
Chen, Y., Li, C., & Wang, H. (2022). Big Data and Predictive Analytics for Business Intelligence: A Bibliographic Study (2000–2021). Forecasting, 4(4), 767-786. https://doi.org/10.3390/forecast4040046
Davenport, T. H., & Harris, J. G. (2017). Competing on analytics: The new science of winning. Harvard Business Review Press.
Davis, K., & Griffin, L. (2022). The future of BI in higher education. Journal of Information Systems, 17(5), 127-140.
Eggert, M., & Alberts, J. (2020). Frontiers of business intelligence and analytics 3.0: A taxonomy-based literature review and research agenda. Business Research, 13, 685-739. https://doi.org/10.1007/s40685-020-00122-4
Evans, M., & Roberts, S. (2020). Business intelligence applications in higher education: A review. Journal of Educational Research and Data Science, 11(2), 50-65.
Farooq, R. (2023). Knowledge management and performance: a bibliometric analysis based on Scopus and WOS data (1988–2021). Journal of Knowledge Management, 27(7), 1948-1991. https://doi.org/10.1108/JKM-12-2022-0999
Green, R., & Stone, C. (2021). The role of visualization in BI for education management. Visual Analytics and Data Science, 12(3), 145-156.
Hernandez, R., & McPherson, J. (2020). Business intelligence applications in student performance tracking. Journal of Higher Education Research, 25(1), 45-59.
James, T., & Howard, K. (2019). BI for improving student engagement in higher education. Journal of Learning Technology, 8(1), 65-80.
Johnson, A. (2019). Enhancing student success with BI dashboards. Journal of Educational Management, 11(4), 123-138.
Johnson, L., & Lee, H. (2021). AI and BI integration in modern universities. Journal of Information Technology Education: Innovations in Practice, 20(1), 121-136. https://doi.org/10.28945/4796
Jones, D. P., & Keller, S. A. (2018). Predictive models for student success in higher education. Journal of Learning Analytics, 5(2), 56-72. https://doi.org/10.18608/jla.2018.52.5
Lee, H., & Park, D. (2020). Leveraging AI and BI in modern education. Journal of Applied Data Science, 6(3), 221-230.
Li, M., Xu, Y., & He, F. (2019). Enhancing business intelligence in supply chain management through deep learning and big data technologies. Supply Chain Management: An International Journal, 24(6), 642-654. https://doi.org/10.1108/SCM-03-2018-0142
Martinez, L., & O’Neil, P. (2021). The use of BI tools in student retention strategies. Journal of Learning Analytics, 8(2), 23-35. https://doi.org/10.18608/jla.2021.1
Miller, K., & Henderson, D. (2020). Predictive analytics in education: The role of BI. Computers & Education, 148, 103817. https://doi.org/10.1016/j.compedu.2020.103817
Nazate Enríquez, J. P. (2022). Métodos de Extracción y Transformación de Datos en Proyectos de Business Intelligence. International Journal of Information Systems and Business Intelligence, 10(3), 25-38. https://doi.org/10.1108/IJISBI-05-2022-0158
Nguyen, A., & Smith, T. (2021). Power BI in higher education: Improving decision making. Journal of Data Science Research, 9(2), 78-90.
Nguyen, P. T., & Zhang, Z. (2020). The role of analytics in enhancing educational performance. Educational Technology Research and Development, 68(2), 221-237. https://doi.org/10.1007/s11423-019-09726-z
Park, J., & Taylor, P. (2019). The impact of data analytics on academic performance. Information Systems Frontiers, 21(6), 1423-1434. https://doi.org/10.1007/s10796-019-09918-w
Petersen, R., & Cooper, D. (2021). Integrating BI and learning analytics in educational settings. Educational Data Mining and Applications, 7(4), 22-35.
Rodriguez, M., & Walsh, P. (2018). BI tools in academic performance tracking. Data Science in Education, 3(2), 54-68.
Smith, J. T., & Venkatesh, V. (2020). Impact of BI tools on organizational decision-making. Information Systems Research, 31(4), 875-900. https://doi.org/10.1287/isre.2019.0877
Trieu, V. H. (2017). Getting value from Business Intelligence systems: A review and research agenda. Decision Support Systems, 93, 111-124. https://doi.org/10.1016/j.dss.2016.09.019
Turetken, O., & Sharda, R. (2021). Modeling business intelligence and analytics capabilities to support business process improvement. Information Systems Frontiers, 23(5), 1-18. https://doi.org/10.1007/s10796-021-10158-1
Williams, G., & Hernández, M. (2020). Business intelligence for student retention. Journal of Business Research, 110, 95-103. https://doi.org/10.1016/j.jbusres.2019.09.015
Williams, J., & Carter, N. (2020). Improving institutional performance with BI tools. Journal of Education Technology, 5(4), 101-115.
Wilson, A., & Thompson, P. (2020). Exploring the role of BI in modern education institutions. Journal of Data Management, 13(4), 93-108.
Wong, W. P., & Teo, W. L. (2014). Evaluating the effectiveness of business intelligence in higher education: An exploratory study. Journal of Educational Technology & Society, 17(4), 265-277.
