Disclaimer
This project was born out of a classic retail challenge: Just-Store is growing fast across multiple regions, but leadership was flying blind when it came to tracking where they were actually making money versus where they were just spinning their wheels.
To solve this, I built an interactive, end-to-end management dashboard in Tableau Public. The goal wasn't just to make pretty charts, but to create a single, reliable workspace that exposes hidden profit drains, highlights regional performance gaps, and maps out predictable sales cycles, so the management team can make proactive, data-backed decisions instead of reactive guesses.
- Imbalanced Growth - Sales were booming in some regions but completely lagging in others, with no clear visibility into why.
- The "Vanity Metric" Trap - High sales volumes in certain categories looked great on paper but were masking incredibly weak profit margins.
- Predictability Hurdles - A lack of clear historical trend tracking made it difficult for the supply chain and marketing teams to plan for seasonal spikes.
- To build a single, reliable executive dashboard that consolidates sales, profit, and order data into one workspace.
- To expose category-level profit drains hidden behind strong top-line sales figures.
- To surface regional performance gaps so successful strategies can be identified and replicated.
- To map recurring sales cycles so operations and marketing teams can plan proactively rather than reactively.
- To give stakeholders an interactive tool, not a static report, so they can self-serve answers by region and year.
Design Approach The dashboard was designed using a clean, professional sage-green palette, with the layout kept scannable for an executive audience, a KPI-first structure up top, supported by detail views below.
What Was Built
- The High-Level Pulse - a clean KPI header giving an instant snapshot of business health: 247 customers, 296 orders, $180.5K in sales, and $23K in net profit.
- Modern Interface & Navigation - a custom, left-aligned sidebar menu, letting users switch effortlessly between a high-level Executive View and a granular Table View for row-level auditing.
- Seamless Interactivity - synchronized global filters for Years and Regions. A stakeholder can click any region in the sidebar, and the entire dashboard instantly updates to reflect that market.
- Tableau Public - BI and visualization platform used to design and publish the interactive dashboard.
- Business Intelligence & Executive Reporting Standards - framework guiding the layout, KPI selection, and stakeholder-first design approach.
Sales Performance - Executive View, showing KPI summary, sales by region, sales distribution by category, sales and profit by category, and sales trend over time.
The dashboard combines five views in a single screen: a KPI header, a regional sales bar chart, a category distribution pie chart, a side-by-side sales-vs-profit comparison by category, and a full-year sales trend line, all filterable by Year and Region from a persistent sidebar.
Through the building phase and visual analysis of the dashboard in Fig. 1, three major operational insights emerged:
1. The Furniture Margin Trap Furniture is a massive revenue driver, pulling in $59,219 in sales, roughly a third of all sales. However, it converted into only $2,341 in actual profit. Compare that to Technology, which brought in $72,708 in sales but kept a much healthier $13,997 in profit.
2. The West Coast Engine The West region is carrying the business, generating $107, 483 in sales, more than the East, South, and Central regions combined.
3. High-Definition Seasonality Sales follow a strict cyclical pattern rather than random fluctuation. Demand explodes in September ($29,485) and peaks again in December ($25,639), with noticeable slumps in spring and early summer.
- Re-evaluate Furniture's cost structure - investigate shipping fees, supplier costs, and promotional discounting, since the category's sales volume is masking a serious margin problem.
- Study and replicate the West region's playbook - identify what's driving its outsized performance and apply the same approach to the underpenetrated Central ($14,007) and South ($17,309) regions.
- Plan inventory and marketing around the seasonal curve - ramp up stock and marketing spend 30 to 60 days ahead of the September and December peaks to avoid stockouts and capture available revenue.
Just-Store Sales Performance & Profitability Analysis - Executive Dashboard Case Study Questions & discussion welcome.