Road Accident Dashboard

I developed an interactive Road Accident Analysis Dashboard to analyze and visualize traffic accident data, helping stakeholders understand key risk factors and trends. The dashboard presents critical insights such as total fatalities, injuries, vehicles involved, and pedestrian casualties.

Key Features & Insights:

Accident Causes Analysis: Identifies major causes like drunk driving, distracted driving, speeding, mechanical failure, and weather conditions.

Injuries & Fatalities by Road Surface: Compares accident severity on dry, icy, snow-covered, and wet roads.

Geographical Analysis: Highlights accident distribution across Asia, Australia, Europe, North America, and South America.

Time-Based Trends: Displays accident frequency by morning, afternoon, and night, helping pinpoint high-risk time periods.

Economic Impact: Visualizes financial losses due to road accidents across different countries.

Technologies Used:

• Excel for interactive dashboards & data visualization.

• Python & SQL for data cleaning, transformation, and analysis.