Academic Data Warehouse Planning: A Case Study in Politeknik Caltex Riau
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.
All material contained in this site is protected by law. It is prohibited to quote part or all of the contents of this website for commercial uses without the approval of the board of editors of this journal.
If you find one or more articles contained in CELSciTech that violate or potentially infringe your copyright, please report to us, via email to Principle Contact.
The formal legal aspect of access to any information and articles contained in this journal site refers to the terms of the Creative Commons Attribution-ShareAlike (CC BY-SA).
All information contained in CELSciTech is academic. CELSciTech is not responsible for any losses incurred by misuse of information from this site.