Star Schema-Based Data Warehouse Model for Education System Using Mondrian and Pentaho

Multiple strategic challenges are being faced by educational institutions across the globe which is of interest to both researchers and decision-makers. These challenges can be successfully addressed by analyzing the vast amount of data stored in multiple, unorganized, and unstructured operational databases in the educational institutes. Practitioners, researchers, and students would need data warehousing techniques to be able to utilize the knowledge stored in different archives. Data warehousing techniques include assimilating disparate sources of data, analysis of the requirements, designing the data, development, implementation, and deployment of the data. In this paper, a data warehouse (DW) for solving operational challenges of the center of higher education has been developed, which encompasses system design, ETL data processing, and online analytical processing analysis. The designing of this model is done using Mondrian and Pentaho business intelligence tool.