This project presents a comprehensive sales and performance dashboard for the Brazilian e-commerce platform Olist, created using Tableau Public. The goal is to provide actionable insights on orders, revenue, delivery trends, customer satisfaction, and product profitability.
| Tool | Purpose |
|---|---|
| Tableau | Interactive data visualization and dashboard creation |
| Excel | Initial data cleaning and transformation |
Olist, an e-commerce marketplace in Brazil, wants to:
- Understand customer behavior and product profitability
- Track revenue trends across time
- Evaluate the impact of delivery time and customer reviews
- Compare weekday vs weekend sales
- Identify top-performing categories
- Total Orders: 96.48K
- Total Revenue: 15.42M
- Total Sellers: 2,970
- Profit: 2.20M
- Average Delivery Day (Pet Shop): 11.31 days
- Top 5 Products by Profit: Cama Mesa Banho, Moveis Decoracao, etc.
- Monthly Revenue Trend: Rising sharply from 2017 to mid-2018
- Order Count by Rating (5 stars) and Credit Card Use
- Average Payment vs. Price in São Paulo
- Weekday vs Weekend Revenue (Weekdays dominate with ~75%)
- Star Rating vs Avg. Shipping Days: Better ratings linked with faster delivery
- 5-star rated orders had the highest volume and were mostly paid via credit cards.
- Revenue peaked in late 2017 and remained consistent throughout 2018.
- Customers tend to shop more on weekdays, with 77% revenue contribution.
- Faster shipping results in better customer reviews, improving retention and loyalty.
- Top 5 profitable categories significantly outperform the rest in margin contribution.
The dashboard helps Olist understand critical business metrics at a glance. With key visual elements and trend analysis, this solution supports:
- Inventory planning
- Delivery logistics optimization
- Customer satisfaction improvement
- Profit-driven product targeting
"Data tells a story — this dashboard helps decision-makers read it clearly."
- 📧 Email: banotheaman@gmail.com
- 💼 LinkedIn: Aman Banothe