Uncovering Hidden Information within UUM Students' Data Using OLAP

The implementation of online analytical processing (OLAP) in speeding decision making process has increased especially in educational industry. Lots of OLAP and Business Intelligence(BI) products have been commercialized, but its implementation in educational industry should be widen up. This study...

Full description

Saved in:
Bibliographic Details
Main Author: Nur Hani, Zulkifli Abai
Format: Thesis
Language:eng
eng
Published: 2010
Subjects:
Online Access:https://etd.uum.edu.my/2202/1/Nur_Hani_Zulkifli_Abai.pdf
https://etd.uum.edu.my/2202/2/1.Nur_Hani_Zulkifli_Abai.pdf
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:The implementation of online analytical processing (OLAP) in speeding decision making process has increased especially in educational industry. Lots of OLAP and Business Intelligence(BI) products have been commercialized, but its implementation in educational industry should be widen up. This study shows the implementation of OLAP in Universiti Utara Malaysia to discover hidden information within UUM students' data. It discussed techniques of data selection and integration to enable university management analyzed integrated students' data online. Issues that have been discussed include data cleaning techniques to ensure data quality before analysis being done and OLAP cube generation technique using SQL Server Analysis Services. This study also elaborates analysis results using OLAP cube that retrieves data online, direct to the server.