🛍️ Super Store Sales Dashboard
A retail analytics dashboard built from a single Excel workbook with
Dashdown. Every chart below is plain Markdown plus SQL,
querying SuperStoreUS-2015.xlsx through the Excel connector — its Orders,
Returns, and Users sheets each become a SQL table you can JOIN across.
📊 Business Overview #
🚀 Sales Performance #
Monthly Sales & Profit Trend #
🤖 AI Commentary #
The <Ask> component sends a query's result to an LLM and renders a plain-language
read-out inline — turning a chart into an explained insight.
👥 Customer Segments #
🗺️ Regional Analysis #
🔁 Returns & Regional Ownership #
The workbook has two more sheets — Returns and Users — and each becomes its own SQL table. So you can JOIN across sheets exactly like a relational database.
Returned Sales by Category #
Joining Orders to the Returns sheet (on Order ID) reveals which categories come
back most by value.
Performance by Regional Manager #
The Users sheet maps each region to its manager. Join it to the orders to see who
owns which numbers — including the region running at a loss.
🔍 Interactive Explorer #
Filter the orders below by category, region, and customer segment. The "All" option in each dropdown clears that filter.
📦 Top Products #
🎯 Key Insights #
- Category mix: Technology and Office Supplies drive the bulk of revenue, but margins differ sharply between categories.
- Customer segments: Corporate and Home Office customers tend to place higher-value orders than Consumers.
- Regional spread: Sales are concentrated in a few high-performing regions — a cue for where to focus growth.
- Profitability: A high sales total doesn't guarantee profit — the margin chart shows where revenue actually converts to profit.
🛍️ Super Store Sales 2015 · Built with Dashdown and the Excel connector