Olist E-Commerce Analytics Pipeline

This cloud-native ELT pipeline transforms 100k+ Brazilian e-commerce orders into actionable logistics and customer satisfaction insights by migrating raw data from Kaggle into Google BigQuery using a multi-layered Medallion architecture (Raw → Staging → Mart). Powered by Bruin, the project utilizes Python-to-Cloud Ingestion for automated downloads, Native SQL Modeling for scalable transformations, and Automated Data Quality Checks (e.g., unique, not_null, positive_value) to ensure end-to-end data integrity for its interactive visualization dashboard.