Road-Accident-Analysis

In This project i did the following

• data gathering

• data cleaning

• data processing

• data analysis

• data visualization (dashboard creation in Excel).

Requirements

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

Primary KPI's

• Total causalties taken place after the accident

• Total Causalties&percentage of total with respect to accident severity and maximum causalties by type of vehicle

Secondary KPI's

• Total Causalties with respect to vehicle types

• Monthly trend showing comparison of causalties for current Year and previous Year

• Maximum causalties by Road Type

• Distribution of total causalties by Road Surface

• Relation between causalties by Area /Location&by Day /Night