Is the NYC Dangerous Driving Campaign working?

This project is based on the May 2022 launch of the City of New York's campaign to curb dangerous driving behaviors. The data set includes data from January 1, 2021, to April 9, 2023. My goal with this analysis is to show a clear story of how the collision trends have changed Month-over-Month from a pre-campaign to a post-campaign launch perspective and to recommend solutions to improve the effectiveness of the campaign.

To create a fair year-over-year comparison, I used the following dates:

• 5/1/2021 to 4/9/2022 = Pre-Campaign stats
• 5/1/2022 to 4/9/2023 = Post-Campaign stats

My dashboard is broken down into 2 halves and begins with a high-level overview of how many accidents, injuries, and deaths occurred in the whole dataset. The left half of the dashboard starts with a story of the month-over-month traffic accident trends and flows into the positives and negatives of the campaign. The right side of the dashboard focuses on how New York City can decrease the number of accidents by focusing on top accident factors and time periods.

The design of my dashboard is heavily influenced by Enrique's design in the Advanced Excel Dashboard Design course. I really like the way he lays out his explanatory dashboards in that course, and it made the most logical sense to the flow of my dashboard's story.

I used Excel to complete this project and used formulas such as:

• SUM, SUMIFS
• COUNTIFS
• LEFT, RIGHT
• RANK
• INDEX
• MATCH