Just Store Executive Dashboard

Overview

An executive-level Tableau dashboard designed to monitor retail performance through core KPIs and breakdowns by region and category. It supports fast, data-driven decisions by combining top-line metrics with interactive comparisons and time-based trends.

Key KPIs

• Customers: 247
• Orders: 296
• Sales: $180.5K
• Profit: $23K
• Quantity: 3,053

Dataset

Retail order-level dataset with customer, order, category, region, sales, profit, and quantity fields. Grain: Order line level.
Timeframe: Filtered by Year of Order Date.

What This Dashboard Answers

• Which regions drive the most sales?
• Which categories contribute the most revenue and profit?
• How does performance change over time?
• How do Year and Region filters shift executive insights?

Visual Highlights

• Sales by Region (bar)
• Sales Distribution by Category (pie)
• Sales & Profit by Category (comparative bars)
• Sales Trend Over Time (time-series)
• Interactive filters for Region and Year

Key Insights

• West leads regional sales with $107,483, ahead of East ($41,705), South ($17,309), and Central ($14,007).
• Technology is the top revenue category at $72,708, followed by Furniture ($59,219) and Office Supplies ($48,577).
• Profit is strongest in Technology ($13,997), compared with Office Supplies ($6,894) and Furniture ($2,341).
• The monthly trend suggests seasonality and potential campaign-driven spikes.

Business Recommendations

1. Defend and grow the West region through inventory depth, service reliability, and targeted upsell bundles.
2. Improve weaker regions using localized promotions and distribution/availability reviews.
3. Optimize category margins by reviewing pricing, supplier cost, and discount strategy.
4. Align inventory and marketing with peak months to reduce stockouts and lost sales.
5. Expand Technology attach-rate via accessories, warranties, and cross-sell offers.

Tools

• Tableau

Skills Demonstrated

• Executive KPI reporting
• Regional and category performance analysis
• Interactive dashboard development
• Stakeholder-focused storytelling

Dashboard Preview

Files

• Just Store Dashboard.twbx
• README.md

How to View

1. Download the .twbx file.
2. Open in Tableau Desktop.
3. Use Year and Region filters to explore performance shifts.