Data Engineering & Analytics Completed
Olist Brazilian E-Commerce: SQL Analytics & OLAP Modeling
100K+Orders Modeled
50SQL Questions
5Phases Completed
DockerMySQL 8.0
An end-to-end SQL analytics and dimensional modeling project analyzing over 100,000 real customer orders from the Olist Brazilian E-Commerce dataset. Progresses through catalog exploration, data quality auditing, business KPIs with CTEs, window rankings, and an analytical star schema.
5-Phase ArchitectureDocker : MySQL 8.0
01ExplorationCatalog & Tables
→02Data QualityHygiene & Audits
→03Business KPIsAOV & SLA Latency
→04AnalyticsWindow Functions
→05Star SchemaFacts & Dimensions
Containerized Environment: MySQL 8.0 running inside Docker on port 3307 for isolated local execution.
Data Quality Audits: Verified primary key uniqueness, temporal anomalies, and handled 611 missing product categories to maintain financial accuracy.
Business KPIs & Windowing: Modular CTEs computing AOV, logistics latency, SLA compliance, and multi-period rankings (
RANK, DENSE_RANK).OLAP Star Schema: Central
fact_sales (110k items, $13.59M revenue) with 0 orphaned foreign keys across customer, product, seller, and date dimensions.