MTA Ridership Recovery Trend
About this project
As a participant at Maven Challenge, I were tasked with playing the role of the Metropolitan Transportation Authority’s (MTA), a public-benefit corporation responsible for public transportation in the state of New York serving 12 counties in southeastern New York, along with two counties in southwestern Connecticut under contract to the Connecticut Department of Transportation (CDOT). The MTA is the largest transportation network in North America.
This dataset provides systemwide ridership and traffic estimates for subways (including the Staten Island Railway), buses, Long Island Rail Road, Metro-North Railroad, Access-A-Ride, and Bridges and Tunnels, beginning 3/1/2020 (4/1/2020 for LIRR and Metro-North), and provides a percentage comparison against a comparable pre-pandemic date.
This dashboard analyzes ridership trends beginning March 1st, 2020, focusing on seven different services of MTA. It provides insights on the behavior of traffic participants during and after COVID-19, also includes a percentage comparison against pre-pandemic figures.
Data Analysis and Insights
1. Dataset
I transform raw data using pivot table to easily get data for analysis
AS IS
TO BE
FINAL DATA MODEL
2. Insights:
- In total, Transportation volume decreased 41% during COVID-19
- Subways and Buses are the most used transportation during the period
- 2020, the start of COVID-19, is the year experienced the largest decrease in the transportation volume. The ridership increased gradually from 2021 to 2024 but still did not fully recovered until now
- Bridges and Tunnels, Access-A-Ride are 2 least impacted transportations. It’s probably because people tend to use personal transportation instead of public one.
- Access-A-Ride, Bridges And Tunnels have the highest speed of recovery. In 2023, the estimated ridership for those is nearly same compared with post pandemic and even higher in 2024.
- However, Buses and Subways, which have the highest transportation volume, recovered slowly after COVID-19. Until now, they have just reached around 70% the pre-pandemic volume.