Utilization Extract, Transform, Load for Developing Data Warehouse in Education Using Pentaho Data Integration

Open

A.D. Barahama, R. Wardani

2021 Journal of Physics: Conference Series Vol. 2111 Issue 1 Conference paper Cited by 1 SDG 9 Quartile

Abstract

The utilization of data warehouses in various fields is an absolute necessity. A data warehouse is a database that contains large amounts of data that aims to help organizations, fields, and institutions specifically for decision making. Data warehouses can produce important information in the future. Loading data from various sources and processed through an ETL (Extract, Transform, Load) process that displays data consistently is the basis for creating a data warehouse architecture. The development of a data warehouse in education will provide significant benefits for the progress of education. Integration of data and processing results stored in the data warehouse can be the basis for evaluating better planning. Development of data warehouse adopt the multidimensional modelling method which consists of four stages: select the business process, declare the grain, select dimensions, and identify facts. This stage produces a data warehouse architecture and influences and contributes to the advanced information technology in education. © 2021 Institute of Physics Publishing. All rights reserved.

Affiliations

Department of Electronics and Informatics Engineering Education, Post-Graduate Program, Universitas Negeri Yogyakarta, Jalan Colombo 01, Daerah Istimewa Yogyakarta, 55281, Indonesia

Research at a Glance

Premium content — register to unlock

Research at a Glance

Register to unlock

Topics & SDG Alignment

Premium content — register to unlock

Topics & SDG Alignment

Register to unlock

Collaboration

Premium content — register to unlock

Collaboration

Register to unlock

Author Profile (Selected)

Premium content — register to unlock

Author Profile (Selected)

Register to unlock

References Overview

Premium content — register to unlock

References Overview

Register to unlock

Journal & Source

Premium content — register to unlock

Journal & Source

Register to unlock

Metadata & Integrity

Premium content — register to unlock

Metadata & Integrity

Register to unlock