About The Project
An executive business intelligence project that translates millions of records from the Olist Brazilian E-Commerce dataset into executive dashboards. By constructing robust SQL data transformations and building a relational star-schema, the project delivers 5 high-impact reporting modules tracking sales revenue, delivery logistics, seller performance, customer satisfaction, and product category trends.
Key Features & Architecture
Relational Star-Schema
Structured and denormalized SQL databases optimized for BI reporting
Star-Schema SQL Transformations
Custom window functions, cohort scripts, and metric queries
Power BI Executive Suite
Interactive tabs for sales, delivery speed, and customer lifetime value
Cohort Retention Matrix
Visual charts tracing repeat buying patterns month-over-month
Seller Performance Audits
Highlights top logistics bottlenecks in delivery lanes