Task Requirement

Clients want to create 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: 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.

Dashboard Information

  • Category: Dynamic Dashboard
  • Project date: 01 Janaury, 2024
  • Tools: Microsoft Excel
  • Project URL: Click Here

Stakeholders Details

  • Ministry of Transport
  • Road Transport Department
  • Police Force
  • Emergency Services Department
  • Road Safety Corps
  • Public
  • Media
  • Transport Operators
  • Traffic Management Agencies