SYSTEM OF MANAGEMENT REPORTS BASED ON DATA STORES, FOR THE ENROLLMENT PROCESS OF THE ACADEMIC MANAGEMENT SYSTEM OF THE UNIVERSIDAD LAICA ELOY ALFARO DE MANABÍ
Keywords:
Business intelligence, data warehouse, dashboard, Power BIAbstract
This proyect describes a process oriented to the addition of business intelligence (BI) elements at Universidad Laica Eloy Alfaro de Manabí (ULEAM) Manta, Ecuador.The Academic Management System (SGA), being housed in a single database manager, generates a massive amount of data flow witch causes is intermittence, and as it does not hace a reporting system based on BI for taking decision maker implemented a data warehouse (DW) focused on the enrollment process of the Acacademic Management System. Its development required carrying out activities such as to obtain business requirements, to investigate the area key performance indicator (KPI), to analyze several internal information sources and to develop a dimensional model based on the Kimball star schema. For proper implementation and integration of these data repositories, extraction, transformation and loading (ETL) processes were carried out from two data sources. The creation of this DW, allowed the administrative staff of the academic management system to visualize the information they required through online analytical processing (OLAP) tools. The implementation was complemented with reporting and dashboards tools. The integration of these elements formed a business intelligence platform, which allows supporting of the information and analysis requirements associated to the admission and registration process.
Keywords: Business intelligence, data warehouse, dashboard, Power BI.
Downloads
References
Brito, D. (2020). RALF KIMBALL. Obtenido de http://inteligenciadenegociosdiegobrito.blogspot.com/2014/01/la-metodologia-de-kimball.html
Dresner, T., & Barkan, P. (1989). A review and classification of variable valve timing mechanisms. SAE Transactions, 1275-1288.
Fidias G., A. (1997). El Proyecto de Investigación: Introducción a la metodología científica. Caracas: Editorial Episteme.
Jaramillo Delgado, F. (2016), “Implementación de una data warehouse para la toma de decisiones en el área logística de la compañía Pronaca.”. [Tesis de grado, Universidad Regional Autónoma de los Andes, Ecuador]
Kimball, R. R. (2016). The Lifecycle: Toolkit . New York: Wiley.
Larissa T. Moss, S. A. (2003). Ruta de inteligencia empresarial: el ciclo de vida completo del proyecto para aplicaciones de soporte de decisiones. New York: Addison Wesley.
Lema Recalde, W. A. (2015). Implementación de una aplicación móvil para la toma de lectura y entrega de planillas del consumo de energía de los medidores de luz para la empresa MARSED S .A. Obtenido de Repositorio Institucional Uniandes: https://tinyurl.com/ydylqwdn
Mundy & Thornthwaite. (2006). The Microsoft Data Warehouse Toolkit With SQL Server 2005 and the Microsoft Business Intelligence. Indianapolis: Wiley.
Rivadeneira, G. (2010). La metodología de Kimball para el diseño de almacenes de datos (Data warehouses). Obtenido de Universidad Catolica de Salta: https://www.ucasal.edu.ar/htm/ingenieria/cuadernos/archivos/5-p56-rivadera-formateado.pdf
Rojas Zaldívar, A. (2014). Implementación de un Data Mart como solución de inteligencia de negocios, bajo la metodología de Ralph Kimball para optimizar la toma de decisiones en el Departamento de Finanzas de la Contraloría General de la República.
