mailto:uumlib@uum.edu.my 24x7 Service; AnyTime; AnyWhere

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

Mat Yusof, Sharmila (2006) Design of a 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)

[thumbnail of Pr.pdf] 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: Q Science > QA Mathematics > QA76 Computer software
Divisions: College of Arts and Sciences
Depositing User: Mrs. Norazmilah Yaakub
Date Deposited: 09 Mar 2014 08:50
Last Modified: 09 Mar 2014 08:50
URI: https://repo.uum.edu.my/id/eprint/9583

Actions (login required)

View Item View Item