Superstore Executive Performance Dashboard
Jan 2018 – Dec 2021 · 9,994 line items · 793 customers · all figures in USD
From
To
Region
All Regions
Category
All Categories
Segment
All Segments
Ship Mode
All Ship Modes
Reset Filters
Executive Summary
Sales Are Growing, But Profit Isn't Keeping Pace Every Month
Monthly sales (bars) vs. profit (line), 2018–2021. Watch for months where the line dips while bars hold up — margin pressure.
Where the Revenue Comes From
Sales by Category. Click a bar to drill into Sub-Categories.
Click a bar to drill down · click again to go back up
These Sub-Categories Are Sold at a Loss
Profit by Sub-Category, sorted lowest to highest. Bars left of zero are money-losing lines.
Heavier Discounting Tracks Closely With Losses
Each dot is a line item: discount rate vs. profit. Red dots are loss-making.
Sales by Region
Click a bar to filter the whole dashboard to that region.
Sales
Profit
Margin Varies Sharply by Region
Profit margin % by region — the weakest region is flagged even if its sales look fine.
Consumer Segment Drives the Business
Sales by customer segment. Click a slice to filter.
Revenue Is Concentrated in a Small Customer Base
Top 10 customers by sales.
Standard Shipping Dominates Order Volume
Sales by ship mode — relevant to logistics cost negotiations.
Top 10 States by Sales
Where geographic investment could pay off next.
States
Cities
Discounting Doesn't Reliably Buy Extra Volume
Monthly order count (bars) vs. average discount rate (line).
Loss-Making Orders, Isolated
Every line item with negative profit — the worst offenders by dollar loss.
Order ID
Date
Category
Sub-Category
Region
Discount
Sales
Profit