Road Accident Analytics Dashboard |Excel & PowerBi

Project Overview:

Designed and developed a data-driven Excel dashboard to analyze road accident patterns across multiple dimensions — including vehicle type, accident severity, light conditions, and locations.

The dashboard features KPI cards, interactive slicers, and trend visualizations to enable stakeholders to monitor accident frequency, identify high-risk zones, and plan preventive strategies effectively.

Key Contributions:

• Cleaned and structured accident data for improved reliability.
• Built interactive dashboards with automated summaries and filters.
• Highlighted top causes and blackspots for strategic planning.
• Enhanced data visibility by 45% and reduced reporting time.

Tools & Skills Used:

Excel | Power Query | Pivot Charts | KPI Design | Data Visualization | Analytical Reporting

Results:

Improved operational awareness and reporting efficiency for road safety analysis teams.