This Road Accident Data Analysis project was created using Microsoft Excel. An interactive dashboard was created using some Key Performance Indicators (KPIs) to help gain insights into road accident. It provides valuable insights and visualizations based on road accident data for the years 2021 and 2022.
Road accidents are one among the world's leading causes of disabilities and fatalities. The main concern of this road accident data analysis is to identify the key factors causing the road accident and the accident severity.
- Data Cleaning
- Data Analysis
- Data Visualization
Based on the analysis of the road accident data, the following key insights were obtained:
- Total number of casualties is 417,883
- The vehicle type with the highest number of casualties is CAR, amounting to 79.8% (333,485) of the total casualties
- The total number of casualties for the year 2021 is 222,146, while year 2022 is 195,737
- November 2021 had the highest number of casualties, while February 2021 had the lowest. Similarly, November 2022 had the highest number of casualties, and January 2022 had the lowest
You can preview the Road Accident Analysis dashboard to gain further insights into the road accident analytics.
(
The number of car accidents increases every November according to the trend in both year 2021 and 2022. All these insights provides a broad understanding of the road accident data and can be used to inform decision-making and implement strategies for improving road safety.
Based on the useful insights derived from this road accident analysis, these stakeholders such as, Ministry of Road Transportation, Road Safety Corps etc. needs to put adequate measures in place such as New policies, Regulations and Standard Operating Procedures, especially for car maintenance to be done yearly or quarterly by their users. Not ruling out road constructors too.