RANCANG BANGUN DATA WAREHOUSE PADA KANTOR DINAS PENDIDIKAN DAN PENGAJARAN KABUPATEN MERAUKE

Data and information are the important assets in many activities, including educational ones. Office of Education in Merauke, recently there are some systems to support the need of data and information on educational environment, however, one system to another are not in a single entity, therefore they are not able to provide data and information quickly and integrated. A technology need to integrated data and information, and this technology called the data warehouse. Data Warehouse is a relational databases to query and analyze, not for transaction process. It can save and process a lot of data from many sources, then integrate them to be analized. The purpose of this research is to find how to integrate the whole student�s data which are spread in differents schools into the data warehouse. Logical model data of data warehouse in this research use the star schema, which can show the relation in each table as dimension and measure that, will figure out the informational needed and to answer the question from the user. The analysis of the data warehouse using OLAP (On-Line Analytical Processing), to analyze the student score and data at Office of Education in Merauke. The result show that the multidimensional data is designed to analyze the average score of national examination of student�s perspective, school�s type, school�s level, school`s status, and the number of students based on school�s name, school`s status, school`s type, school�s level, student`s gender, and ethnic. The multidimensional data analysis (OLAP) consist of Contourcube component , that can operate a rotation/pivoting, filtering, sorting, slicing/dicing, and drill-down/drillup, and allows the user to analyze from different point of view with an output graphic display created by user