Building Datawarehouse for Educational Institutions in 9 Steps

Educational management requires the ability to analyze the current condition of an institution's operations. The Academic Information System provides valuable raw data. However, unprocessed information alone is insufficient for the diagnosis of problem areas within an education institution. Due to the complex nature of educational management, there is a need for an application that can identify critical patterns and trends within an educational institution's current activities. The data warehouse in the study serves the center for data collection and integration. Gathered data can then be accessed for queries and analysis, generating insights crucial for improving an institution. The purpose of this study was to build a data warehouse model that can display useful information for education management support. The data warehouse design methodology was based on the nine-step methodology proposed by Kimball. The method of data collection included questionnaires, interviews, formal observations, and literature review. Visual Basic.Net 2008, SQL Server 2005 and Crystal Reports were used as tools to design the model.