Design and Research of Data Analysis System for Student Education Improvement (Case Study: Student Progression System in University)

Abstract

Various business organizations use Data Warehouse (DW) for enhancing their decision making capabilities of their organizations for progress. In this paper, we present a design and development of a Data Warehouse framework for better and more thorough analysis of the university's data for data mining purposes and business intelligence reporting purposes. The proposed system constitutes an intelligent system which collects data from different departments of different colleges, store data into the large data warehouse of the university and perform thorough analysis of student's past data such as survey-based data of the university. Analysis of data could be achieved with OLAP operations. In our proposed research, the main area is Dimensional Modeling and design of the Student Progression System. Student Progression System covers broad categories like Registration, Student's Personal Information, Academic History, Course information, Degree Information, Semester wise result Improvement, Faculty Information, Departmental data, College Data etc. We developed a multidimensional Data Model from the different types of data sources by using ETL processes for the creation of multiple data marts i.e Student's semester wise progression as well as a faculty semester wise report.