Data Warehouse for Monitoring the Academic Performance of Students from University

This article describes the design and implementation of a data warehouse that provides indicators of students’ academic performance at a university in northern Chile. The Hefesto methodology was used for its development, which consists of a series of steps that are rigorously followed to obtain optimal results. This data warehouse integrates the history of subjects and student grades, allowing the university to track student progress and analyze indicators such as the current and historical pass/fail rate. In this way, the university can generate early detection mechanisms to ensure equity in the teaching-learning processes and maintain an adequate level of student retention in their academic programs. The result of this work is a multidimensional model that stores key indicators of student academic performance, with visualizations that include integrated graphs and tables. This allows for simple and efficient online analysis using QlikView as an ad-hoc tool to support institutional and academic program decision-making. Finally, both the authorities and the academic community that require and use these tools express their full satisfaction with this work.