Building Multi-Dimensional Cube to Analyze Public Examination Results: A Business Intelligence Approach

In recent years educational data mining and data warehouse has become one of the challenging research fields. It is used to turn the raw data available in educational field into actionable information. Educational data can provide improved understanding of students’ knowledge and better assessments of their progress. Educational data mining and warehousing could help educational government organizations in taking timely and data analysis based management decisions, thus contributing to gain competitive advantages in their successful policy framing. This paper focuses on the research activities for building data warehouse/data mart to store and analyze the public examination results of higher grade students by Directorate of Government Examinations belonging to Tamil Nadu, India. The data warehousing concept comprises of architectures, tools, and algorithms for bringing together data from various sources into a single repository and making it useful for the management to directly query and extract useful information for analysis. In this paper the need of data warehouse / business intelligence for a government educational organization has been explored.