TheLook E-Commerce Analytics & BI●
Production-Grade Analytics Pipeline — Python · SQL · Power BI
Transformed 125K orders, 100K users, and $10.76M in raw Google BigQuery data into an enterprise MySQL Kimball star schema, 9 SQL deep-dive query scripts, and a 2-page dark-mode Power BI executive dashboard.
Identified that Outerwear & Sweaters yielded the highest profit margin ($1.8M+) but suffered an 11.2% return rate, while Organic/Search acquisition channels produced 2.4x higher CLV compared to Social campaigns.
- —Ingested & profiled 7 raw BigQuery tables using custom Python data engineering scripts
- —Architected Kimball-style MySQL Star Schema (1 Fact table, 3 Dimension tables)
- —Executed 9 SQL analytics deep dives (Cohort retention, RFM segmentation, AOV, Margin analysis)






