Ingeniare. Revista chilena de ingeniería
versión ISSN 0718-3305
ZAMBRANO MATAMALA, Carolina; ROJAS DIAZ, Darío; CARVAJAL CUELLO, Karina y ACUNA LEIVA, Gonzalo. Analysis of students' academic performance using data warehouse and neural networks. Ingeniare. Rev. chil. ing. [online]. 2011, vol.19, n.3, pp. 369-381. ISSN 0718-3305. doi: 10.4067/S0718-33052011000300007.
Every day organizations have more information because their systems produce a large amount of daily operations which are stored in transactional databases. In order to analyze this historical information, an interesting alternative is to implement a Data Warehouse. In the other hand, Data Warehouses are not able to perform predictive analysis for themselves, but machine learning techniques can be used to classify, grouping and predict historical information in order to improve the quality of analysis. This paper depicts architecture of a Data Warehouse useful to perform an analysis of students' academic performance. The Data Warehouse is used as input of a Neural Network in order to analyze historical information and forecast. The results show the viability of using Data Warehouse for academic performance analysis and the feasibility of predicting the number of approved courses for students using only their own historical information.
Palabras clave : Data warehouse; neural networks; historical analysis; prediction; strategic information.