Project Files
Explore the full project and insights
Read Full NYC Taxi Dashboard Report (PDF) →
Project Overview
This dashboard analyzes transportation and weather activity across New York City in January 2015. Built in Power BI, it features 12 pages exploring taxi usage, flight delays, trip duration, and temperature patterns through interactive visuals.
Dataset Sources
-
NYC Taxi Trip Data (Green, Yellow, FHV – Jan 2015)
Yellow Taxi Trips – Jan 2015
Green Taxi Trips – Jan 2015
FHV Trip Data – Jan 2015 -
NYC Weather Data – Hourly and Daily (2015)
NYC Environment & Health Climate Data -
U.S. Domestic Flights (2015)
BTS – U.S. Airline Traffic Data 2015
Kaggle – Flight Delays & Cancellations 2015
Key Insights & Findings
Global Totals (January 2015 NYC Analysis):
- Total Yellow Taxi Trips: 1.5 Million
- Total FHV Trips: 2.7 Million
- Total Flights: 1.049 Million
- Max Fare (Yellow Taxi): $4,008
- Max Trip Distance: 15.42 Miles
- Max Trip Duration: 549,000 Minutes
- Manhattan was the most active borough for Yellow and Green Taxi pickups.
- Midtown Center had the highest number of FHV pickups (62,069).
- Friday saw the highest taxi demand and also the most flights (80,955).
- Monday recorded the highest average fare at $38 for Green/Yellow Taxis.
- Southwest Airlines experienced the most delays among top 5 airlines.
- Dallas/Fort Worth was the airport with the highest flight cancellations (3,578).
- At 5 AM, Yellow Taxi fares peaked at $15.7 on average.
- Staten Island had the lowest taxi demand across all services.
- FHV and Green Taxi weekend demands showed a strong positive correlation.
- Temperature drop was significant in January, with a low of -16.5°C and a "feels like" low of -27.1°C.
Dashboard Pages
1. Green Taxi Travel
- Astoria: most common destination (44,530 trips)
- Average Fare: $11.77
- Week 5 had highest weekday demand
- Manhattan had 92.98% of usage (11.6M trips)
- Highest fare: Murray Hill ($4,008)
- Peak avg fare hour: 5 AM ($15.7)
- Top zone: Midtown Center (62,069 pickups)
- Data lacks fare and drop-off info
- Friday’s busiest pickup borough: Manhattan
- Least demand: Staten Island (415 trips)
- Monday had highest average fare ($38)
- Manhattan had longest total duration (150M mins)
- Min temp: -16.5°C, Feels-like: -27.1°C
- Max temp: 9°C | Daily avg: 13.57°C
- Temp variance highest at 2 AM (4°C)
- Southwest Airlines: most delays (42K)
- Top cancelled: Dallas/Fort Worth (3.6K)
- Monday had most cancellations (9.8K)
- Max Fare: $4,008 | Max Trip Distance: 15.42M
- Max Trip Duration: 549K mins
- Flights: 1.049M | Min Delay: -82 mins
- Yellow Taxi Fare Avg: $11.90 | Max: $4,008
- Temp Avg: 13.57°C | Max: 31.1°C
- Flight Delay Total: 7.65M | Cancellation: 1.04M
- Saturday demand higher than Sunday
- Week 2 saw widest Sat/Sun difference
- FHV and Green Taxi: positively correlated
- Arrival and departure delays: positively correlated
- Delay counts tracked daily across Jan 1–31
- Flight delays increase under bad weather
- Filters for airline, month, and weather conditions
- Friday: peak day for taxi and flight demand
- Manhattan had highest taxi use; EWR the lowest
- Thursday: 10.8% of flights in cloudy weather
- Taxi demand surges on weekends and in central boroughs
- Weather influences fare and trip durations
- Flight delays are consistent across major carriers
- Data transformation in Power BI (DAX, measures)
- Multi-page dashboard design
- Combining multiple data sources (Taxi, Flights, Weather)
- Insight storytelling through charts
2. Yellow Taxi Travel
3. For-Hire Vehicle Travel (FHV)
4. NYC Taxi Overview
5. NYC Weather Overview
6. NYC Flights Info
7. Data Anomaly Centre
8. Summary Statistics
9. Comparison Centre
10. Analytics Dashboard
11. Hypothesis Centre
12. My Story
Observations
Skills Demonstrated
© 2025 | Project by Kalyan Dangi | Data Source: NYC Open Data & U.S. BTS