For the second edition of the Dashboard Week, I explored the datasets related to fires detected in Indonesia. The dataset is obtained from MODIS. You can find the link to the data here. I extracted other datasets on weather from 1991 to 2021 in Jakarta (link to the dataset can be found here) and the number of trees loss in Indonesia as a result of fires (link to website).

Merging datasets from MODISĀ 

I downloaded all the datasets for Indonesia (2001 – 2022) on fires detected, and merged them using a batch macro to read all file names. I created unique IDs for each fire incident. This is how the workflow looks like. Most attributes are clean and there is not many data preparation to do.

Build Tableau Dashboard

The final dashboard looks like this. There are interesting insights from the visualisation. In sum, West Kalimantan reported the highest number of fire incidences. Over the past years (2018 – 2022), fire incidences were more prone at Jambi and South Sumatera provinces.

Fires in Jakarta since 2001 to 2022 were low compared to the rest of the states and provinces. Fire Services locations were able to access to majority of the fire locations with 10km away.

The years that recorded the highest number of tree loss coincided with years that recorded the most number of fires detected. Slash-and-burn activities could be the main cause of the fires.



Shaida Shamuri
Author: Shaida Shamuri