The Road Accident Dashboard is a comprehensive data analysis project built in Microsoft Excel to analyze and visualize road accident data.
This dashboard provides deep insights into accident severity, casualty distribution, road types, surface conditions, vehicle categories, weather impact, and year-over-year trends.
It is designed to help stakeholders, analysts, and decision-makers understand accident patterns and identify high-risk factors for improved road safety planning.
The primary objective of this project is to:
- Analyze accident severity levels (Fatal, Serious, Slight)
- Compare Current Year (CY) vs Previous Year (PY) casualty trends
- Identify high-risk road types and surface conditions
- Understand vehicle-type contribution to accidents
- Examine the impact of weather and light conditions
- Provide interactive filtering for dynamic data exploration
- Total Casualties: 896,568
- Fatal: 16,483 (1.8%)
- Serious: 129,439 (14.4%)
- Slight: 750,646 (83.7%)
- Car: 694,887
- Van: 77,976
- Bike: 75,680
- Bus: 35,754
- Agricultural Vehicle: 2,613
- Other: 7,838
- Single Carriageway (Highest)
- Dual Carriageway
- Roundabout
- One Way Street
- Slip Road
- Dry (Major Contribution)
- Wet
- Snow
- Other
- Urban
- Rural
Urban areas contribute significantly higher accident cases.
- Daylight (Major Share)
- Darkness
Interactive line chart showing:
- Year-wise comparison (2019–2023)
- Monthly casualty fluctuation
- Seasonal patterns in road accidents
- Microsoft Excel
- Pivot Tables
- Pivot Charts
- Slicers (Interactive Filters)
- Timeline Filter (Year-based analysis)
- Doughnut Charts
- Bar Charts
- Line Charts
- Conditional Formatting
- Custom Dashboard UI Design
✔ Fully Interactive Filters (Weather, Wind Condition, Year, Date) ✔ KPI Cards with Percentage Indicators ✔ Dynamic Charts & Trend Analysis ✔ Clean & Modern Dashboard Layout ✔ Data-Driven Decision Support ✔ Professional Color Theme & Visual Hierarchy
This dashboard helps:
- Government agencies analyze accident severity
- Traffic departments identify high-risk road conditions
- Policy makers understand yearly trends
- Analysts perform data-driven road safety assessment
- Organizations improve risk management strategies
- Data Cleaning & Preparation
- Data Modeling in Excel
- Dashboard Design & Storytelling
- Analytical Thinking
- Trend & Pattern Analysis
- Business Intelligence Reporting
I am a Data Analyst Enthusiast with strong skills in:
- Advanced Excel
- Power BI
- SQL
- Python
- Data Visualization
- Dashboard Development
If you found this project helpful or insightful, feel free to ⭐ star the repository.