Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani
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...
Saved in:
Main Author: | |
---|---|
Format: | Conference or Workshop Item |
Language: | English |
Published: |
2006
|
Subjects: | |
Online Access: | http://repo.uum.edu.my/9569/1/Pr.pdf http://repo.uum.edu.my/9569/ |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.uum.repo.9569 |
---|---|
record_format |
eprints |
spelling |
my.uum.repo.95692014-02-27T07:30:01Z http://repo.uum.edu.my/9569/ Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani Mat Yusof, Sharmila LB2300 Higher Education 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. 2006 Conference or Workshop Item NonPeerReviewed application/pdf en http://repo.uum.edu.my/9569/1/Pr.pdf 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) |
institution |
Universiti Utara Malaysia |
building |
UUM Library |
collection |
Institutional Repository |
continent |
Asia |
country |
Malaysia |
content_provider |
Universiti Utara Malaysia |
content_source |
UUM Institutionali Repository |
url_provider |
http://repo.uum.edu.my/ |
language |
English |
topic |
LB2300 Higher Education |
spellingShingle |
LB2300 Higher Education Mat Yusof, Sharmila Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
description |
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. |
format |
Conference or Workshop Item |
author |
Mat Yusof, Sharmila |
author_facet |
Mat Yusof, Sharmila |
author_sort |
Mat Yusof, Sharmila |
title |
Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
title_short |
Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
title_full |
Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
title_fullStr |
Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
title_full_unstemmed |
Design of data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
title_sort |
design of data warehouse for academic planning at private college: a case study at cosmopoint college metro campus sungai petani |
publishDate |
2006 |
url |
http://repo.uum.edu.my/9569/1/Pr.pdf http://repo.uum.edu.my/9569/ |
_version_ |
1644280142108819456 |
score |
13.19449 |