This repository explores the Olist Brazilian E-Commerce Dataset, containing 100,000+ orders from 2016–2018 across multiple marketplaces. We uncover insights on customer behavior, sales trends, top products, and regional performance to reveal the heartbeat of online shopping in Brazil.
For this analysis, we focused on five key tables from the original dataset:
- Orders – Customer orders with timestamps and status.
- Order Items – Detailed products within each order.
- Products – Product metadata, including category and price.
- Customers – Customer locations and profiles.
- Sellers – Seller locations and performance metrics.
Full dataset available on Kaggle.
We explored trends and insights across several dimensions:
-
Top Selling Regions
- Goal: Identify regions driving the highest revenue.
- Method: Aggregate and rank sales by state.
- Impact: Helps target marketing and logistics to high-performing areas.
-
Top Product Categories by Revenue
- Goal: Discover which categories generate the most revenue.
- Method: Sum total sales per category and rank them.
- Impact: Guides promotions and inventory decisions toward profitable categories.
-
Top 5 Products by Revenue
- Goal: Spotlight the five highest-earning products.
- Method: Rank products by total revenue.
- Impact: Understand consumer favorites and market trends.
-
Monthly Order Volume Trends
- Goal: Analyze order fluctuations to identify peak periods.
- Method: Group orders by month and year.
- Impact: Supports accurate forecasting and optimizes marketing campaigns.
Understanding Brazilian e-commerce trends helps sellers, marketers, and analysts:
- Identify high-performing products and regions
- Optimize sales strategies
- Predict seasonal demand
- Gain actionable insights from real-world data