Ingeniare. Revista chilena de ingeniería
versión On-line ISSN 0718-3305
FUENTES TAPIA, Luis y VALDIVIA PINTO, Ricardo. INCORPORATION OF BUSINESS INTELLIGENCE ELEMENTS IN THE ADMISSION AND REGISTRATION PROCESS OF A CHILEAN UNIVERSITY. Ingeniare. Rev. chil. ing. [online]. 2010, vol.18, n.3, pp. 383-394. ISSN 0718-3305. http://dx.doi.org/10.4067/S0718-33052010000300012.
This paper describes a process oriented to the addition of business intelligence (BI) elements at Universidad de Tarapacá (UTA), Arica, Chile. For the purpose, a data mart (DM) was implemented, focused on the Admission and Registration area of Academic Vice-Rectory. 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 DM, allowed users of the Academic Vice-Rectory 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.
Palabras clave : Business intelligence; data warehouse; data mart; KPI; ETL; OLAP; dashboard; Pentaho.