The project is all about the analysis of accidents data for 2021 and 2022 with an interactive power BI dashboard.

Problem statement: Generate the insights from the road accidents data for 2021 and 2022 years. Following are the requirments made by the client.

1. Primary KPI - Total Casualties and Total Accident values for Current Year and YoY growth
2. Primary KPI's - Total Casualties by Accident Severity for Current Year and YoY growth
3. Secondary KPI's - Total Casualties with respect to vehicle type for Current Year
4. Monthly trend showing comparison of casualties for Current Year and Previous Year
5. Casualties by Road Type for Current year
6. Current Year Casualties by Area/ Location & by Day/Night
7. Total Casualties and Total Accidents by Location

Steps and Functinalities Performed in the project:

1. Connecting Raw data to power Bi
2. Data Cleaning in Power Query
3. Data ProcessingTime Intelligence Function/ Calendar Date Table in Power BI
4. Data Modelling (Relationship between multiple tables)
5. YTD and YoY Growth Calculations using DAX
6. KPI and Advanced KPI Generations
7. Creating custom columns and measures in the reports
8. Importing Images
9. Creating different charts and generating insights
10. Export the Report to users