Análisis de rendimiento académico estudiantil usando data warehouse y redes neuronales Analysis of students' academic performance using data warehouse and neural networks

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.

[1]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[2]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[3]  Eugen Diaconescu,et al.  The use of NARX neural networks to predict chaotic time series , 2008 .

[4]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[5]  M. Angélica Pinninghoff Junemann,et al.  Neural Networks to Predict Schooling Failure/Success , 2007, IWINAC.

[6]  Thomas G. Dietterich What is machine learning? , 2020, Archives of Disease in Childhood.

[7]  Barbara Dinter,et al.  Extending the E/R Model for the Multidimensional Paradigm , 1998, ER Workshops.

[8]  Meng Joo Er,et al.  NARMAX time series model prediction: feedforward and recurrent fuzzy neural network approaches , 2005, Fuzzy Sets Syst..

[9]  Ujjwal Maulik,et al.  Performance Evaluation of Some Clustering Algorithms and Validity Indices , 2002, IEEE Trans. Pattern Anal. Mach. Intell..

[10]  Gottfried Vossen,et al.  Conceptual Data Warehouse Design , 2000 .

[11]  N. Esther,et al.  Redes de neuronas artificiales en oceanografía. , 2013 .

[12]  Luca Cabibbo,et al.  A Logical Approach to Multidimensional Databases , 1998, EDBT.

[13]  Stefano Paraboschi,et al.  Designing data marts for data warehouses , 2001, TSEM.

[14]  Gavriel Salvendy,et al.  Handbook of industrial engineering : technology and operations management , 2001 .

[15]  J. Wyatt Decision support systems. , 2000, Journal of the Royal Society of Medicine.

[16]  Fugen Song,et al.  Forecasting chaotic time series of exchange rate based on nonlinear autoregressive model , 2010, 2010 2nd International Conference on Advanced Computer Control.

[17]  Simon Haykin,et al.  Neural Networks: A Comprehensive Foundation , 1998 .

[18]  Chris Todman Designing A Data Warehouse: Supporting Customer Relationship Management , 2001 .