Implementasi Business Intelligence Untuk Analisis Data Tingkat Kerawanan Kebakaran Berbasis Wilayah
DOI:
https://doi.org/10.47065/bulletincsr.v6i3.1060Keywords:
Business Intelligence; Data Warehouse; Fire Risk; OLAP; DashboardAbstract
This study aims to implement a Business Intelligence (BI) approach to analyze fire risk levels based on regional characteristics using open government data from Satu Data Jakarta. The dataset consists of 5,471 records for the period 2024–2025, including hazard, vulnerability, and capacity indicators at the neighborhood (RW) level. The methodology involves Extract, Transform, Load (ETL) using Python, data warehouse design with a star schema in PostgreSQL, OLAP-based analysis using SQL queries, and visualization through a web-based dashboard. The results indicate a significant increase in the proportion of high-risk areas from 16.62% in 2024 to 33.42% in 2025. However, this increase does not fully reflect actual changes in field conditions and may also be influenced by data distribution and the underlying risk classification system. Furthermore, the analysis reveals that fire risk is not evenly distributed but concentrated in specific regions, particularly in several districts of East Jakarta and South Jakarta, highlighting the importance of spatial-based approaches in determining mitigation priorities. This study utilizes pre-defined risk categories provided by the data source without performing predictive modeling or reclassification. The BI implementation not only integrates disparate data but also uncovers distribution patterns, risk trends, and regional priorities more systematically compared to conventional descriptive analysis. The findings contribute to supporting data-driven decision-making, especially in identifying priority areas for fire risk mitigation.
Downloads
References
H. A. Rosit, A. Mardhotillah, R. A. Delazenitha, S. Mutiarani, and T. V. C. Sulle, “Identifikasi dan Mitigasi Kebakaran Hutan dan Lahan melalui Zonasi Wilayah Rawan Kebakaran dengan Teknologi Geospasial,” Widya Bhumi, vol. 3, no. 1, pp. 13–30, May 2023, doi: 10.31292/wb.v3i1.53.
S. Maesaroh, R. R. Lubis, L. N. Husna, R. Widyaningsih, and R. Susilawati, “Efektivitas Implementasi Manajemen Business Intelligence pada Industri 4.0,” ADI Bisnis Digital Interdisiplin Jurnal, vol. 3, no. 2, pp. 1–8, Jul. 2022, doi: 10.34306/abdi.v3i2.764.
A. W. Nugroho and A. A. G. S. Utama, “Business Intelligence Systems and Their Impact on Organizational Decision-Making and Performance Outcomes: Literature Review,” owner, vol. 9, no. 2, Apr. 2025, doi: 10.33395/owner.v9i2.2646.
T. Santhi, A. Monica Sari, D. Ketut Alit Maha Putra, G. Surya Mahendra, and M. Putri Ariasih, “Implementasi Business Intelligence Menggunakan Tableau Untuk Visualisasi Prediksi Kelulusan Mahasiswa,” Journal of Software Engineering and Information Systems, vol. 3, no. 2, pp. 51–58, Dec. 2021, doi: 10.37859/seis.v3i2.5436.
I. Indriyani, I. P. B. Wiranata, and S. Hiu, “Strategi Peningkatan Efisiensi Operasional UMKM di Era Digital: Pendekatan Kualitatif dengan Business Intelligence dalam Implementasi E-Commerce,” Informatics For Educators And Professional?: Journal of Informatics, vol. 9, no. 1, p. 23, Jun. 2024, doi: 10.51211/itbi.v9i1.2760.
D. A. Utama, E. Sumantri, and T. Tardin, “Analisa Tingkat Kerawanan Kebakaran Di Kecamatan Tebet Untuk Mengetahui Zona Siaga Kebakaran Menggunakan Tableau Public,” Jurnal Sains dan Teknologi, vol. 5, no. 1, pp. 409–412, Sep. 2023, doi: 10.55338/saintek.v5i1.1372.
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, Dec. 2022, doi: 10.30865/json.v4i2.5316.
A. Pasa Andita, “Implementasi Google Looker Studio Untuk Visualisasi Bencana Alam Di Indonesia.,” Jurnal Teknologi Informasi Dan Komunikasi, vol. 17, no. 1, pp. 12–19, Mar. 2026, doi: 10.51903/jtikp.v17i1.1382.
S. K. M. K. M. Arifin and F. N. Romadlon, “Implementasi Business Intelligence dengan Menggunakan Google Looker Studio untuk Visualisasi Data Tracer Studi guna Mendukung Perbaikan Kurikulum,” Simetris: Jurnal Teknik Mesin, Industri, Elektro dan Ilmu Komputer, vol. 16, no. 2, Nov. 2025, doi: 10.24176/simet.v16i2.14548.
T. Tumini, N. E. Nurhayati, and Z. Zaharuddin, “Implementasi Business Intelligence Dalam Visualisasi Data Bencana Banjir Di Indonesia,” Jurnal Informasi dan Komputer, vol. 13, no. 02, pp. 54–60, Oct. 2025, doi: 10.35959/jik.v13i02.756.
A. Rusydi and F. N. Hasan, “Implementasi business intelligence untuk visualisasi kekuatan sinyal internet di Indonesia menggunakan platform tableau,” TEKNOSAINS?: Jurnal Sains, Teknologi dan Informatika, vol. 10, no. 1, pp. 132–141, Jan. 2023, doi: 10.37373/tekno.v10i1.378.
R. Al Fauzi, “Analisis tingkat kerawanan banjir Kota Bogor menggunakan metode overlay dan scoring berbasis sistem informasi geografis,” Geomedia Majalah Ilmiah dan Informasi Kegeografian, vol. 20, no. 2, pp. 96–107, Nov. 2022, doi: 10.21831/gm.v20i2.48017.
S. Siska and D. S. Putri, “Implementasi Business Intelligence Untuk Menganalisis Perbandingan Data Kasus Covid-19 Di Jawa Barat Sebelum Psbb Dan Setelah Psbb,” Edutic - Scientific Journal of Informatics Education, vol. 7, no. 2, May 2021, doi: 10.21107/edutic.v7i2.9893.
S. K. M. K. M. Arifin and F. N. Romadlon, “Implementasi Business Intelligence dengan Menggunakan Google Looker Studio untuk Visualisasi Data Tracer Studi guna Mendukung Perbaikan Kurikulum,” Simetris: Jurnal Teknik Mesin, Industri, Elektro dan Ilmu Komputer, vol. 16, no. 2, Nov. 2025, doi: 10.24176/simet.v16i2.14548.
R. Darmawan and G. Swalaganata, “Analisa Komparatif Power Bi Dan Tableau Dalam Implementasi Business Intelligence Pada Brazilian E-Commerce Public Dataset By Olist,” JATI (Jurnal Mahasiswa Teknik Informatika), vol. 9, no. 5, pp. 8936–8944, Jul. 2025, doi: 10.36040/jati.v9i5.15178.
B. Rozak, D. Febriawan, and F. N. Hasan, “Implementasi Business Intelligence untuk Visualisasi Laju Indeks Pembangunan Manusia Kota Cirebon Menggunakan Google Collab,” Sainteks, vol. 21, no. 1, p. 33, Apr. 2024, doi: 10.30595/sainteks.v21i1.21356.
D. Afrizal, R. M. Putra, and M. Syafii, “Analisis Spasial Tingkat Kerawanan Kebakaran Hutan dan Lahan di Kabupaten Indragiri Hulu,” Daun: Jurnal Ilmiah Pertanian dan Kehutanan, vol. 12, no. 1, pp. 77–87, Jun. 2025, doi: 10.33084/daun.v12i1.9750.
Adhi Rangga Evalianto, I. B. Mataburu, and M. Jalaludin, “Analisis Lokasi Pos Damkar Berdasarkan Peta Kerawanan Kebakaran Menggunakan SIG Di Jakarta Timur,” JPIG (Jurnal Pendidikan dan Ilmu Geografi), vol. 9, no. 2, pp. 160–169, Sep. 2024, doi: 10.21067/jpig.v9i2.10301.
Y. A. Tangkasiang, “Tingkat Kerawanan Kebakaran Hutan dan Lahan di Kecamatan Dusun Selatan Kabupaten Barito Selatan Kalimantan Tengah,” Daun: Jurnal Ilmiah Pertanian dan Kehutanan, vol. 11, no. 2, pp. 154–165, Dec. 2024, doi: 10.33084/daun.v11i2.7444.
Helmalia, Y. Wicaksono, A. Akbar Harahap, and T. Rochmadi, “Implementasi Business Intelligence untuk Visualisasi Data Pengembangan Kompetensi Aparatur Sipil Negara Di Kabupaten Lebak,” Jurnal Teknologi informasi dan Ilmu Komputer, vol. 1, no. 2, pp. 49–58, Apr. 2025, doi: 10.65258/jutekom.v1.i2.7.
C. B. Santoso, R. Khairunnisa, M. Rachma, and S. Humayyah, “Implementasi Data Warehouse dan Business Intelligence untuk Pemantauan dan Analisis Penjualan Game,” TeknoIS?: Jurnal Ilmiah Teknologi Informasi dan Sains, vol. 15, no. 1, pp. 40–50, Feb. 2025, doi: 10.36350/jbs.v15i1.303.
I. Cahyati et al., “Penerapan Business Intelligence Dengan Artificial Intelligence Pada E-Commerce,” SENTRI: Jurnal Riset Ilmiah, vol. 3, no. 6, pp. 2741–2756, Jun. 2024, doi: 10.55681/sentri.v3i6.2904.
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,” INTERNAL (Information System Journal), vol. 7, no. 2, pp. 109–122, Dec. 2024, doi: 10.32627/internal.v7i2.1183.
Bila bermanfaat silahkan share artikel ini
Berikan Komentar Anda terhadap artikel Implementasi Business Intelligence Untuk Analisis Data Tingkat Kerawanan Kebakaran Berbasis Wilayah
ARTICLE HISTORY
How to Cite
Issue
Section
Copyright (c) 2026 Javier Alvino Alfian, Denny Ganjar Purnama
This work is licensed under a Creative Commons Attribution 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 Creative Commons Attribution 4.0 International License that allows others to share the work with an acknowledgment 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 acknowledgment 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 (Refer to The Effect of Open Access).
