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

Nurul Hidayat; Dadang  Iskandar; Lasmedi Afuan; Arief Kelik Nugroho; Nandha Arwiansyah

doi:10.20884/1.jutif.2022.3.3.514

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

DOI: https://doi.org/10.20884/1.jutif.2022.3.3.514

Keywords: Data Warehouse, Data Warehouse Life Cycle, SNDIKTI, Star Schema

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.

Downloads

Download data is not yet available.

References

M. A. Maulana and W. S. Alifferiza, Maskur S.Kom, M.Kom., “Analisis Dan Perancangan Data Warehouse Evaluasi Mahasiswa Studi Kasus Pada Jurusan Teknik Informatika UMM,” 2020.

M. P. dan Kebudayaan, Peraturan Menteri Pendidikan Dan Kebudayaan Nomor 03 Tahun 2020 Tentang Standar Nasional Perguruan Tinggi. 2020.

F. N. Hasan and A. Febriandirza, “Perancangan Data Warehouse Untuk Data Penelitian Di Perguruan Tinggi Menggunakan Pendekatan Nine Steps Methodologhy,” Pseudocode, vol. 8, no. 1, pp. 49–57, 2021, doi: 10.33369/pseudocode.8.1.49-57.

A. Filiana, A. G. Prabawati, M. N. A. Rini, G. Virginia, and B. Susanto, “Perancangan Data WarehousePerguruan Tinggi untuk Kinerja Penelitian dan Pengabdian kepada Masyarakat,” Tek. Inform. dan Sist. Inf., vol. 6, 2020.

L. Esheiba, I. M. A. Helal, A. Elgammal, and M. E. El-Sharkawi, “A Data Warehouse-Based System for Service Customization Recommendations in Product-Service Systems,” Sensors, vol. 22, no. 6, 2022, doi: 10.3390/s22062118.

M. S. Dr. R. A. Fadhallah, S.Psi., Wawancara, 1st ed. Jakarta Timur: UNJ Press, 2021.

A. Ahmad and Y. I. Kurniawan, “Sistem Pendukung Keputusan Pemilihan Pegawai Terbaik Menggunakan Simple Additive Weighting,” J. Tek. Inform., vol. 1, no. 2, pp. 101–108, 2020, doi: 10.20884/1.jutif.2020.1.2.14.

N. S. Fitriasari, I. Ariawan, A. Rais, and ..., “Rancangan Dan Implementasi Modul Data Warehouse Dan Data Mining Sebagai Kritikal Sukses Faktor Pada Enterprise,” Proceeding …, vol. 1, no. 1, pp. 41–52, 2021, [Online].Available:https://proceeding.unived.ac.id/index.php/snasikom/article/view/51%0Ahttps://proceeding.unived.ac.id/index.php/snasikom/article/download/51/45.

S. O. Salinas and A. C. Nieto Lemus, “Data Warehouse and Big Data Integration,” Int. J. Comput. Sci. Inf. Technol., vol. 9, no. 2, pp. 01–17, 2017, doi: 10.5121/ijcsit.2017.9201.

I. P. A. E. Pratama, Handbook Data Warehouse Teori dan Praktik Berbasiskan Open Source, 1st ed. Bandung: Informatika Bandung, 2018.

Y. Guo, “Data Source Analysis of Computerized Management Accounting Based on Data Warehouse and Mobile Edge Computing,” Wirel. Commun. Mob. Comput., vol. 2022, 2022, doi: 10.1155/2022/3216180.

Y. I. Kurniawan, U. H. Yulianti, N. G. Yulianita, and A. P. Pratama, “English Learning Educational Games For Hearing And Speech Game Edukasi Pembelajaran Bahasa Inggris Untuk Siswa Tuna Rungu Wicara Di Slb-B Yakut Purwokerto,” vol. x, pp. 781–790, 2022.

Y. Liu and Z. Wang, “An Early Warning Risk and Control Model for Manpower Capital Investment Using Data Warehousing and Computational Intelligence,” Comput. Intell. Neurosci., vol. 2022, 2022, doi: 10.1155/2022/7624135.

fakultas teknik unsoed, Buku Pedoman Fakultas Teknik Unsoed Universitas Jenderal Soedirman. Purbalingga, 2018.

A. Dwitama Hidayat and G. Yoki Sanjaya, “Integrasi Data Pada Dashboard Sistem Kesehatan (DaSK) untuk Mendukung Analisa & Visualisasi Sistem Rujukan,” Journal.Ugm.Ac.Id, vol. 7, no. 1, pp. 25–31, 2022, [Online]. Available: https://journal.ugm.ac.id/jisph/article/view/71333.

J. M. Dahr, A. K. Hamoud, I. A. Najm, and M. I. Ahmed, “Implementing Sales Decision Support System Using Data Mart Based on Olap, Kpi, and Data Mining Approaches,” J. Eng. Sci. Technol., vol. 17, no. 1, pp. 275–293, 2022.

Salman, M. Subli, and M. M. Efendi, “Penerapan Sistem Business Intelligence ( Bi ) Sebagai Pendukung Pengambilan Keputusan Rekrutmen Dan Seleksi Calon Mahasiswa Baru Di Masa Pandemi Covid-19,” vol. 5, pp. 116–126, 2022.