Data analysis and Data warehouse Design Based on Pentaho Data Integration (Kettle) to support the determination of student learning achievement
Ameiliani Dianira Barahama (a*), Ratna Wardani (a)

a) Electronics and Informatics Engineering Education, Post-Graduate Program, Yogyakarta State University
Jalan Colombo 01, Daerah Istemewa Yogyakarta 55281, Indonesia
*ameilianidianira[at]gmail.com

Abstract

Data analysis has become a vital requirement in various fields. The results of data analysis can be used as a data warehouse design that is expected to help in solving problems, evaluating learning outcomes and supporting decision making. In the field of education, student achievement is a reference for achieving quality learning. This success can be seen from the achievement of student learning completeness that is the basis for evaluating and making decisions. The data warehouse design can be used as a basis in knowing student learning progress that can be seen from the value obtained. The diversity of data makes managing values difficult and delayed, data warehouse design using Pentaho can help and simplify data integration. The results of the analysis and design of the data warehouse will be presented in a multidimensional form that can be seen through dimension tables and fact tables.

Keywords: Data Analysis, Data warehouse, Pentaho Data Integration, multidimensional, dimension table, fact table.

Topic: Information Engineering