Sales Overview
Superstore dataset · FY 2021–2024 · All figures in USD
Updated: Jan 2025
Total Revenue
$2,300K
▲ 8.4% vs prior year
Total Orders
9,994
▲ 5.2% vs prior year
Total Profit
$286K
▲ 11.7% vs prior year
Avg. Discount
15.6%
▼ 1.2pp vs prior year
Monthly Revenue TrendFY 2021–2024
Revenue by CategoryDonut
Revenue by RegionAll Regions
Top Sub-CategoriesBy revenue
Category PerformanceFiltered
| Category | Revenue | Profit | Orders | Margin | YoY | Status |
|---|
Profitability Analysis
Margin deep-dive · Discount impact · Sub-category ranking
Updated: Jan 2025
Overall Margin
12.5%
▲ 0.9pp vs prior year
Tech Margin
17.4%
▲ 1.2pp
Furniture Margin
2.5%
▼ 0.3pp
Office Supplies
17.0%
▲ 0.7pp
⚠ Key Finding — Discount Leakage
Items discounted over 20% average –2.3% margin vs +18.4% for undiscounted items. Eliminating deep discounts on Furniture alone could recover ~$45K in annual profit.
Margin % by Discount BandBar
Revenue vs Profit by CategoryGrouped Bar
Sub-Category Profit RankingAll categories
Profit Trend by CategoryAnnual
Sub-Category Profitability Detail
| Sub-Category | Category | Revenue | Profit | Margin % | Avg Discount | Rank |
|---|
Customer Segments
Consumer · Corporate · Home Office · Retention analysis
Updated: Jan 2025
Consumer
Customers410
Revenue$1,162K
Avg Order$214
Margin11.6%
Corporate
Customers236
Revenue$706K
Avg Order$231
Margin13.2%
Home Office
Customers147
Revenue$429K
Avg Order$228
Margin14.1%
Revenue by SegmentDonut
Segment Revenue Over TimeAnnual
💡 Opportunity — Home Office Margin
Home Office has the highest margin (14.1%) but the smallest customer base. Targeted acquisition in this segment offers the best margin-per-dollar growth opportunity.
Customer Retention BandsOrder frequency
Avg Order Value by Segment & CategoryGrouped
Top 10 Customers by Lifetime Value
| Customer | Segment | Region | Orders | LTV | Profit | Tier |
|---|
Trend Forecasting
Rolling averages · Seasonality · 2025 projection
Updated: Jan 2025
2024 Revenue
$628K
▲ 8.4% vs 2023
2025 Forecast
$681K
▲ 8.4% projected
Peak Month
December
+38% above avg
Seasonality Index
1.38×
Dec vs Jan spread
📈 Forecast Methodology
2025 projection uses a 3-year rolling CAGR of 8.4% applied to 2024 actuals, with monthly seasonality weights from the 2021–2024 average monthly distribution. Q4 consistently accounts for ~34% of annual revenue.
Revenue Trend with 3-Month Rolling Average & 2025 Forecast2021–2025P
Monthly Seasonality IndexAvg 2021–2024
Annual Revenue & YoY GrowthBar + Line
2025 Monthly Forecast vs 2024 Actuals
| Month | 2023 Actual | 2024 Actual | 2025 Forecast | MoM Change | Seasonality |
|---|
Regional Analysis
West · East · Central · South · State-level performance
Updated: Jan 2025
West Revenue
$725K
▲ 31.5% share
East Revenue
$678K
▲ 29.5% share
Central Revenue
$501K
▲ 21.8% share
South Revenue
$396K
▼ Lowest margin
West
Revenue$725K
Profit$89K
Margin12.3%
Customers312
Rev/Customer$2,323
East
Revenue$678K
Profit$84K
Margin12.4%
Customers298
Rev/Customer$2,275
Central
Revenue$501K
Profit$62K
Margin12.4%
Customers267
Rev/Customer$1,876
South
Revenue$396K
Profit$50K
Margin12.6%
Customers290
Rev/Customer$1,366
Regional Revenue vs ProfitGrouped Bar
Regional Revenue Over TimeLine
📍 Regional Insight
West leads in revenue per customer ($2,323) vs South ($1,366) — a $957 gap. Applying West's product mix strategy to the South market represents a ~$278K revenue expansion opportunity.
Top States by Revenue
| State | Region | Revenue | Profit | Orders | Margin |
|---|