RoadAccident_Analysis

Requirements:

Clients wants to create a Road Accident Dashboard for year 2021 and 2022 so that they can have insights on the below requirements-

1. Primary KPI - Total casualties and Total Accident values for current year and year on year growth
2. Primary KPI's - Total casualties by Accident severity for Current year and year on year growth
3. Secondary KPI's - Total casualties with respect to vehicle type for current year
4. Monthly trend showing comparison of casualties for Current year and Previous year
5. Casualties by Road type for Current year
6. Current year Casualties by area/ Location & by Day/ Night
7. Total casualties and Total Accidents by location.

This project will be helpful for many stakeholders Misitry of transport, Police force, Media, Road Transport Department, etc.

Analysis steps:

1. Create a Problem Statement.
2. Identify the data you want to analyze.
3. Explore and clean the data.
4. Analyze the data to get useful insights.
5. Present the data interms of reports or dashboards using visualization.

Analysis:

After processing the data and analyzing it, according to my analysis on the provided dataset, here are my findings:

1. Car is the vehicle which is more responsible for casualties and the least is agricultural vehicle. Most accidents have been occured in or near london mostly.
2. Mostly occured casualties are mainly in November month in both year, least is in december in 2022 and in Februray in 2021.
3. Total casualties in current year is 195 thousand, and accidents is 144 thousand in which 29 thousand is fetal, 27K is serious and 165K is non serious. All the casualties are have been decreased from previous year.
4. According to the findings, there are more accidents in urban area then in rural place.
5. Most of the casualties are occured in day i.e. 73.8% where as in night we have 23.16%.

These are my analysis on the dataset for the stakeholders and hope this analysis may provide good ideas to them so that casualties may reduce more on the road.