Academic Data Warehouse Planning: A Case Study in Politeknik Caltex Riau

Abstract

Abstract. Politeknik Caltex Riau (PCR), as a private higher education institution with
ten study programs,has already had a Student Academic System. The university
management has been creating policies based on their intuitions, rather than on
academic data. The current academic data available are still partial and spread in many
sources. Some of them have used operational data, while some others are still in the
form of files, hindering the operational staff to analyze the data to get the information
required by the university’s top management. Data warehouse technology is one of
possible solutions in data analysis.Methodology in building a data warehouse is nine
step kimball. In this study, the data warehouse modeling technique used was Fact
Constellation. The study planned an academic data warehouse that was implemented
using the software Pentaho and visualized graphically with the software Tableau. Data
warehouse planning in the current study used the steps available for developing a data
warehouse. The result of this research is a data warehouse that presents comprehensive
information, relevant and integrated and can be viewed from various viewpoints, which
is expected to facilitate in decision making. Information were presented as a data
warehouse plan and visualized graphically.