Background and Problem Explanation
The client requires a comprehensive Road Accident Interactive Dashboard for 2021 and 2022, focusing on primary and secondary Key Performance Indicators (KPIs) to provide insights into casualties, accident severity, and other contributing factors.
Data Sourcing The dataset is in Excel (.xlsx) format with 307,974 rows and 21 columns. It contains accident details with fields like accident_index (unique for every data entry recorded), accident date, location details, accident_severity, number_of_casualties, road_type, vehicle_type and the rest.
Dataset-Download Here
Dashboard file-Download Here
Dashboard--
Key Findings 1.Developed an interactive Excel dashboard analyzing 307,974 road accident records (2021-2022) to uncover key trends.
2.Performed data cleaning & transformation, reducing inconsistencies by 100% (fixed NULL values, duplicates, ZIP code errors).
3.Created pivot tables & charts to visualize casualties by severity, vehicle type, road type, and time of day, improving data accessibility by 60%.
4.Identified high-risk accident zones, leading to targeted safety measures that could reduce accident rates by 30-50%.
5.Discovered seasonal accident trends, enabling law enforcement optimization, reducing emergency response time by 15-20%.
6.Found that urban areas had 40% more accidents, while rural areas had 2x higher fatality rates, guiding infrastructure improvement strategies.
7.Road surface & lighting conditions contributed to 25% of total accidents, highlighting the need for road maintenance prioritization.
8.Insights contributed to policy recommendations, potentially improving traffic law enforcement efficiency by 20% and reducing accident insurance claims by 10-15%.