SciELO - Scientific Electronic Library Online

 
vol.18 número3GESTIÓN DEL CONOCIMIENTO, LIDERAZGO, DISEÑO E IMPLEMENTACIÓN DE LA ESTRATEGIA: UN ESTUDIO EMPÍRICO EN PEQUEÑAS Y MEDIANAS EMPRESASREDUCCIÓN DEL ANCHO DE BANDA DE MATRICES DISPERSAS MEDIANTE LA INTRODUCCIÓN DE NUEVAS VARIABLES índice de autoresíndice de materiabúsqueda de artículos
Home Pagelista alfabética de revistas  

Ingeniare. Revista chilena de ingeniería

versión On-line ISSN 0718-3305

Resumen

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.

        · resumen en Español     · texto en Español     · pdf en Español