clients wants to create a Road Accident Dashboard from year 2021 and 2022 so that they can have insight on below requirements:
- Primary KPI - Total Casualties and Total Accident values from current year and YoY growth.
- Primary KPI's - Total Casualties by Accident Severity for Current Year and YoY growth.
- Seconday KPI's - Total Casualties with respect to vehicle type for Current Year.
- Monthly trend showing comparison of Casualties for Current Year and Previous Year.
- Casualties by Road type for Current Year.
- Current Year Casualties by Area/Location & Day/Night.
- Total Casualties and Total Accidents by Location.