Maven Commuter Challenge - Post-Pandemic Traffic Recovery

This project involves creating an interactive Power BI dashboard to analyze and track post-pandemic traffic recovery in New York City. It focuses on key transit metrics for subways, buses, railways, and bridge & tunnel traffic, comparing current trends to pre-pandemic levels.

Goals:

• Provide actionable insights into transit recovery progress.
• Highlight trends and identify areas requiring strategic intervention.
• Offer stakeholders an intuitive tool for real-time data-driven decision-making.

Business Needs:

• Understand how transit modes are recovering post-COVID.
• Support resource allocation and planning based on ridership and traffic patterns.
• Engage stakeholders with clear, accessible data visualizations.

Discovery & Presentation Process:

1. ELT: Extracted raw data from sources, loaded it into a centralized repository, and transformed it to ensure consistency and usability for analysis.
2. Analysis: Identified key trends, outliers, and correlations across transit modes.
3. Visualization Design: Developed customized, user-friendly charts, including comparisons of ridership and traffic metrics to pre-pandemic baselines.
4. Presentation: Created interactive features such as slicers and filters to allow stakeholders to explore data by mode, region, or timeframe, ensuring clear and actionable insights.