Project - 1
Road Accident Analysis
Requirement
Clients want 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 and Total Accident values for Current Year and YoY Growth
>> Primary KPI’s – Total Casualties by Accident Severity for Current Year and YoY Growth
>> Secondary 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 & by Day/Night
>> Total Casualties and Total Accidents by Location
Stake Holders
>> Ministry of Transport
>> Road Transport Department
>> Police Force
>> Emergency Services Department
>> Road Safety Corps
>> Transport Operators
>> Traffic Management Agencies
>> Public
>> Media
Steps In Project
Thanks to our partners, you can find ties online to suit every preference and budget, from budget to top-of-the-range super stylish models.>> Requirement Gathering
>> Stake Holders in Project
>> Raw Data Overview
>> Connecting Data with Power BI
>> Data Cleaning
>> Data Processing
>> Data Modelling
>> Background Design In Power Point
>> Data Visualization/ Charts Design
>> Report/ Dashboard Building
>> Insights
Skills I Gained After Doing This Project:-
- How to connect to raw data/ flat file
- Data Cleaning in Power Query
- Data Processing
- Time Intelligence Function/ Calendar Data Table in Power BI
- Data Modelling (Relationship between multiple tables)
- YTD and YoY Growth using DAX
- KPI and Advanced KPI Gnerations
- Creating custom columns and measures in the reports
- Importing Images
- Creating different charts and Images