A Tableau-Based Business Intelligence Dashboard for Multidimensional Analysis of Natural Disaster Impacts in Indonesia

Vina Trializa; Firman Noor Hasan

doi:10.56427/jcbd.v5i3.1040

Authors

Vina Trializa Universitas Muhammadiyah Prof. Dr. Hamka
Firman Noor Hasan Universitas Muhammadiyah Prof. Dr. Hamka https://orcid.org/0000-0002-1246-3462

DOI:

https://doi.org/10.56427/jcbd.v5i3.1040

Keywords:

Business Intelligence, Data Warehouse, Tableau Dashboard, Kimball Nine-Step Methodology, Natural Disaster

Abstract

Indonesia is highly vulnerable to natural disasters and generates large volumes of disaster data each year. However, this information is still presented predominantly in tabular reports, which limits multidimensional analysis and weakens its value for evidence-based decision-making. Existing studies emphasize descriptive visualization without integrating a data warehouse architecture to support comprehensive disaster analytics. This study therefore develops a Tableau-based Business Intelligence dashboard supported by a data warehouse for multidimensional analysis and forecasting of natural disaster impacts in Indonesia. The data warehouse was designed using Ralph Kimball’s Nine-Step Methodology, and the Extract, Transform, Load (ETL) process was implemented in Pentaho Data Integration. The dataset comprises 21,986 disaster events recorded by the National Disaster Management Agency (BNPB) from January 2021 to September 2025. The dashboard provides interactive visualizations of disaster trends, regional distribution, casualties, damage levels, and the ten provinces with the highest recorded impacts, together with forecasting based on Tableau’s exponential smoothing (ETS) model. The analysis identified West Java as the province with the highest recorded disaster impacts in absolute terms during the study period. The resulting platform integrates data warehousing, multidimensional visualization, and forecasting to support disaster mitigation and response planning.

Downloads

Download data is not yet available.

Author Biographies

Vina Trializa, Universitas Muhammadiyah Prof. Dr. Hamka

Departement of Informatics Engineering

Firman Noor Hasan, Universitas Muhammadiyah Prof. Dr. Hamka

Departement of Informatics Engineering

References

[1] M. G. Rachman, Z. T. Zelvany, F. E. Favali, and M. R. A. P. Nugraha, “Analisis Risiko Kebencanaan Indonesia untuk Mendukung Kebijakan Publik,” Journal of Infrastructure Policy and Management, vol. 8, no. 1, pp. 85–96, Jun. 2025, doi: 10.35166/jipm.v8i1.99.

[2] F. D. Cahyo, F. Ihsan, Roulita, N. Wijayanti, and R. Miwanti, “Kesiapsiagaan Bencana Gempa Bumi dalam Keperawatan: Tinjauan Penelitian,” Jurnal Kesehatan Poltekkes Palembang, vol. 18, no. 1, 2023, doi: 10.36086/jpp.v18i1.

[3] M. Danil, “Manajemen Bencana,” Prosiding Seminar Nasional dan Internasional, vol. 1, pp. 7–14, 2021, doi: 10.46576/prosundhar.v1i0.2.

[4] R. Ramadhan, M. Hanif, M. Marzuki, H. Hashiguchi, W. Harjupa, and H. Yusnaini, “Spatio-temporal variability of hydrometeorological disasters in Indonesia based on national disaster risk management data,” International Journal of Disaster Risk Reduction, vol. 143, Art. no. 106256, 2026, doi: 10.1016/j.ijdrr.2026.106256

[5] R. Aprianto, P. A. D. Puspitasari, S. Fitriyanto, and A. Tawaqqal, “Analisis Potensi Bencana Banjir Berdasarkan Hasil Prediksi Curah Hujan di Kabupaten Sumbawa,” Titian Ilmu: Jurnal Ilmiah Multi Sciences, vol. 16, no. 2, pp. 124–133, 2024, doi: 10.30599/jti.v16i2.3436.

[6] D. Firmansyah, D. Ramdani, A. Dongoran, and A. M. Januriana, “Implementasi Business Intelligence Menggunakan ETL dan K-MEANS untuk Visualisasi Data Bencana Alam di Jawa Barat,” Information System Journal (INTERNAL), vol. 7, no. 2, pp. 109–122, 2024, doi: 10.32627/internal.v7i2.1183.

[7] S. Maesaroh, R. R. Lubis, L. N. Husna, R. Widyaningsih, R. Susilawati, and P. M. Yasmin, “Efektivitas Implementasi Manajemen Business Intelligence pada Industri 4.0,” ADI Bisnis Digital Interdisiplin (ABDI Jurnal), vol. 3, no. 2, pp. 1–8, 2022, doi: 10.34306/abdi.v3i2.764.

[8] G. Vial, “Understanding digital transformation: A review and a research agenda,” Journal of Strategic Information Systems, vol. 28, no. 2, pp. 118–144, 2019, doi: 10.1016/j.jsis.2019.01.003

[9] Y. Ramadhani, D. M. Khairina, and S. Maharani, “Implementasi Business Intelligence dalam Analisa Penjualan Mobil Mitsubishi Menggunakan Visualisasi Data,” Adopsi Teknologi dan Sistem Informasi (ATASI), vol. 3, no. 1, pp. 1–11, 2024, doi: 10.30872/atasi.v3i1.435.

[10] F. S. Utomo and Z. Lubna, “Visualisasi Data Penjualan untuk Menentukan Bussiness Insight menggunakan Metabase pada Perusahaan Retail Global,” Sistemasi: Jurnal Sistem Informasi, vol. 13, no. 4, pp. 2540–9719, 2023, doi: 10.32520/stmsi.v13i4.3870.

[11] W. Purbasari et al., Sistem Basis Data. CV. Tohar Media, 2024.

[12] D. F. Lessy, A. Avorizano, and F. N. Hasan, “Penerapan Business Intelligence untuk Menganalisa Data Gempa Bumi di Indonesia Menggunakan Tableau Public,” Jurnal Sistem Komputer dan Informatika (JSON), vol. 4, no. 2, p. 302, 2022, doi: 10.30865/json.v4i2.5316.

[13] T. J. Irwan and D. Trisnawarman, “Perancangan Dashboard untuk Visualisasi Data Gempa Berpotensi Tsunami di Indonesia dengan Metode Business Intelligence Roadmap,” Journal of Information Technology and Computer Science (INTECOMS), vol. 7, no. 3, pp. 881–885, 2024, doi: 10.31539/intecoms.v7i3.10403.

[14] A. R. Abdillah, H. Z. Muflih, A. B. Pranata, and F. N. Hasan, “Penerapan Business Intelligence Untuk Analisis Kematian di Indonesia Tahun 2000-2022,” Jurnal Informatika, vol. 10, no. 2, pp. 185–193, 2023, doi: 10.31294/inf.v10i2.16569.

[15] Hasdi Putra and B. Aulia, “Penerapan Data Warehouse dan Dashboard Berbasis Kimball Nine-Step untuk Meningkatkan Kualitas Informasi dan Pengambilan Keputusan,” JSI: Jurnal Sistem Informasi (E-Journal), vol. 15, no. 1, pp. 3150–3158, Apr. 2023, doi: 10.18495/jsi.v15i1.116.