I have created a “NYC Traffic Accident Report Year 2018” dashboard, which is integrated to Google Cloud (underlay data) and Power BIfrom NYC Department of Information Technology & Telecommunications, and City of New York.
Cleaning: I cleaned the unwanted data,replace null values, user friendly values through M and query editor.
Transform: Performed data transformation by changing the formats of the columns, date time formats, and merged columns for data integrity and data insights.
Death per Day: Using Calculate and Sumx for merging 5 column values into measure.
Rank Contribution Factor: Using RankX along with Count Contribution (nested measure)
Selected Top Contribution Value: Using IF and HASONEVALUE along with MAXX, and Rack Contribution Factor(nested Measure)
Data Insights 1. Top Contribution Factor for Accident