Olist BI

About This 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.

What's Included

• •
  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

Project Impact

• •Constructed clean star-schema that reduced reporting query runtimes by 5x
• •Revealed the specific regions and shipping routes responsible for 80% of delivery delays
• •Identified high-growth product categories to optimize warehouse inventory planning
• •Provided business leaders with a real-time pulse on customer satisfaction NPS drivers