Road Accident Dashboard

?Have you ever wondered what patterns hide behind road accidents

In this project, I analyzed a road accident dataset to uncover trends related to accident frequency, time, location, and severity. I worked on cleaning and organizing the data, creating meaningful time buckets, and analyzing accidents by day, month, and year.

The analysis focused on identifying high-risk periods, accident hotspots using latitude and longitude data, and understanding how factors like time of day and location affect accident occurrence. I also designed an interactive dashboard in Excel to clearly visualize insights using charts, maps, slicers, and KPIs.

This project demonstrates my ability to transform raw accident data into clear, actionable insights that support better decision-making and improve road safety analysis.