AIM This project aims to visualize post-pandemic ridership recovery trends across various MTA services, providing actionable insights into recovery patterns compared to pre-pandemic levels.
DATA PREPARATION The dataset includes daily ridership and percentage recovery data for subways, buses, commuter railroads (LIRR and Metro-North), Access-A-Ride services, and Bridges & Tunnels traffic from year 2020 to 2024.
To analyze the post pandemic ridership, filtered out the dates when there was pandemic.
Calculated the estimated pre-pandemic ridership used the formula: Comparable Pre-Pandemic AAR Trips = (Total daily Ridership*100)/Recovery%
KEY INSIGHTS
2)Maximum daily ridership was acorss Subways, but it ranks 4th in Recovery rate
3)Access-A-Ride is performing best in terms of recovery , which reached 100 and more from last 2 years.
4)Staten Island Railway is worst in recovery as it has not crossed avg of 50% in any of the year.
Tableau Dashboard Link: https://public.tableau.com/shared/ZH4BRCYQF?:display_count=n&:origin=viz_share_link