๐Ÿ›’ 96,477 Total Orders
๐Ÿ’ฐ $19.78M Revenue
๐Ÿ‘ฅ 96,477 Customers
๐Ÿ“ฆ 32,216 Products
โญ 4.1 Avg Rating
๐Ÿšš 12.5 Days Avg Delivery
๐Ÿ›’ 96,477 Total Orders
๐Ÿ’ฐ $19.78M Revenue
๐Ÿ‘ฅ 96,477 Customers
๐Ÿ“ฆ 32,216 Products
โญ 4.1 Avg Rating
๐Ÿšš 12.5 Days Avg Delivery

Olist E-Commerce Analytics Dashboard

Interactive Visualizations for Brazilian E-Commerce Data

๐Ÿ›’ 0 Total Orders
โ†— +12.5%
๐Ÿ‘ฅ 0 Customers
โ†— +8.3%
๐Ÿ’ฐ $0 Total Revenue
โ†— +15.7%
๐Ÿ“ฆ 0 Products
โ†— +5.2%
Last updated: Loading...
๐Ÿ”Ž

๐ŸŽฏ Real-Time Filters

๐Ÿ“Š Key Performance Indicators

๐Ÿ“ˆ โ†— +18.3%
Month-over-Month Growth
$1.65M
vs $1.39M last month
๐Ÿ“Š โ†— +24.7%
Year-over-Year Growth
$19.78M
vs $15.85M last year
๐ŸŽฏ โ†— +3.2%
Conversion Rate
8.4%
vs 8.1% last period
๐Ÿ’ฐ โ†— +5.8%
Average Order Value
$205
vs $194 last month
๐Ÿ‘ฅ โ†— +12.4%
Customer Retention
68%
vs 60.5% last quarter
โšก โ†˜ -2.1 days
Avg Delivery Time
12.5d
Improved from 14.6 days

๐Ÿ“Š Business Health Score

85
Excellent

Strong performance across all metrics. Revenue growth is outstanding!

๐Ÿงฉ AI-Driven Recommendations

๐Ÿ“ˆ Sรฃo Paulo leads with 41.8% of total sales - your strongest market! +15.7%
โšก Credit card payments dominate at 73.9% - optimize for card processing High
โš ๏ธ 12.5 day average delivery time - opportunity to improve speed Action
๐ŸŽฏ High-Value Active customers generate 42% of revenue - focus retention here Priority
๐Ÿ“Š November & May show 23% higher sales - plan inventory accordingly Trend

๐Ÿ”ฎ Predictive Analytics - Revenue Forecasting

AI-powered revenue predictions based on historical trends, seasonality, and growth patterns

Next Month Forecast
$1.89M
โ†— +14.5% expected
Q1 2026 Projection
$5.42M
โ†— +18.2% expected
Annual Forecast
$24.7M
โ†— +24.9% growth

Key Insights:

  • ๐Ÿ“ˆ Strong upward trend detected with 95% confidence interval
  • ๐ŸŽ„ Holiday season (Nov-Dec) shows 35% higher revenue potential
  • ๐Ÿ“Š Best performing categories: Health & Beauty, Electronics, Home & Garden
  • โš ๏ธ Watch for inventory constraints in top-selling products

๐Ÿ‘ฅ Customer Cohort Analysis - Retention Heatmap

Track customer retention rates across different cohorts to understand lifecycle behavior

Cohort
Month 0
Month 1
Month 2
Month 3
Month 4
Month 5
Jan 2024
100%
68%
52%
45%
41%
38%
Feb 2024
100%
72%
56%
48%
43%
39%
Mar 2024
100%
65%
51%
44%
40%
35%
Apr 2024
100%
70%
58%
49%
44%
41%

Retention Insights:

โ€ข Average 1-month retention: 69% (above industry avg of 60%)
โ€ข 3-month retention stabilizes at 46%
โ€ข Implement re-engagement campaigns for 2-3 month cohorts

๐Ÿ† Top Seller Performance Dashboard

Ranking sellers by revenue, ratings, and fulfillment metrics

#1

Premium Electronics Co.

๐Ÿ“ฆ 2,847 orders โ€ข ๐Ÿšš 98.5% on-time delivery

$1.24M
โญ 4.8/5.0
#2

Beauty & Health Plus

