I have created a “NYC Traffic Accident Report Year 2018” dashboard, which is integrated to Google Cloud (underlay data) and Power BI from 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.
Measures:
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
2. Collision Per Day
3. Death Per Day
Report Link: NYC Report
Regards,
Farooq K Aziz
Snr. BI and Data Analytics Consultant
Email: azizfk@yahoo.com
Skype: farooqk.aziz
eyJrIjoiNGUxZDJjYjQtZGU0MC00OTMwLWE1YmEtZDUxNWEzMDc5MjIyIiwidCI6IjkyYWVlZTNjLTk2OWYtNDU5OS1iM2ZkLTQyYmQ3ZTA1NTliOCIsImMiOjl9
