Design of a 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...
| Main Author: | |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
2006
|
| Subjects: | |
| Online Access: | https://repo.uum.edu.my/id/eprint/9583/1/Pr.pdf |
| _version_ | 1803625868417826816 |
|---|---|
| author | Mat Yusof, Sharmila |
| author_facet | Mat Yusof, Sharmila |
| author_sort | Mat Yusof, Sharmila |
| collection | UUM |
| 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. |
| first_indexed | 2024-07-04T05:41:07Z |
| format | Conference or Workshop Item |
| id | uum-9583 |
| institution | Universiti Utara Malaysia |
| language | English |
| last_indexed | 2024-07-04T05:41:07Z |
| publishDate | 2006 |
| record_format | dspace |
| spelling | uum-95832014-03-09T08:50:09Z https://repo.uum.edu.my/id/eprint/9583/ Design of a data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani Mat Yusof, Sharmila QA76 Computer software 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 https://repo.uum.edu.my/id/eprint/9583/1/Pr.pdf 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) |
| spellingShingle | QA76 Computer software Mat Yusof, Sharmila Design of a data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
| title | Design of a data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
| title_full | Design of a data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
| title_fullStr | Design of a data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
| title_full_unstemmed | Design of a data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
| title_short | Design of a data warehouse for academic planning at private college: A case study at Cosmopoint College Metro Campus Sungai Petani |
| title_sort | design of a data warehouse for academic planning at private college a case study at cosmopoint college metro campus sungai petani |
| topic | QA76 Computer software |
| url | https://repo.uum.edu.my/id/eprint/9583/1/Pr.pdf |
| work_keys_str_mv | AT matyusofsharmila designofadatawarehouseforacademicplanningatprivatecollegeacasestudyatcosmopointcollegemetrocampussungaipetani |