Road Map of Project

NYC Transportation Analytics Platform

Capstone Data Engineering & Analytics Project

Executive Summary

This capstone project builds a comprehensive transportation analytics platform using official NYC Taxi and Limousine Commission (TLC) data to analyze transportation patterns, pricing dynamics, and operational efficiency across New York City's diverse transportation ecosystem. The project demonstrates end-to-end data engineering skills, from raw data acquisition to business intelligence delivery.

Project Scope: Design and implement a modern data warehouse solution analyzing 23+ million real transportation records spanning traditional taxis and ride-sharing services, providing actionable insights for urban mobility optimization.

Project Objectives

Primary Goals

  1. Data Engineering Excellence: Build a scalable, cloud-based data warehouse using modern ELT principles
  2. Business Intelligence: Deliver comprehensive analytics on NYC transportation patterns and trends
  3. Technical Proficiency: Demonstrate expertise in cloud data platforms, transformation tools, and visualization
  4. Real-world Impact: Generate actionable insights for transportation optimization and urban planning

Learning Outcomes