|
INCORPORACIóN DE ELEMENTOS DE INTELIGENCIA DE NEGOCIOS EN EL PROCESO DE ADMISIóN Y MATRíCULA DE UNA UNIVERSIDAD CHILENADOI: 10.4067/S0718-33052010000300012 Keywords: business intelligence, data warehouse, data mart, kpi, etl, olap, dashboard, pentaho. Abstract: 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.
|