MANAGEMENT REPORTING SYSTEM BASED ON DATA WAREHOUSES, FOR THE GRADE PROCESS OF THE ACADEMIC MANAGEMENT SYSTEM OF THE UNIVERSIDAD LAICA ELOY ALFARO DE MANABÍ
Keywords:
data, information, reports, systemAbstract
In the current technology related to Business Intelligence, data mining is the process of extracting information from different sources, analyzing it and presenting it in tables or reports that help the company to better understand the data and through these the operations carried out within the organization, thus obtaining relevant statistics for better decision making in the administrative field. According to what has been mentioned about this technology, we propose the design and implementation of a management reporting system based on data warehouses, for the grading process of the Academic Management System of the Universidad Laica Eloy Alfaro de Manabí. The proposed reporting system is developed through the Ralph Kimball methodology that provides an empirical basis for the implementation of data warehouses, the project will be built through the design and development of a data warehouse through Transformation, Extraction and Loading (ETL) techniques, This will later allow the elaboration of data cubes that will be used to lighten the load of the Academic Management System and to deduce relevant information to obtain the necessary reports to improve decision making in the grading process of the Universidad Laica Eloy Alfaro de Manabí.
Keywords: data, information, reports, system.
Downloads
References
Curto J. (2010). Introducción al Business Intelligence. Barcelona: OUC.
Dirección de Informática e Innovación Tecnológica (2020). Estructura orgánica y áreas de trabajo. Obtenido de: https://departamentos.uleam.edu.ec/diit/
Espinosa R. (2009). Fases en la implantación de un sistema DW. Obtenido de: https://churriwifi.wordpress.com/2009/12/05/5-fases-en-la-implantacion-de-un-sistema-dw-metodologia-para-la-construccion-de-un-dw/
Kimball et al., The Data Warehouse Lifecycle Toolkit. 2nd Edition. New York, Wiley, 2008.
Marqués M. (2011). Base de Datos Obtenido de: https://libros.metabiblioteca.org/bitstream/001/353/5/978-84-693-0146-3.pdf
Rivadera G. (2010). La metodología de Kimball para el diseño de almacenes de datos. Obtenido de: https://www.ucasal.edu.ar/htm/ingenieria/cuadernos/archivos/5-p56-rivadera-formateado.pdf
Rodríguez J. (2015). Como hacer inteligente su negocio: Business Intelligence a su alcance. México: Patria.
Silberschatz, K. &. (2011). Database System (Sexta ed.). New York: McGraw-Hill.
Solano A. (2003) Toma de Decisiones Gerenciales. Obtenido de: https://dialnet.unirioja.es/descarga/articulo/4835719.pdf
