Citi Bike Analytics Pipeline
End-to-end data pipeline and analytics on NYC Citi Bike trips
This project implements an end-to-end analytics pipeline for New York City’s Citi Bike trip data. Using modern data engineering tools, I built batch workflows to ingest raw trip records, store them in a cloud data lake and warehouse, and transform them into analysis-ready tables. On top of this curated data model, I developed visualizations that reveal ridership patterns, usage by bike type, seasonality, and station-level demand, enabling data-driven insights into how the Citi Bike system is used over time.
View Project on GitHub
Explore the full pipeline, including ingestion, transformation, and analytics code, in the GitHub repository.