UUM Repository | Universiti Utara Malaysian Institutional Repository
FAQs | Feedback | Search Tips | Sitemap

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


Mat Yusof, Sharmila (2006) Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani. In: Master Projects Seminar, 2006, Fakulti Teknologi Maklumat, Universiti Utara Malaysia. (Unpublished)

[img] PDF
Restricted to Registered users only

Download (92kB)

Abstract

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.

Item Type: Conference or Workshop Item (Paper)
Uncontrolled Keywords: data warehouse, data mart, academic planning, college
Subjects: L Education > LB Theory and practice of education > LB2300 Higher Education
Divisions: College of Arts and Sciences
Depositing User: Mdm. Sharmila Mat Yusof
Date Deposited: 27 Feb 2014 07:30
Last Modified: 27 Feb 2014 07:30
URI: http://repo.uum.edu.my/id/eprint/9569

Actions (login required)

View Item View Item