Uncovering Hidden Information within UUM Students' Data Using OLAP
Nur Hani, Zulkifli Abai
Abstract
Nur Hani, Zulkifli Abai
Abstract
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.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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.
Key concepts: Online analytical processing, Computer science, Data cube, Data warehouse, Process (computing), Business intelligence, Sql server, Quality (philosophy)