REQUIREMENT DASHBOARD

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

-> Primary KPI - Total Casualties taken place after the accident

-> Primary KPI's - Total Casualties & percentage of total with respect to accident severity and maximum casualties by type of vehicle

-> Secondary KPI's - Total Casualties with respect to vehicle type

-> Monthly trend showing comparison of casualties for Current Year and Previous Year

-> Maximum casualties by Road Type

-> Distribution of total casualties by Road Surface

-> Relation between Casualties by Area/ Location & by Day/Night