Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani

• Main Author: Mat Yusof, Sharmila
• Format: Conference or Workshop Item
• Language: English
• Published: 2006
• Subjects: LB2300 Higher Education
• Online Access: http://repo.uum.edu.my/9569/1/Pr.pdf; http://repo.uum.edu.my/9569/

A data warehouse is a repository of integrated information used to perform query and analysis on vast amount of operational data. Since data warehouse project requires extensive resources to be completed on time, many organizations chose to incrementally develop data marts instead, gradually merge to be the organization’s data warehouse. However, due to the non-profit advantage, data warehouse has been rarely implemented in higher education institution although majority of the institutions have some kind of information system. As a result, the reporting and analysis of the student record system is often ad hoc and time-consuming tasks. This research was intended to analyze and design a data warehouse that will enable high improvement data analysis for the Academic planning of the college.During the requirement analysis, the fact-finding techniques of observations and interviews have been conducted with the key users of the Online Analytical System (OLTP) to gain deep understanding and verify the facts collected.From the user requirement analysis, the logical model of Entity Relationship (ER) Diagram was developed and has iteratively been used to verify the user requirements. Then, the dimensional model was developed using the Kimball’s ‘Nine-Step Methodology’. Finally, the design was validated using the Microsoft SQL server 7.0.