🏪 Olist Marketplace

Overview

Public dataset from the Brazilian Olist marketplace (Kaggle, 2016–2018): ~96K orders joined across 8 relational tables.

Data Structure

Table	What It Captures
Orders	Order lifecycle: created, approved, delivered, estimated dates
Order Items	Products per order: price, freight, seller
Sellers	Seller metadata: location, zip code
Customers	Customer metadata: location, unique ID
Reviews	Customer review scores (1–5) and comments
Payments	Payment method, installments, value
Products	Product category, dimensions, photos
Geolocation	Lat/long for zip codes

Causal Reasoning Model

Three nested paths converge to explain bad customer reviews (score ≤ 2):

1. Logistics Delays: late shipment → delivery past estimate → customer frustration 2. Product Quality Gaps: category mismatch, missing photos, description issues 3. Payment Friction: high installment count, payment method issues

Sample Questions

• "Why did this customer leave a bad review?"
• "How did logistics delays contribute to low satisfaction?"
• "What product quality factors drove 1-star reviews?"