NYPD Traffic Accidents Analysis - Dashboard

Downloadable PDF Link : https://acrobat.adobe.com/id/urn:aaid:sc:AP:68be3285-8668-40e5-9b64-7c483efaf8ea

NYC Traffic Accident Analysis

Dashboard's Executive Summary Snapshot (Power BI Service)

Data Ingestion:

Imported NYPD motor vehicle collision data (Jan-Aug 2020) using Power Query, including date, time, location (borough, ZIP, street, lat/lon), vehicles, victims, and contributing factors.

Report's Time Page (Power BI DESKTOP)

Report's Location Page

Report's Accident Factors Page

Report's DateTime Tooltip

Data Modeling:

Developed star schema with DAX measures and calculated columns to establish relationships and key metrics.

Visualizations:

Line Charts:

Compared monthly accident percentages to identify seasonal patterns.

Heatmaps:

Analyzed accident frequency by day of week and hour of day to determine peak times.

Bar Charts:

Identified streets with highest accident reports and their percentage of total accidents.

Pie Charts:

Highlighted most common contributing factors overall and for fatal accidents.

Business Intelligence:

Addressed key business questions to uncover trends, high-risk periods, and factors influencing fatal collisions.

NYPD Traffic Accidents Analysis-Dashboard.md.txt

Displaying # NYPD Traffic Accidents Analysis-Dashboard.md.txt.