Road_Accident_Analysis

Step In Project

1. Requirement Gathering
2. Stakeholders in Project
3. Raw Data Overview
4. Connect Data with Power BI
5. Data Cleaning
6. Data Processing
7. Data Modelling
8. Data Visualization or Chart Design

Requirement

Client Wants Accident Analysis for year 2021 and 2022. they want insights on below Requirements-

1. Primary KPI- Total Casualities 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 vechicles type for current year.
4. Monthly trend show comparison of casualties for current year and previous year.
5. Casualties by road type for current year.
6. Current year Caasualties by road or loacation and Day or Night.
7. Total casualties and Total accident by location.

Power BI Functionalities

1. How to Connect Raw Data.
2. Data Cleaning in Power Query
3. Data Processing
4. Time Intelligence Function
5. Data Modelling (Relationship between tables)
6. Creating Custom Columns and Measures in the reports.