Superstore Sales & Profit Performance Dashboard (2026)

Audience: VP of Sales / Regional Manager | Data Source: sample_-_superstore.xls

2026 Total Sales

$745,568

▲ 21.4% (vs 2025)

2026 Net Profit

$95,926

▲ 16.0% (vs 2025)

2026 Profit Margin

12.9%

▼ 0.6 pp (vs 2025: 13.5%)

Monthly Sales & Profit Performance

Line: Sales (Left Axis) | Columns: Profit (Right Axis)

Regional Performance & Efficiency

Bar saturation encodes profit margin (Click to filter)

West

$258,241

East

$216,567

Central

$147,854

South

$122,906

Category Revenue Composition

Size encodes Sales | Hover for profit overview

Technology

$272,419

36.5% Share | Highest Margin

Office Supplies

$253,835

34.0% Share

Furniture

$219,313

29.4% Share

📐 Tableau Dashboard Design Specification

Project Name	Superstore Sales & Profit Performance Dashboard
Target Audience	VP of Sales, Regional Managers, Operational Leaders
Time Budget	1 - 3 Minutes (Executive scan & light analytical diagnostic capabilities)
Dimensions	1400 × 900 px (Fixed size for high visual density and strict padding control)
Page Structure	Single Page (Overview first, drill-down details surfaced via tooltips & actions)

1. Business Questions to Sheet Mapping

Derived from the Superstore Orders dataset schema to answer critical performance queries:

Priority	Business Question	Target Visual / Chart	Field Encodings (X, Y, Color, Size)	Dashboard Zone
P1 (Critical)	Are we on track for Sales/Profit goals compared to last year?	BANs (Big-Ass Numbers)	Values: `SUM(Sales CY)`, `SUM(Profit CY)`; Color: YoY indicators	Header KPI Zone
P1 (Critical)	What are the monthly seasonal sales and profitability trends?	Dual-Axis Line & Column	X: `Month(Order Date)`, Y1: `SUM(Sales)` (Line), Y2: `SUM(Profit)` (Bar)	Primary Left Column (60%)
P2 (Monitoring)	Which regions dominate sales and yield the best margin efficiency?	Sorted Horizontal Bars	Row: `Region`, Column: `SUM(Sales)`, Color: `Profit Margin`	Upper Right Panel (40%)
P2 (Monitoring)	How is revenue distributed across categories and segments?	Treemap (Composition)	Size: `SUM(Sales)`, Label: `Category`, Color: Categorical hues	Lower Right Panel (40%)

2. KPI Metric Hierarchy

Displays aggregate data from the latest full year (2026) compared to the previous period (2025):

Total Sales

$745,568

YoY: ▲ 21.4% (vs $613,934 in 2025)

Net Profit

$95,926

YoY: ▲ 16.0% (vs $82,665 in 2025)

Profit Margin

12.9%

YoY: ▼ 0.6 pp (vs 13.5% in 2025)

3. Filter & Interaction Model

Filters

Filter	Type	Location	Default	Scope
Order Year	Dropdown (Single Value)	Header Top Right	2026	Global
Segment	Dropdown (Multi Value)	Header Top Right	All	Global

Dashboard Actions (Interactivity)

Filter Action: Clicking on a Region bar (e.g. West) filters the Monthly Trend Chart and the Category Treemap to only highlight data for that region. Clearing filters returns the dashboard to aggregate statistics.
Highlight Action: Selecting a Category block in the Treemap highlights the corresponding category segments in the trend and regional charts, dimming other categories for fast comparative analysis.

4. Color & Typography Specifications

Color System

Primary Action Hue (Sales Trend Line): #4E79A7 (Classic Steel Blue)
Positive Margin / YoY Growth: #59A14F (Accessible Green)
Negative Margin / YoY Decline: #E15759 (Soft Red)
Muted Elements (Gridlines, Axes): #E2E8F0 / #64748B

Typography Layout

Dashboard Title: Outfit / Inter Bold, 22px, color: #0f172a
BAN Values: Outfit Bold, 34px, color: #0f172a
Section Titles: Outfit Semibold, 14px, color: #0f172a
Axes / Legends: Inter Regular, 10px, color: #64748b

5. Tableau Implementation Details

Calculated Fields Formulas

// 1. Identify latest data year dynamically [Is Current Year] : YEAR([Order Date]) = {MAX(YEAR([Order Date]))} // 2. Identify previous data year dynamically [Is Prior Year] : YEAR([Order Date]) = {MAX(YEAR([Order Date]))} - 1 // 3. Current Year Sales (for BANs) [Sales CY] : IF [Is Current Year] THEN [Sales] END // 4. Previous Year Sales (for YoY) [Sales PY] : IF [Is Prior Year] THEN [Sales] END // 5. YoY Sales Growth Percentage [Sales YoY %] : (SUM([Sales CY]) - SUM([Sales PY])) / SUM([Sales PY]) // 6. Current Year Profit Margin [Margin CY] : SUM(IF [Is Current Year] THEN [Profit] END) / SUM([Sales CY])

Layout Container Strategy

Vertical Container (Outer) holds everything.
Inside, a Horizontal Container (Header) fixed at 70px height contains the Title block and floating Filter parameters.
A Horizontal Container (KPI Row) fixed at 95px height contains the 3 BAN cards (Sales, Profit, Margin) configured with "Distribute Contents Evenly".
A Horizontal Container (Dashboard Body) split: Left main chart container (60% width) and Right sidebar container (40% width) containing two vertical sheets (Region Bars & Category Treemap).