AnalyzeFrom numbers to an answer.
An insight isn’t a curious fact: it’s something that changes what someone will do. I look for what happened, why, what’s next and what to do.
Four questions,from what happened to what to do.
An analysis that stops at the first question is a report, not an answer.
What happened
OTIF fell 1.1 points in week 42.
Why
The north warehouse explains 70% of the drop.
What’s next
With no changes, week 44 drops to 91%.
What to do
Check the North stock-out this week.
A number without its whychanges nothing.
The dashboard says what happened. Someone has to say why, and what to do.
What I don’t do,and what I do.
With no comparison
Against target, history and peers
Correlation as cause
I split signal from noise
Everything I found
One sentence, before the chart
One exact number
With a range
Because it sounds good
I start simple
Before explaining a change,I check that it is one.
Every metric goes up and down by itself. I explain what leaves its normal variation.
Looking for a cause means inventing one. Next week it comes back by itself.
Something changed in week 42. This one gets analysed.
Where the band comes from: from the metric’s own history. Average ± 2.66 times the average change from one week to the next.
First, where it comes from.Then, why.
I split the change before explaining it. The parts have to add up to the total.
The three parts add up to 1.1 points. The north explains 70%.
What happenedOTIF fell 1.1 points in week 42.
WhyThe north warehouse explains 70%: three products out of stock.
What’s nextWith no changes, week 44 drops to 91%.
What to doReview the reorder point of those three products this week.
Owner: north warehouse lead · FridaySix trapsand how I avoid them.
One number for everyone
Split by segment
“One causes the other”
A group without the change
“It doubled”
With how many cases
Only those who stayed
Those who left, too
“The plan worked”
Against its own history
One month against the last
The same month last year
AI runs the queries.I answer for the number.
The draft is fast. The checks are the work.
The AI says sales fell.
Nobody knows where the number came from.
Sales fell 8%. I checked it against accounting.
The number has a source, and someone answers for it.
- 1HypothesesMe
Three guesses, written before any query.
I askWhat would have to be true?
I leave with✓3 hypotheses - 2QueriesAI
It runs them with read-only access.
I askShow me the query and the row count.
I leave with✓A draft with its SQL - 3ChecksMe
Rows, one total, and the JOIN read line by line.
I askDoes it match what I already know?
I leave with✓A number I can defend - 4So what?Me
I turn the number into a decision.
I askWhat changes on Monday?
I leave with✓An action and an owner - 5Error logMe
I note what the AI got wrong.
I askWould it fail the same way again?
I leave with✓One line in the log
Data informs.An insight makes you act.
The same number, before and after asking “so what?”.
| Data | Insight |
|---|---|
| Sales: $412 M. | Sales are up, but through one channel: if it stalls, we miss the target. |
| Gross margin: 31.8%. | Margin is up because of mix, not price: keeping it depends on the premium line. |
| Top 10 products. | Seven products sell below true cost: four get adjusted and three go. |
What I get asked,and what kind of question it is.
The kind of question decides the method. Not the tool.
“Why did sales fall?”
✓I split the drop until one part explains most of it.
“Is this normal?”
✓I compare it with its own history, not with last week.
“How much will we sell next month?”
✓A range, and the simplest method first.
“Did the campaign work?”
✓I compare with a group that didn’t get it.
“Which customers are leaving?”
✓Cohorts by start month, before any model.
“Send me all the data.”
✓I ask which decision is waiting.
“Can the AI do it?”
✓It runs the queries. I check them and answer for the number.
There are three written insights.Each with its action and owner.
Analysing ends when someone can act without opening a single chart.
- ✓A conclusion in one sentenceThe north warehouse explains 70% of the drop.
- ✓Compared against target and history92.4% against a 95% target; −1.1 pp in four weeks.
- ✓Checked against the sourceRows, one total, and the JOIN read line by line.
- ✓An action and an ownerVisit the north warehouse. Owner: warehouse lead.
With the insights written, they get told. Next comes Communicate.





