MTA Ridership Recovery Trend

About this project

This dashboard analyzes ridership trends beginning March 1st, 2020, focusing on seven different services of the Metropolitan Transportation Authority (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 undefined TO BE2. 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.