Dashboard Preview
This Road Accident Analytics dashboard is a data analysis project created using Excel. It provides valuable insights and visualizations based on road accident data for the years 2021 and 2022. The dashboard offers various key performance indicators (KPIs) and statistics to help gain insights into road accident requirements. The following sections outline the requirements, steps followed in the project, and the key insights obtained.
The clients' requirements for the road accident dashboard are as follows:
Total Casualties: Show the total number of casualties that took place after the accident. Casualties by Severity and Vehicle Type: Display the total casualties and the percentage of total casualties based on accident severity and the type of vehicle involved. Also, identify the type of vehicle with the maximum casualties. Casualties by Vehicle Type: Present the total casualties categorized by the type of vehicle involved. Monthly Trend: Compare the casualties for the current year and the previous year on a monthly basis. Maximum Casualties by Road Type: Identify the road type with the maximum number of casualties. Casualties Distribution by Road Surface: Display the distribution of total casualties based on the road surface conditions. Casualties Relation by Area/Location & Day/Night: Analyze the relationship between casualties and the area/location of the accident, as well as casualties during the day and night. Steps Followed
Data Cleaning: In this step, the data was cleaned by removing inconsistencies, errors, and duplicates. The goal was to ensure the accuracy and reliability of the data for further analysis. Data Processing: New columns were created to organize, sort, and filter the data for extracting meaningful insights. Data Analysis: Various statistical methods were applied to derive valuable insights from the data. Data Visualization: Excel was utilized as a visualization tool to create attractive charts, graphs, and interactive visuals for presenting the data in an easily understandable manner. Dashboard Creation: Finally, a dashboard was built in Excel by incorporating slicers and timelines, enabling users to interact with the data and explore different perspectives.
Based on the analysis of the road accident data, the following key insights were obtained:
📌The total number of casualties that took place after the accidents is 417,883.
📌Car accidents resulted in the highest number of casualties, accounting for 79.8% (333,485) of the total casualties. The type of vehicle with the least casualties is "Others" (3,424).
📌The total number of casualties for the years 2021 and 2022 is 222,146 and 195,737, respectively.
📌The month of 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.
📌Single Carriageway road type had the highest number of casualties, whereas Slip road had the least.
📌The distribution of total casualties was highest on dry road surfaces.
These insights provide a comprehensive understanding of the road accident data and can be used to inform decision-making and implement strategies for improving road safety.
Feel free to explore the dashboard to gain further insights into the road accident analytics.
Note: The data and insights presented in this dashboard are based on the available data for the years 2021 and 2022.
Please refer to the dashboard_preview.png file for a preview of the Road Accident Analytics dashboard.