Enhancing Student Data Warehouse by Implementing Dataset Level Transformation in ETL Process

Abstract

Today, every organization is needed not only to record but also to manage and analyze a huge amount of data. Data warehouse and OLAP techniques are valuable tools for today’s competitive, fast evolving world. There have been done many researches to improve the effectiveness of data warehouse. While some works are focused on back-end tools by enhancing the ETL processes, others emphasis on front-end tools by enhancing the OLAP processes. This paper tries to understand on Data warehouse and OLAP technology by implementing the Student Data warehouse for all Universities of Computer Studies, Myanmar. This paper focuses on the data preprocessing step by conducting the dataset level transformation in ETL portion. Finally, this paper describes the analysis reports by using OLAP processes.