Pengembangan Data Warehouse dan Aplikasi OLAP pada Data Evaluasi Proses Belajar Mengajar IPB

Abstract

Evaluation of Teaching and Learning Process (EPBM) is one measure of success in a learning process. Every year IPB always holds EPBM at least twice in one academic year. Increasingly, EPBM data is getting more and more difficult to analyze and to find information, either expressed or implied. By using data warehouse technology and an application On-line Analytical Processing (OLAP), IPB’s stakeholder can analyze and find information on the data. The main objective of this research is to develop a data warehouse and OLAP applications on EPBM data of IPB using Microsoft Business Intelligence as OLAP server. This study begin by collecting the data, integration and data reduction, data cleansing, data transformation, data loading, and OLAP implementations. The data warehouse schema used in this research is the galaxy scheme which has two facts (Course fact and Lecturer fact) and 9-dimensions (semester, academic year, courses, lecturers, faculty, department, lecturers education, and lecturers strata). To create a data warehouse and OLAP applications, we generate a data cube called EPBM Data. The results of the data cube can be visualized into various types of graphic models, such as bar graphs, line graphs, pie charts, and so forth. The results of the data cube is visualized using Microsoft Sharepoint 2010.