View on Github

Project Overview

created a personal project titled "Road Accident Dashboard" using Microsoft Excel to analyze road accident data and identify patterns that can enhance road safety. This project not only enhanced my skills in data analysis and visualization but also provided valuable insights into road safety that can inform future improvements in traffic management and accident prevention strategies.

Key Insights

• Requirement Gathering: Collected requirements from the client to understand their needs.
• Stakeholder Identification: Identified key stakeholders involved in the project.
• Data Cleaning: Removed inconsistencies, errors, and duplicates to ensure data accuracy for analysis.
• Data Processing: Created customized columns for organizing, sorting, and filtering data to extract meaningful insights.
• Data Analysis: Employed various statistical methods to derive valuable insights from the dataset.
• Data Visualization: Utilized Excel to create attractive charts, graphs, and interactive visuals for easy data presentation.
• Dashboard Creation: Built an interactive dashboard with slicers and timelines to allow users to explore the data dynamically.

Key Findings

• Total Casualties: 417,883 casualties occurred as a result of accidents.
• Casualty Breakdown:Maximum casualties were caused by cars (333,485), accounting for 79.8% of total casualties. Minimum casualties were caused by other vehicle types (3,424).
• Yearly Casualties:In 2021, total casualties were 222,146; in 2022, they were 195,737.
• Monthly Trends: Maximum casualties occurred in November 2021 and November 2022; minimums were recorded in February 2021 and January 2022.
• Road Type Analysis: Most casualties occurred on single carriageway roads, while slip roads had the fewest.
• Surface Conditions: The highest distribution of casualties was on dry road surfaces.

Tools Used