Super Store Sales — Dashdown Excel Demo

🛍️ 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 #

Orders
Customers
Total Sales
Total Profit

🚀 Sales Performance #

Monthly Sales & Profit Trend #

🤖 AI Commentary #

Dashdown has two ways to put an LLM read-out next to a chart:

  • <Ask> sends a query's result to an LLM and renders a plain-language summary inline. On a static build it's baked once at build time, so it ships as part of the page — that's what you see below on the live demo.
  • explain (a chart attribute, new in 0.1.10) adds a hover-revealed ✨ button that generates commentary on demand — see the "Sales by Region" chart. It needs a live server (dashdown serve), so it's disabled on this static GitHub Pages build.
What does the trend say?

👥 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

Generated