Analytical Data Mart for the Monitoring of University Accreditation Indicators

Abstract

The CAACES (Consejo de Evaluación, Acreditación y Aseguramiento de la Calidad de la Educación Superior), develops evaluation processes to accredit Higher Education Institutions of Ecuador. In order to support the accreditation process we propose an analytical data mart to a) obtain suitable information for its fast understanding and management, b) avoid the dispersion of the data required for the university accreditation. The implementation was initially developed with the indicators of students' criterion according to Institutional Evaluation Model of Universities and Polytechnic Schools incorporated by CEAACES and in the future, other indicators can be added by other accreditation criteria. The project was developed using the Kimball methodology and an open source tool of BI (Business Intelligence), the Pentaho suite. The BI solution allows the efficient monitoring of indicators prior to university accreditation, reducing the response time and resources in the report generation process.