Data Warehouse System for Multidimensional Analysis of Tuition Fee Level in Higher Education Institutions in Indonesia

In this study, we developed a data warehouse (DW) system for tuition-fee-level management for higher education institutions (HEI) in Indonesia. The system was developed to provide sufficient information to the administrators for decision making of tuition fees of applicants by integrating multisource data. A simple but sufficient method was introduced using the open-source following the business requirements of HEI's administrator. As a business intelligence (BI) approach, four procedures are applied e.g., preparation, integration, analysis, and visualization to construct a tuition-fee-level management system. The DW demonstrate four basic dimensions (faculty, year, entrant type, and tuition fee level) in all seven dimensions and three data regarding applicants, tuition fee level, and payment status. Analytical results were tuition fee level trends, top five faculty by applicants, and fees collected from the student trends. Those analysis results were presented in various charts and graphics contained at a dashboard of tuition fee level, which has many functions to provide insight relative to the business performance. The DW system described in this paper can be used as a guideline for tuition-fee-level management for HEIs in Indonesia.