Implementasi Business Intelligence Menggunakan ETL dan K-MEANS untuk Visualisasi Data Bencana Alam di Jawa Barat
DOI:
https://doi.org/10.32627/internal.v7i2.1183Keywords:
Bencana Alam, Business Intelligence, Extract, Transform, Load, K-Means, Google Data StudioAbstract
In addition to its abundant natural wealth, West Java also harbors a high potential for disasters. The increasing frequency of natural disasters in recent years, such as earthquakes, landslides, and floods, has caused significant losses to the community. Climate change and environmentally unfriendly human activities are the main factors causing these disasters. Therefore, mitigation and preparedness efforts are key in facing future disaster threats. Business Intelligence can be used to process data and provide relevant information, which is a part of information technology. The purpose of this research is to visualize areas affected by natural disasters in West Java Province by implementing Business Intelligence. The method of this research is obtained in the form of a dataset sourced from the West Java Provincial Community and Village Empowerment Office, obtained through https://opendata.jabarprov.go.id/id for the period from 2020 to 2022. In this research, ETL (Extract, Transform, Load) is used to handle data, including extraction (Extract), transformation (Transform), and loading (Load), as well as K-Means calculations to cluster regions based on clusters. The result of this research is in the form of a dashboard report with the help of Google Data Studio, displaying data visualization results for the West Java region affected by natural disasters. Based on the visualization results, the areas in West Java Province with a high risk of natural disasters that fall into the first cluster in 2020 had 2 regions, in 2021 had 4 regions, and in 2022 had only 1 region.
References
Sariasih, F. A. . (2022). Implementasi Business Intelligence Dashboard dengan Tableau Public untuk Visualisasi Propinsi Rawan Banjir di Indonesia. Jurnal Pendidikan Tambusai, 6(2), 14424–14431. doi.org/10.31004/jptam.v6i2.4715.
M. R. Atsani, G. Tyas Anjari, and N. Mega Saraswati, Pengembangan Business Intelligence Di Rumah Sakit (Studi Kasus: RSUD Prof. Dr. Margono Soekarjo Purwokerto), vol. 12, no. 2. dspace.uii.ac.id, 2019. doi: 10.35671/telematika.v12i2.839.
J. C. Nugroho, I. N. Y. A. Wijaya, and A. A. N. Redioka, “Penerapan Aplikasi Business Intelligence Pada Manajemen Report Guna Menunjang Pengambilan Keputusan,” Jutisi J. Ilm. Tek. Inform. dan Sist. Inf., vol. 10, no. 2, p. 335, 2021, doi: 10.35889/jutisi.v10i2.671.
I. P. W. Prasetia and I. N. H. Kurniawan, “Implementasi ETL (Extract, Transform, Load) pada Data warehouse Penjualan Menggunakan Tools Pentaho,” TIERS Inf. Technol. J., vol. 2, no. 1, pp. 1–8, 2021, doi: 10.38043/tiers.v2i1.2844.
I. Nuryani and D. Darwis, “Analisis Clustering Pada Pengguna Brand Hp Menggunakan Metode K-Means,” Pros. Semin. Nas. Ilmu Komput., vol. 1, no. 1, p. 2021, 2021.
W. Irmayani, “Visualisasi Data Pada Data Mining Menggunakan Metode Klasifikasi,” J. Khatulistiwa Inform., vol. IX, no. I, pp. 68–72, 2021.
K. K. Dewi, A. Hermawan, and L. W. Kusuma, “Penerapan Dashboard Business Intelligence Untuk Menampilkan Fundamental Saham Lq45,” Algor, vol. 3, no. 1, pp. 60–70, 2021, doi: 10.31253/algor.v3i1.768.
I. Wahyudi and A. Syazili, “Dashboard Monitoring Website Dosen Studi Kasus Universitas Bina Darma,” J. Pengemb. Sist. Inf. dan Inform., vol. 2, no. 3, pp. 188–197, 2021, doi: 10.47747/jpsii.v2i3.555.
Heri Purnadi, “Pemanfaatan Google Spreadsheet Dan Google Data Studio Sebagai Dashboard Suhu Dan Kelembaban Di Laboratorium,” Insa. Metrol. PPSDK, vol. 1, no. 1, pp. 28–33, 2021, doi: 10.55101/ppsdk.v1i1.639.
S. A. Hendrawan and D. Setyantoro, “Pemanfaatan Dashboard Business Intelligence untuk Laporan Penjualan pada Superstore,” Tekinfo J. Bid. Tek. Ind. dan Tek. Inform., vol. 23, no. 1, pp. 46–52, 2022, doi: 10.37817/tekinfo.v23i1.1876.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2024 Devie Firmansyah, Deni Ramdani, Awaluddin Dongoran, Andi Moch Januriana

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