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

Abstract. Politeknik Caltex Riau (PCR), as a private higher education institution withten study programs,has already had a Student Academic System. The universitymanagement has been creating policies based on their intuitions, rather than onacademic data. The current academic data available are still partial and spread in manysources. Some of them have used operational data, while some others are still in theform of files, hindering the operational staff to analyze the data to get the informationrequired by the university’s top management. Data warehouse technology is one ofpossible solutions in data analysis.Methodology in building a data warehouse is ninestep kimball. In this study, the data warehouse modeling technique used was FactConstellation. The study planned an academic data warehouse that was implementedusing the software Pentaho and visualized graphically with the software Tableau. Datawarehouse planning in the current study used the steps available for developing a datawarehouse. The result of this research is a data warehouse that presents comprehensiveinformation, relevant and integrated and can be viewed from various viewpoints, whichis expected to facilitate in decision making. Information were presented as a datawarehouse plan and visualized graphically