Mapping Student Data Using Data Warehouse for Promotion at Vocational High School of Z

Khoirudin Eko Nurcahyo, Sucipto Sucipto, Arie Nugroho

Abstract


The purpose of this study is provide data warehouse modeling which make executive of school can analyze data easily, the problem is executive of school are analysis list registrant list difficulty, what the most and least registrant junior high school come from and the major which most and least registrant. This study do is because how important data management on education organization and how the data can be managed better. The study use descriptive quantitative method research and use 4 step data warehouse dimensional modeling by Kimball. On building data warehouse used ETL, data be extracted and transformed into data warehouse as dimension and fact. For next data be imported and be showed by web base business intelligence app. The result of this study is an web base business intelligence app which can show sum of registrant on gender, majors, junior high school graduate come from, recommendation and register year. Data warehouse is good at data analyzing for decision making, because data warehouse can show information quickly and accurate.

Keywords


Data Warehouse; ETL; Mapping; Student

Full Text:

PDF

References


Sucipto, “Perancangan Active Database System pada Sistem Informasi Pelayanan Harga Pasar,” vol. 1, no. 1, pp. 35–43, 2017.

Sucipto, R. Indriati, and F. B. Hariawaan, “DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN,” JIPI (Jurnal Ilm. Penelit. dan Pembelajaran Inform., vol. 2, no. 2, pp. 88–93, 2017.

N. Purwati and H. Wibowo, “Pemanfaatan Data Warehouse untuk Menentukan Penghargaan Dean List Akademi pada Alumni,” Explore, vol. 8, pp. 7–14, 2017.

M. Husaini, “PEMANFAATAN TEKNOLOGI INFORMASI DALAM BIDANG PENDIDIKAN (E-education),” Mikrotik, vol. 2, no. 1, 2014.

R. Susanto and T. H. M, “Pemodelan Data Warehouse Distribusi Produk di PT X,” Intensif, vol. 3, no. 2, pp. 196–205, 2019.

F. Y. Al Irsyadi, “IMPLEMENTASI DATA WAREHOUSE DAN DATA MINING UNTUK PENENTUAN RENCANA STRATEGIS PENJUALAN BATIK ( Studi Kasus Batik Mahkota Laweyan ),” vol. VI, no. 1, pp. 42–58, 2014.

A. Nugroho, “APLIKASI OLAP PROFIL MAHASISWA DAN LULUSAN,” vol. 9, no. 1, pp. 533–540, 2018.

M. A. A. Maulana, “Analisis Dan Perancangan Data Warehouse Evaluasi Mahasiswa Studi Kasus Pada Jurusan Teknik Informatika UMM,” Repositor, vol. 1, no. 1, pp. 59–68, 2020.

R. T. Yunandar, Amir, and K. Rizal, “Perancangan Data Warehouse Untuk Informasi Strategi Studi Kasus Penerimaan Siswa Baru STIE Binaniaga Bogor,” Tek. Komput. AMIK BSI, vol. VI, no. 1, 2020.

G. M and S. Rizzi, From Star Schemas to Big Data: 20+ Years of Data Warehouse Research. 2018.

M. JRP, Pentaho : Solusi Open Sorce untuk Membangun Data Warehouse, 1st ed. Yogyakarta: Andi, 2014.

and S. P. S. Habte, K. Ouazzane, P. Patel, “Generic Data Warehousing for Consumer Electronics Retail Industry,” vol. 11, pp. 828–831, 2017.

Robicomp, “Pengertian OLAP Online Analytical Processing dan Fungsinya,” Http://www.robicomp.com/pengertian-olap-online-analytical-processing-dan-fungsinya.html, 2020. .

C. Venter and R. Goede, “Critical systems approach to business intelligence systems development,” 2016.

D. S. Wahyu, Pengembangan Data Warehouse dan Aplikasi OLAP Data Tracer Study Alumni IPB Berbasis Web Menggunakan Microsoft Business Intellegence. 2012.

Sugiyono, Metode Penelitian Kuantitatif, Kualitatif dan R & D. Bandung: CV. Alfabeta, 2017.

W. Gito, “Implementasi Data Warehouse dan Business Intellegence untuk Pemantauan Penerimaan Pajak Daerah : Studi Kasus pada Dinas Pelayanan Pajak DKI Jakarta (2015),” 2015.

K. Group, “Four-Step Dimensional Design Process,” https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/four-4-step-design-process/, 2020. .

A. S. Girsang, “Nine Steps design methodology for developing Data warehouse,” 2017.

R. Kimball and Ross, The data warehouse toolkit: The definitive guide to dimensional modeling. John Wiley & Sons, 2013.

A. Supriyatna and M. Wahyudi, “Perancangan Data Warehouse pada Perpustakaan Bina Sarana Informatika ‘Seminar Nasional Aplikasi Teknologi Informasi (SNATI),’” 2012.

I. Sadam and A. U. Hamdani, “Perancangan Model Data Warehouse Untuk Mengetahui Kinerja Layanan Jasa Pengiriman Barang Studi Kasus : Xyz,” pp. 190–197, 2019.

Y. Oslan, “PROSES ETL ( EXTRACT TRANSFORMATION LOADING ) DATA WAREHOUSE UNTUK PENINGKATAN KINERJA BIODATA DALAM MENYAJIKAN PROFIL MAHASIWA DARI DIMENSI ASAL SEKOLAH Studi Kasus : Biodata Mahasiswa UKDW,” vol. 3, no. 1, 2019.


Article Metrics

Abstract has been read : 190 times
PDF file viewed/downloaded: 0 times


DOI: http://doi.org/10.25273/research.v3i2.6883

Refbacks

  • There are currently no refbacks.




This work by Research is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.