transit_dashboard

Tech Stack

1. PostgreSQL
2. Python
3. Looker Studio

Dashboard Views & Grain

1. Daily Service Health
2. Hourly Coverage & Wait Times - all-time, by day of the week
3. Driver Performance
4. Rider Type Equity
5. Usage & Efficiency - Vehicle Hours, Trips per Vehicle-Hour, Occupancy

Metrics

1. Completion Rate
2. Occupancy Rate
3. Quoted Wait Time (Request time vs Quoted pickup time)
4. Average Wait Time (Median, 85th Percentile)
5. Max Wait Time
6. On-Time Status (+/- 5 min) & Performance
7. Vehicle Utilization Rate (hours)
8. Trips per Vehicle-Hour -> Trip Capacity Utilization Rate
9. Trips per Day
10. Weekly Demand
11. Peak Vehicles
12. Total Cost (based on charged by vehicle-hour) and Cost per Trip