CommunicateIt’s understood without me there.
I guide the story with good narrative, good design and good experience. The title states the conclusion, one metric leads and every number has context.
The titledoes half the work.
It’s the most-read text on the page. It can be a label or it can be the answer.
Being right isn’t enough.It has to be understood.
On average, only one in four employees uses BI tools in their daily work.
What I don’t do,and what I do.
Build and see what happens
Sketch: 10 minutes
“Sales by region”
States the conclusion
12 visuals, no conclusion
One metric leads
3D and competing backgrounds
One accent, for what matters
Email the link and done
I check usage at 30 and 90 days
Three readers.Each one gets their depth.
The same analysis, at three depths. The conclusion always goes first.
- The answer
Are we OK?
One sentence and one number - The ask
What do you need from me?
One decision, with its options
- The place
Where do I act this week?
The ranking, worst first - The reference
Compared with what?
Target, history and peers - The owner
Who takes it?
A name next to each action
- The source
Where does this come from?
The table and the definition - The repeat
Can I run it again?
The query, with its date
The question picks the chart.Not taste.
Seven questions cover almost everything a dashboard gets asked.
“How much, against the target?”
✓Bars from zero, with the target as a line.
“How did it change?”
✓A line. Bars only for a few periods.
“Who comes first?”
✓Horizontal bars, sorted.
“What share is it?”
✓One stacked bar. A pie only with two or three parts.
“How is it spread?”
✓A histogram. The average alone hides it.
“Do they move together?”
✓A scatter plot, saying what each dot is.
“What is the exact figure?”
✓A table. Not everything is a chart.
One dashboard,four decisions.
Pick one and see where it sits on the dashboard.
- 1
One metric leads
On-time delivery goes first: it is what the customer feels.
- 2
One point, one explanation
Only the week that changes the story is marked.
- 3
Where to look next
The ranking says which warehouse to check first.
- 4
Context, not decoration
Every number comes with a comparison.
Six common mistakesand how they get fixed.
“Sales by region”
“The north falls 8%”
A pie
Sorted bars
One per category
Gray and one accent
Only red and green
Color and a mark
Starts at 90
Starts at zero
12 visuals
One leads, three explain
The dashboard and the AIgive the same answer.
If Copilot or Claude reads the model, it has to find the same words as the page.
Dashboard: 92.4%. AI: 94.1%.
Two definitions of “on time”.
Dashboard: 92.4%. AI: 92.4%.
A single measure, with its description.
- 1Names people useIn the model
“On-time delivery”, not “otif_flag_v2”.
I askWhat do they call it in the meeting?
I leave with✓Tables and measures renamed - 2A description per measureIn the model
What it counts, what it leaves out and its unit.
I askWould someone new understand it?
I leave with✓One line per measure - 3Verified answersIn Power BI
The most asked questions, each tied to an approved visual.
I askWhat do they ask every week?
I leave with✓Answers a person already reviewed - 4The same question, three waysMe
I ask the AI and compare with the page.
I askDoes it match the dashboard?
I leave with✓A note of what didn’t match
Publishingis day 1 of 90.
A dashboard nobody uses costs twice. This plan turns it into a team habit.
| When | What I do | What I check |
|---|---|---|
| Day 0 | 30-minute launch: how to read each page in 3 minutes. | Everyone can get in |
| Week 1 | Monday subscription for the main person. | Active users |
| Day 30 | I review usage: what isn’t opened gets changed or removed. | Pages nobody opens |
| Day 90 | I measure against the brief from phase 1. | What the brief agreed |
What I get asked,and what’s behind it.
The request is about the page. The need is about a decision.
“Add one more chart.”
✓I ask which decision it supports. If none, it stays out.
“Make it look nicer.”
✓Fewer things and more order. Then, color.
“Nobody uses it.”
✓I look at usage and sit down with three users.
“Put everything on one page.”
✓One page with what decides. The rest, one click away.
“I need it for the board.”
✓Three slides: the conclusion, the evidence and the ask.
“Can it come by email?”
✓The same page, sent every Monday.
“Can I just ask Copilot?”
✓Yes, once names and definitions are ready.
They decide without calling me.And nobody builds their own Excel.
Communicating ends when the dashboard is used every week, without me in the room.
- ✓The title states the conclusionMargin falls on 7 products: raise price or drop them.
- ✓One metric leadsThe rest explains it.
- ✓It reads in 30 secondsTested with someone who wasn’t in the project.
- ✓It’s still used after day 30What nobody opens gets changed or removed.
One phase left: document, so everything makes sense without me.





