Road-Accident-

Data analysis on Road Accident dataset; This project involes the process of Data Cleaning, Data Processing, Data Analysis, Data Visualization and Report/Dashboard using MS Excel. *Note: The dataset used in this project is just a demo data not a real time data. Is is just for the practice purpose.

REQUIREMENT

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

1. Primary KPe - Total Casualties taken place after the accident
2. Primary KPI's - Total Casualties and perentage of total with respect to accident severity and miximum casualties by type of vehicle.
3. Secondary KPI's - Total casualties with respect to vehicle type.'
4. Monthly trend of current year and previous year
5. Max casualties by Road type
6. Distributtion of total casualties by road surface
7. Relation between casualties by Area/Location and by Day/Night.

METADATA

1. File Extension= .xslx
2. No.of Rows - 3.07 million
3. No.of Fields- 21.