Built an end-to-end GCP analytics solution for e-commerce order fulfilment and customer experience.
The project uses BigQuery public data and Cloud Storage ingestion, with Dataform for transformation, data quality assertions, dependency management, version-controlled production workflows, and scheduled execution.
Business marts power a Looker Studio dashboard analyzing order status, cancellations, returns, fulfilment time, product risk, customer behavior, and performance against service targets.
Google Data Studio Dashboard:
