Brazilian E-Commerce Report
📊 Power BI dashboard analyzing the Brazilian E-commerce dataset from Olist
This dataset contains ~100K real orders (2016–2018), covering the full e-commerce journey — from purchase to delivery and customer reviews (Kaggle)
👉 You can explore the interactive dashboard here:
https://lnkd.in/dbrJJdYT
🔍 Key Insights:
• Revenue is highly concentrated in São Paulo (~50%)
→ Strong performance, but also a risk due to regional dependency
• Average Order Value (AOV ≈ 142)
→ Customers are mostly making single-item purchases
→ Clear opportunity for bundling & cross-selling
• Logistics is likely the biggest driver of customer satisfaction
→ Delivery delays directly impact review scores
→ Operations = critical growth lever
• Payment behavior matters
→ Boleto orders may not fully convert into revenue
→ Important to track real conversion, not just orders
• Rapid growth observed in 2018
→ Indicates strong market fit, but sustainability needs validation
💡 Business Recommendations:
Expand into Tier 2 regions to reduce revenue concentration
Improve delivery performance to increase customer satisfaction
Increase AOV through product recommendations & bundles
Optimize payment methods to improve conversion
🛠️ Tools:
Power BI
DAX
Data Modeling
Would love your feedback 🙌