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

Authors

  • Khoirudin Eko Nurcahyo Universitas Nusantara PGRI Kediri
  • Sucipto Sucipto Universitas Nusantara PGRI Kediri
  • Arie Nugroho Universitas Nusantara PGRI Kediri

DOI:

https://doi.org/10.25273/research.v3i2.6883

Keywords:

Data Warehouse, ETL, Mapping, Student

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.

Downloads

Download data is not yet available.

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.

Downloads

Published

2020-10-31

How to Cite

Nurcahyo, K. E., Sucipto, S., & Nugroho, A. (2020). Mapping Student Data Using Data Warehouse for Promotion at Vocational High School of Z. RESEARCH : Journal of Computer, Information System & Technology Management, 3(2), 55–66. https://doi.org/10.25273/research.v3i2.6883

Issue

Vol. 3 No. 2 (2020)

Section

Articles

License

Authors who publish with this journal agree to the following terms:

Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.

Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
Crossref
Scopus
Google Scholar
Europe PMC