Design and Implementation of a Data Warehouse for Multi-Source Data Integration in the Open University Environment

Abstract

The The utilization of information technology at Universitas Terbuka to support distance learning generates a large and continuously growing volume of data. This data is spread across various units, each producing data in different formats and structures. The diversity of data sources and formats resulting from operational activities creates challenges in the data integration process, making it difficult to produce centralized data. To address this issue, a data warehouse is implemented to integrate data from various sources through the ETL process. This process includes data extraction from various sources, transformation to fit the predetermined schema, and loading data into a centralized storage system. With the implementation of the Data Warehouse, Universitas Terbuka can overcome data fragmentation issues and provide a platform that enables centralized data-driven analysis. Additionally, the Data Warehouse enhances data accessibility and integrity, making it easier for users to access the necessary information for decision-making and ensuring that the data used maintains its integrity. This implementation is expected to significantly contribute to improving operational efficiency, data accuracy, and the development of data-driven planning and policies to support distance learning at Universitas Terbuka.