What the data says
Three findings
Every number below comes from Olist's public order data joined with IBGE population figures.
What to do
Three recommendations, in order
Start with the cheapest fix, then invest where the gap is largest.
How this was done
Method and sources
Data
- Olist's public e-commerce dataset (github.com/olist): delivered orders, reviews, sellers and freight.
- IBGE 2017 population estimates and 2017 GDP by state.
- IBGE state boundaries.
- Photos (Wikimedia Commons): Lauro Moura, CC BY-SA 2.0; Sérgio Valle Duarte, CC BY 3.0; Themium, CC0; Meanwell Packaging, CC BY 2.0; Meanwell Packaging, CC BY 2.0; Nathalia Verony, CC BY 2.0.
Definitions
- Delivery days: purchase to delivery at the customer's door.
- Late: delivered after the date promised at checkout.
- Reach: delivered orders per 100,000 residents.
- Hub coverage: straight-line distance between state capitals, weighted by orders.
Limits
- Income matters too: the Northeast's GDP per person is about 40% of the Southeast's, so logistics explains part of the gap, not all of it.
- Data covers 2016–2018; the impact figures are estimates to test, not promises.
- This is a portfolio exercise; Olist did not commission it.