jimik@stmiki.ac.id 081377790601 Online Submission Open
Vol. 4 No. 1 (2023) • Articles
Open Access

DATA WAREHOUSE KEPEMILIKAN MCK MENGGUNAKAN METODE ETL DAN BLACK-BOX (STUDI KASUS: KELURAHAN NITU, NTB)

I Putu Agus Eka Pratama
Universitas Udayana
Muhammad Syakurrahman
Universitas Udayana
Published: January 10, 2023 Pages: 24-39
Original Full-Text Article
Download published version for reading and archiving
Download PDF
Abstract

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:
Black Box Data Warehouse ETL MCK Pentaho
Article Metrics & Downloads Graph
Monthly Download Trends:
Author Biographies
I Putu Agus Eka Pratama Universitas Udayana

Program Studi Teknologi Informasi, Fakultas Teknik, Universitas Udayana, Kabupaten Badung, Provinsi Bali, Indonesia

Muhammad Syakurrahman Universitas Udayana

Program Studi Teknologi Informasi, Fakultas Teknik, Universitas Udayana, Kabupaten Badung, Provinsi Bali, Indonesia

How to Cite
Pratama, I. P. A. E., & Syakurrahman, M. . (2023). DATA WAREHOUSE KEPEMILIKAN MCK MENGGUNAKAN METODE ETL DAN BLACK-BOX (STUDI KASUS: KELURAHAN NITU, NTB). Jurnal Indonesia : Manajemen Informatika Dan Komunikasi, 4(1), 24-39. https://doi.org/10.35870/jimik.v4i1.107
License

Creative Commons Attribution 4.0 International License (CC BY 4.0)

This is an open-access article distributed under the terms of the Creative Commons Attribution 4.0 International License .

  • Share: You are free to copy, distribute, and transmit the work in any medium or format.
  • Adapt: You are free to remix, transform, and build upon the work for any purpose, even commercially.
  • Attribution: You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
Copyright & Retention: Authors retain copyright without restrictions and grant this journal the right of first publication under an open-access model. The journal retains non-exclusive publishing rights for archiving, indexing, and scholarly dissemination.

References
Total: 23 References
  1. Sugara, R. and Sugihen, B.T., 2018. Perilaku Masyarakat Dalam Memanfaatkan Aliran Sungai Sebagai Sarana Mandi Cuci dan Kakus (MCK) (Studi Kasus di Desa Pasir Kecamatan Tripe Jaya Kabupaten Gayo). Jurnal Ilmiah Mahasiswa (JIM), 2(3), pp.1-8.
  2. Pratama, I.P.A.E., 2018. Handbook Data warehouse (Vol 1). Penerbit Informatika.
  3. 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.
  4. 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.
  5. 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.
  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. Derwanto, D. and Purnamasari, S.D., 2021. Perancangan Data Mart Kepegawaian Bina Darma," Bina Darma Conference on Computer Science (BDCCS), 3(3).
  13. 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.
  14. 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.
  15. 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.
  16. 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.
  17. 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.
  18. 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.
Similar Articles

Articles sharing related keywords and machine learning classifications:

RANCANGAN SISTEM INFORMASI PERSEDIAAN STOK OBAT DENGAN METODE SYSTEM DEVELOPMENT LIFE CYCLE DI APOTEK NUSA FARMA NUSA PENIDA
Vol. 4 No. 1 (2023) • DOI: 10.35870/jimik.v4i1.130
Perancangan Sistem Perpustakaan Digital Berbasis Android dengan QR Code pada MTsN 2 Kota Bekasi
Vol. 7 No. 3 (2026) • DOI: 10.63447/jimik.v7i3.1980
Implementasi Aplikasi Pemesanan Lapangan Badminton Berbasis Android Menggunakan Flutter pada UMKM GOR Tambora Jakarta Barat
Vol. 7 No. 3 (2026) • DOI: 10.63447/jimik.v7i3.2017
Implementasi REST API Pada Sistem Informasi Tempat Wisata di Yogyakarta Berbasis Android
Vol. 5 No. 1 (2024) • DOI: 10.35870/jimik.v5i1.496
Digitalisasi UMKM Bengkel melalui Sistem Booking Servis dan Monitoring secara Real-Time
Vol. 7 No. 3 (2026) • DOI: 10.63447/jimik.v7i3.2014
Most read articles by the same author(s)

Other papers published by author(s) in this journal:

PENGEMBANGAN APLIKASI TEMPAT PENGOLAHAN SAMPAH BERBASIS ANDROID MENGGUNAKAN MODEL EXTREME PROGRAMMING DAN BLACK BOX TESTING
Pramayota Fane'a Lampung, I Putu Agus Eka Pratama • Vol. 4 No. 2 (2023)
Pengujian High Availability pada Asynchronous DNS Berbasis Restknot menggunakan Algoritma Round Robin
I Putu Agus Eka Pratama, Putu Veda Andreyana, Putu Ramaditya Nurjana • Vol. 5 No. 1 (2024)
SMALL ROAD MONITORING SYSTEM FOR FOUR WHEEL VEHICLES
Efraim William Solang, I Made Agus Dwi Suarjaya, I Putu Agus Eka Pratama • Vol. 4 No. 1 (2023)