Road Accident Analysis

The Steps I am taken: . Raw Data Overview . Connecting Data with Power BI . Data Cleaning in Power Query . Data processing . Use Time Intelligence function/Calender Date table in Power BI . Data Modelling (Relationship between multiple tables) . YTD and YoY Growth Calculations using DAX . KPI and KPI Advanced KPI generations .Creating custom columns and measures in the reports .Importing Images .Creating different charts and generating insights

Below the Insights:

1. KPI= Total casualities and Total Accident values for Current year and YoY growth.--> so Insight is as respect to the last year the current year has been reduced by -11%.
2. KPI= Total casualities by Accident Severity for Current year and YoY growth. --> it is decrease the total accidents have been decreased by 11%
3. KPI= Total casualities with respect to vehicle type for current year --> we can see tht car is one particular vehicle type which is creating maximum number of aacidents are offered due
4. Area Chart- Monthly Trend showing comparsion of causalities for current year and previous year
5. Causalities by Road Type for current year-->> we can say most of the causalities in single carriageway road.
6. Current year Causalties by Area/Location & by Day/Night
7. Total Causalties and Total Accidents by location.