Jurnal Teknik Informatika (JUTIF)
Vol. 3 No. 3 (2022): JUTIF Volume 3, Number 3, June 2022

ANALYSIS AND DESIGN OF DATA WAREHOUSE BASED ON SNDIKTI USING DATA WAREHOUSE LIFE CYCLE METHOD AT UNSOED ENGINEERING FACULTY

Nurul Hidayat (Program Studi Informatika, Fakultas Teknik, Universitas Jenderal Soedirman, Indonesia)
Dadang Iskandar (Program Studi Informatika, Fakultas Teknik, Universitas Jenderal Soedirman, Indonesia)
Lasmedi Afuan (Program Studi Informatika, Fakultas Teknik, Universitas Jenderal Soedirman, Indonesia)
Arief Kelik Nugroho (Program Studi Informatika, Fakultas Teknik, Universitas Jenderal Soedirman, Indonesia)
Nandha Arwiansyah (Program Studi Informatika, Fakultas Teknik, Universitas Jenderal Soedirman, Indonesia)



Article Info

Publish Date
12 Aug 2022

Abstract

The National Standard for Higher Education (Standar Nasional Pendidikan Tinggi or SNDIKTI) is a standard unit that includes the National Education Standards, plus the Research Standards, and Community Service Standards. Based on the policy in the Regulation of the Minister of Education and Culture (Peraturan Menteri Pendidikan dan Kebudayaan or Permendikbud) No. 3 of 2020 regarding SNDIKTI, Jenderal Soedirman University (Unsoed) Architecture needs to prepare data/ information for analysis based on SNDIKTI 2020. The data is obtained from several internal systems and manual recapitulation within a predetermined period of time. Currently the architecture already has many information systems, but it is still difficult to manage the existing data. So it is important for the architecture to have an important repository to minimize human errors and data inconsistencies. So to perform complex data management, a data warehouse is needed. In this study, the data warehouse design uses the Data Warehouse Life Cycle (DWLC) method with the data warehouse model used is the star schema model. The results of the data warehousing process are in the form of a dashboard, Online Analytical Processing (OLAP), and reports intended for the executives of the Unsoed Faculty of Engineering. The output is presented using a BI (Business Intelligence) tool called Knowage.

Copyrights © 2022






Journal Info

Abbrev

jurnal

Publisher

Subject

Computer Science & IT

Description

Jurnal Teknik Informatika (JUTIF) is an Indonesian national journal, publishes high-quality research papers in the broad field of Informatics, Information Systems and Computer Science, which encompasses software engineering, information system development, computer systems, computer network, ...