NYC Yellow Taxi Analytics Platform
August 2025 – December 2025
Built full-stack analytics platform ingesting 20M+ NYC taxi trip records from January to August 2025 into PostgreSQL, implementing five materialized views and eleven strategic indexes to enable interactive analysis of fare trends, peak demand patterns, and vendor performance.