Chicago Taxi Trips vs Weather

I wanted a reproducible way to analyze how weather conditions affect taxi trip activity, using a real pipeline rather than an isolated notebook.

An end-to-end analytics workflow on Google Cloud, including ingestion, infrastructure, transformations, orchestration, testing, and BI output.

• Terraform provisions the GCP resources and baseline infrastructure.
• Cloud Functions and scheduled jobs handle ingestion and refresh workflows.
• BigQuery stores raw and modeled data, with dbt managing transformations.
• Looker Studio consumes the final models for stakeholder-friendly reporting.

• Connected ingestion, storage, modeling, and reporting in one reproducible system.
• Kept the project close to real production patterns with orchestration and CI/CD.

Add stronger monitoring and freshness checks around ingestion reliability and scheduled pipeline runs.

• Google Cloud
• BigQuery
• dbt
• Terraform
• Cloud Functions
• Looker Studio
• GitHub Actions