PERANCANGAN DATA WAREHOUSE UNTUK ANALISIS DATA MAHASISWA MENGGUNAKAN PEMODELAN STAR SCHEMA DI UNIVERSITAS KLABAT

The background of this research is made to the executive of the university will analyze the data of registered student at the Klabat University. The important issue in organization is requires Strategic Information that aims to nourish and make the organization continues to survive in the competition to be superior university. A Goal to be achieved in this study is the realization of the design and data warehouse applications that are designed with a star schema modeling. Star schema is created based on the data warehouse functions. There are six tables of dimensions and one fact table. The university executive can analyze data quickly because this data analysis can be done with OLAP. OLAP operations are made in such to fulfill the functions of the data warehouse. The study produced data that registered students can be easily understood because the analysis carried out supported by the form of charts are available with several types of graphs that can be selecte