HealthCan it be trusted and acted on?
Kitchen-sink dashboard
Everything anyone ever asked for on one page. Nothing has priority, so no answer can be found quickly.
Click a widget to see its data
Sales dashboard v7 (final, updated)
Everything in one place
Refreshed hourlyShare
Date:AllRegion:AllStore:AllChannel:AllCategory:AllBrand:AllPromotion:AllSegment:AllReset
Revenue
$4.8M
+6%
Margin
41%
−1 pt
Units
162k
+3%
Customers
38k
+2%
Revenue
By brand
Nova$0.9M
Aurora$0.8M
Vega$0.6M
Orbit$0.5M
By city
Lyon410
Leeds380
Milan290
Porto210
LowHigh ($k)
Margin
All stores
| Store | Revenue | Margin | Units |
|---|---|---|---|
| Harbourside | $61k | 41% | 2.1k |
| Old Town | $56k | 40% | 1.9k |
| Riverside Mall | $52k | 39% | 1.8k |
| Station Square | $48k | 38% | 1.7k |
| Market Street | $44k | 41% | 1.5k |
| Airport | $40k | 36% | 1.3k |
| Lakeside | $36k | 39% | 1.2k |
| Canal Side | $33k | 37% | 1.1k |
By promotion
None$2.9M
Bundle$1.1M
Clearance$0.8M
Target
By channel
Stores$3.0M
Online$1.4M
Marketplace$0.4M
The data model behind it
Sales order linesEach widget queries a different corner of the model, so the page reads all seven tables. The focused rewrite answers the main question from three.
- Tables read
- 7 of 7
- Joins
- 6
- Fact type
- Transaction fact (order-line grain)
- Grain
- One row per order line
- Refresh
- Hourly
Widgets
Highlighted: every table this view reads. Pick a widget to isolate its query.
Where it sits in the taxonomy
Its numbers are relevant, honest and fresh, but there are too many of them and none has priority: a new reader cannot find the main answer in seconds. Vanity and watermelon fail on what is shown; this one fails on how much.
- In the last quarter, has anyone opened it and has its data refreshed?Yes
- If its headline numbers moved, would someone act differently?Yes
- Can a summary status be green while items inside it are failing?No, roll-ups show the worst case
- Can a new reader find the main answer in about ten seconds?No, too much competes for attention
- Kitchen-sink dashboard
At a glance
- Check failed
- Focus
- Symptom
- Everyone scrolls, nobody reads
- Root cause
- Requests added over time, never removed
- Test
- Give a new reader ten seconds to find the headline
Not to be confused with
- Sanity dashboard
- A sanity dashboard shows the few numbers that answer its question. A kitchen sink shows every number anyone might ask about.
- Vanity dashboard
- Vanity is about the wrong metrics. Kitchen sink is about too many of the right ones.
How to recognise it
- More than about nine widgets
- Every widget has the same visual weight
- Charts too small to read
How to fix it
- Pick one purpose and remove what does not serve it
- Move secondary views to linked detail pages
- Keep three to five KPIs at the top