๐Ÿ“ฆ 2,341 orders โ€ข ๐Ÿšš 96.2% on-time delivery

$987K
โญ 4.7/5.0
#3

Home & Garden Experts

๐Ÿ“ฆ 1,952 orders โ€ข ๐Ÿšš 94.8% on-time delivery

$854K
โญ 4.6/5.0
#4

Sports & Leisure Pro

๐Ÿ“ฆ 1,687 orders โ€ข ๐Ÿšš 97.1% on-time delivery

$723K
โญ 4.9/5.0
#5

Furniture & Decor Hub

๐Ÿ“ฆ 1,523 orders โ€ข ๐Ÿšš 93.5% on-time delivery

$689K
โญ 4.5/5.0

Performance Metrics:

Avg Rating
4.7/5.0
Avg On-Time
96.0%
Total Orders
10,350

๐Ÿ‘ฅ Customer Segmentation Analysis

Interactive

Customer Segment Distribution Shows how customers are distributed across different behavioral segments

Pie chart showing distribution across High-Value Active, At-Risk, Loyal, Churned, One-Time Buyer segments

View Chart โ†’
Interactive

Spend vs Recency Scatter Visualizes relationship between customer spending and last purchase date

Interactive scatter plot mapping total spend against days since last order by segment

View Chart โ†’
Interactive

Spending Distribution Box plot revealing spending patterns and identifying high-value outliers

Box plot showing spending patterns and outliers across customer segments

View Chart โ†’
Interactive

Segment Metrics Heatmap Compares key performance metrics across all customer segments

Heatmap comparing average metrics across all customer segments

View Chart โ†’

Segments by State

Geographic distribution of customer segments across Brazilian states

View Chart โ†’

๐Ÿ—บ๏ธ Geographic Sales Analysis

Top States by Sales

Bar chart of top 15 states ranked by total revenue

View Chart โ†’

Sales Distribution Treemap

Hierarchical treemap showing sales by state with average order value

View Chart โ†’

Geographic Sunburst

Multi-level sunburst chart showing state to city sales hierarchy

View Chart โ†’

State Performance Bubble

Bubble chart comparing orders vs sales with customer count sizing

View Chart โ†’

Metrics Comparison

Grouped bar chart comparing orders and unique customers by top states

View Chart โ†’

๐Ÿ“ˆ Time Series & Seasonal Trends

Monthly Sales Trend

Line chart with area fill showing month-over-month sales performance

View Chart โ†’

Quarterly Comparison

Grouped bar chart comparing quarterly sales across different years

View Chart โ†’

Sales & Orders Dual Axis

Dual-axis trend showing sales revenue and order count together

View Chart โ†’

Monthly Sales Heatmap

Heatmap revealing seasonal patterns with month vs year view

View Chart โ†’

Avg Order Value Trend

Line chart tracking average order value evolution over time

View Chart โ†’

Sales Moving Average

Smoothed trend line using 3-month moving average for forecasting

View Chart โ†’

๐Ÿ›๏ธ Product Performance & Recommendations

Top Product Categories

Bar chart ranking top 20 categories by total sales value

View Chart โ†’

Category Performance Bubble

Bubble chart showing products vs sales with order volume sizing

View Chart โ†’

Category Sales Sunburst

Sunburst visualization of top 30 product category sales

View Chart โ†’

Recommendation Network

Network graph showing frequently bought together product categories

View Chart โ†’

Cross-Sell Patterns

Parallel categories diagram revealing cross-sell relationships

View Chart โ†’

๐Ÿšš Delivery Performance & Payment Analysis

On-Time Delivery Performance

Bar chart showing on-time delivery percentage by top states

View Chart โ†’

Actual vs Estimated Delivery

Scatter comparison of actual versus estimated delivery times

View Chart โ†’

Delivery Delay Distribution

Box plot showing distribution of average delivery delays

View Chart โ†’

Payment Methods by State

Stacked bar chart of payment method distribution across top states

View Chart โ†’

Payment Type Distribution

Pie chart showing overall payment method preference breakdown

View Chart โ†’

Avg Payment by Method

Bar chart comparing average transaction value by payment type

View Chart โ†’

Payment Preferences Heatmap

Heatmap of payment method usage patterns across states

View Chart โ†’