DATA WAREHOUSE KEPEMILIKAN MCK MENGGUNAKAN METODE ETL DAN BLACK-BOX (STUDI KASUS: KELURAHAN NITU, NTB)
Article Sidebar
Main Article Content
Abstract
Article Summary
Preparation of government policies related to public services and facilities requires population data and its supporting technology. The Government of Bima, West Nusa Tenggara (NTB) has population data related to the ownership of each family in Nitu Village but is constrained by the technology to process these data. This research designs and implements a Data warehouse using the Extraction, Transformation, and Loading (ETL) method with the concept of multi-dimensional data. The system is implemented using Pentaho, then tested using the Black-Box method. The Data warehouse collects data from residents of the Nitu Kelurahan related to MCK ownership, then processed it to produce reports and data visualization. The stages of the research include data collection, identification of data dimensions, design, implementation, and Testing of the Data warehouse, as well as conclusions. The final results of the research show that the Data warehouse that was built helps the government in determining policy strategies and making decisions regarding the provision of MCK facilities for the people of Nitu Village, through reports and data visualization
Keywords
Article Keywords
Black Box ; Data Warehouse ; ETL ; MCK ; Pentaho
Downloads
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International 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 (CC-BY 4.0) 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.
License: All articles are licensed under 
Pratama, I.P.A.E., 2018. Handbook Data warehouse (Vol 1). Penerbit Informatika.
Edhya, B.F.P. and Susilowati, M., 2022. Business Intelligence Data Marketing Menggunakan Metode Kimball dan Etl Dengan Power BI. KURAWAL Jurnal Teknologi, Informasi dan Industri, 5(2), pp.87-97.
Hidayat, N., et al., 2022. Analysis and Design of Data warehouse Based on SNDIKTI Using Data warehouse Life Cycle Method at UNSOED Engineering Faculty. JUTIF Jurnal Teknik Informatika, 3(3), pp.797-805. DOI: https://doi.org/10.20884/1.jutif.2022.3.3.514.
Filiana, A., et al., 2020. Perancangan Data warehouse Perguruan Tinggi untuk Kinerja Penelitian dan Pengabdian kepada Masyarakat. Jurnal Teknik Informatika Dan Sistem Informasi, 6(2), DOI: https://doi.org/10.28932/jutisi.v6i2.2557.
Purwanto, J. and Renny, R., 2021. Perancangan Data warehouse Rumah Sakit Berbasis Online Analytical Processing (OLAP). Jurnal Teknologi Informasi dan Ilmu Komputer, 8(5), pp.1077-1088. DOI: http://dx.doi.org/10.25126/jtiik.2021854232.
Suryana, N., 2019. Analisis Database dan Perancangan Data warehouse Bidang Cipta Karya (Studi Kasus di Ditjen Cipta Karya KemenPU-PR). Jurnal TEDC, 12(2), pp.185-192.
Setiyani, L. and Tjandra, E., 2020. Perancangan dan Implementasi Data warehouse Untuk Perpustakaan Kampus (Studi Kasus: STMIK Rosma Karawang). Indonesian Journal On Information System (IJIS), 5(2). DOI: https://doi.org/10.36549/ijis.v5i2.102.
Pratama, I.P.A.E. and Widhiasih, N.P.N.D., 2020. Perancangan Data warehouse Untuk Prediksi Penjualan Produk Pada Orba Express Menggunakan Pentaho. Jurnal Sains dan Sistem Informasi (JUSS), 3(2). DOI: https://doi.org/10.22437/juss.v3i2.8147.
Subuh, D. and Yasman W.. 2019. Implementasi Data warehouse dan Penerapannya Pada Toko Magnifique Clothes Dengan Menggunakan Tools Pentaho. SENIATI, 2(2). DOI: https://doi.org/10.36040/seniati.v5i2.688.
Yoga, G.A.D., Purnama, I.N., Wijaya, I.N.Y.A. and Ardyanti A.A.A.P., 2020. Perancangan Data warehouse Kunjungan di Kebun Raya Eka Karya Bedugul. Jurnal Manajemen Informatika dan Sistem Informasi (MISI), 3(1). DOI: https://doi.org/10.36595/misi.v3i1.160.
Arimbawa, I.W.A., Wantari, N.K.D.F. and Husodo, A.Y., 2018. Rancang Bangun Sistem Monitoring Akademik Program Studi Teknik Informatika Universitas Mataram Menggunakan Data warehouse. JCOSINE, 2(1). DOI: https://doi.org/10.29303/jcosine.v2i1.105.
Suni, E.K., 2018. Analisis dan Perancangan Data warehouse Untuk Mendukung Keputusan Redaksi Televisi Menggunakan Metode Nine Step Kimball. Jurnal Teknik Informatika, 11(2). DOI: https://doi.org/10.15408/jti.v11i2.8560.
Bakhri, S. and Nuryamin, Y., 2018. Rancangan Data warehouse Untuk Penunjang Sistem Informasi Eksekutif Pada Yayasan Ummu’l Quro di Depok. Jurnal Teknik Komputer, 4(1). DOI: https://doi.org/10.31294/jtk.v4i1.2498.
Mulyana, A., Abadi, B.H. and A.A. Rachman, S.R. Widianto, 2020. Rancang Bangun Data warehouse Berbasis Star Scheme Studi Kasus: SMK Negeri 4 Garut. Jurnal Teknologi Komputer & Sains (SAINTEKS), 4(3), pp.48-54.
Marbun, I.R. and Somya, R., 2021. Perancangan Data warehouse untuk Data Transaksi Penjualan Menggunakan Schema Snowflake Studi Kasus: Online Market Dataset. Dinamika Informatika, 3(1), pp.66-78.
Derwanto, D. and Purnamasari, S.D., 2021. Perancangan Data Mart Kepegawaian Bina Darma," Bina Darma Conference on Computer Science (BDCCS), 3(3).
Prasetyo, D. and Supriyanto, A., 2021. Analisa dan Perancangan Data warehouse Dengan Metode Nine Step Kimball di PT Surganya Motor Indonesia. SENDIU, 10(3), pp.379-385.
Sari, R. and Pratama, I.P.A.E., 2020., Rancangan Desain Data warehouse Kunjungan Wisatawan Ke Bali Baw Tour and Travel. Jurnal Sains dan Sistem Informasi (JUSS), 3(1), pp.88-93. DOI: https://doi.org/10.22437/juss.v3i1.8146.
Fahkrurrazi, F., 2020. Sistem Informasi Pendataan Karyawan Gudang pada PT. Tempo Banda Aceh Dengan Menggunakan Bahasa Pemrograman Web-Based. JIMIK Jurnal Indonesia Manajemen Informatika dan Komunikasi, 1(2), pp.73-81. DOI: https://doi.org/10.35870/jimik.v1i2.23.
Hasanah, U., 2020. Sistem Informasi Pendistribusian Barang Pada PT. Sampurna Sukses Utama Aceh Besar. JIMIK Jurnal Indonesia Manajemen Informatika dan Komunikasi, 1(1), pp.20-27. DOI: https://doi.org/10.35870/jimik.v1i1.8.
Berliantara, A.Y. Wicaksono, S.A. and Pinandito, A., 2017. Optimasi Scheduling untuk Proses Extract, Transform, Load (ETL) pada Data warehouse Menggunakan Metode Round Robin Data Partitioning (Studi Kasus: Universitas XYZ). Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer (JPTIIK), 1(11), pp.1358-1366.
Wijaya, Y.D. and Astuti, M.W., 2021. Pengujian Black-Box Sistem Informasi Penilaian Kinerja Karyawan PT INKA (Persero) Berbasis Equivalence Partitions. Jurnal Digital Teknologi Informasi, 4(1), pp.22-26. DOI: https://doi.org/10.32502/digital.v4i1.3163.