Pembangunan Data Warehouse dan Aplikasi OLAP untuk Memantau Prestasi Mahasiswa Program Studi S1 Ilmu Komputer IPB

Abstract

Many factors influence Department of Computer Science students achievement. The factors such as GPA, student supervisor, status of study, and sum of competition achievement. These factors can be analyzed with the data processing to find the information patterns that can increase the student’s achievement. The academic and non academic’s data of Program Study S1 Computer Science student spread in some location. This data make long running queries performance that complicated the analysis process. This research produce data warehouse which is integrated to online analytical processing (OLAP) that can represents data with graph and crosstab table. The OLAP server used in this research is Jedox 5.1. The data used are the academic and non academic’s data of IPB Computer Science students entry’s year 2006 to 2009. The steps being taken include analysis, design, preprocessing, and concluded with the implementation of data warehouse and OLAP operations. The data warehouse schema is created using the galaxy scheme. The result of research are three cubes (Research, Academic, and Achievement).