What is London Fire Brigade (LFB)?

The London Fire Brigade is the fire and rescue service for London, the capital of the United Kingdom. It was formed by the Metropolitan Fire Brigade Act 1865, under the leadership of superintendent Eyre Massey Shaw. In this blog, I’ll show my process of creating a dashboard based on LFB Fire Incidents data.

 

Dashboard Creation

a) Introduction & Key Number

From Jan 2009 to Sep 2022, there are about 292K fire incidents, accounting for almost 20% of total incidents. However, False Automatic Fire Alarms accounted for around 36% of the total incidents, leading to a loss of 176.1M pounds. That loss is equal to almost 30% of the total spend.

Figure 1. Introduction of Dashboard

 

b) Create a map chart to show the distribution of fire incidents

From 2009 to 2022, most fire incidents happened in central London.

Figure 2. London Boroughs

 

c) Add drilldown-function

Figure 3. Drilldown for selected Borough

 

d) Create a heatmap & line chart to show the relationship between the frequency of fire incidents and temperature

April, May, June, July, and August are usually the months that will have more fire incidents.

In summer and autumn, the temperature is high, which could contribute the fire incidents.

Figure 4. Heatmap & Line Chart

 

e) Arrange the Layout and Finalise the Dashboard

Figure 5. Final Dashboard

 

You can click here to interact with the dashboard functionality. If there are any problems, please feel free to point them out. Besides, you can reach out to me on LinkedIn. I will try my best to answer your questions about Tableau or Alteryx.

 

Joe Chan
Author: Joe Chan

Joe has an IT background with a master's degree in UNSW, majoring in AI and Data Science. During his studies, he realized Data is one of the most valuable assets a business can have and potentially has a tremendous impact on its long-term success. After graduation, his desire to level up his data analytics skills led him to join The Data School. He is interested in Data Wrangling, Data Visualization, and Machine Learning, eager to be a great Data Analyst to help businesses grow.