This project presents an interactive Excel dashboard analyzing road accident data to uncover key trends, severity levels, and contributing factors. Designed for aspiring data analysts, it demonstrates end-to-end Excel capabilities—from data cleaning to dashboard creation.
The goal is to transform raw road accident data into actionable insights using Excel’s built-in tools. The dashboard enables users to explore accident patterns by vehicle type, road conditions, time of day, and more.
- Excel Power Query: Data cleaning and transformation
- Pivot Tables: Aggregation and dynamic filtering
- Slicers & Timelines: Enhanced interactivity
- Charts: Donut, bar, line, and pie charts for visual storytelling
- Conditional Formatting: Highlighting key metrics
- Casualties segmented by vehicle type, road type, and surface condition
- Monthly trend comparison between current and previous year
- Severity breakdown: Fatal, Serious, and Slight injuries
- Area-wise analysis: Urban vs. Rural, Day vs. Night