Tableau Dashboard

About this project

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

  1. Maximum recovery of 88% has reached till 2024.

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

Additional project images

Discussion and feedback(0 comments)
2000 characters remaining
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.