TheLook Ecommerce Return Analysis

An end-to-end batch pipeline on GCP to explore product return behavior using the TheLook Ecommerce dataset. The project analyzes how returns evolve over time, which products quietly drive revenue loss, and what kind of customer patterns sit behind it. Built with Bruin for ingestion, orchestration, and SQL transformations, BigQuery as the warehouse, GCS as the storage layer, Terraform for provisioning, and Looker Studio for visualization. The pipeline flow goes from BigQuery public dataset to GCS to BigQuery (raw → staging → marts) and finally to a Looker dashboard.