HomeAboutProjectsHow I workContact
01Problem framing

DefineIt all starts here. The rest is the result.

“I need a dashboard” is not a problem. I turn it into a decision.

InterviewsProblem briefSuccess criteria
00What defining is

Defining is turning a requestinto a decision.

Try withA hardware wholesalerA distributorA delivery companyA retail chainFictional case

What do they ask for?

I ask before building.
Before

“A sales dashboard, with everything.”

✗
After

Built as asked, it’s 8 pages. I ask first.

✓
↓ Next: what really hurts?

What really hurts?

Margin by hand, every Monday
Before

“We want to see everything.”

✗
After

“Every Monday I export to Excel and compute margin by hand.”

✓
↓ Next: what gets decided with it?

What gets decided with it?

What to push and what to stop buying
Before

Looking at sales.

✗
After

Deciding what to push and what to stop buying.

✓
↓ Next: who, and how often?

Who, and how often?

Carlos and Paula, every Monday
Before

For everyone, whenever.

✗
After

Carlos decides. Paula uses it every Monday.

✓
↓ Next: how will we know it worked?

How will we know it worked?

Paula stops exporting
Before

That it looks nice.

✗
After

Paula stops exporting and margin rises 1 point.

✓
↓ Next: what stays out?

What stays out?

Reps: version 2
Before

Everything in version one.

✗
After

Reps, to version 2. 3 pages remain.

✓
✓ Done: that’s what gets built.

What do they ask for?

I ask before building.
Before

“All the finance numbers, in real time.”

✗
After

Built as asked, it’s 8 pages. I ask first.

✓
↓ Next: what really hurts?

What really hurts?

8-day close; figures that don’t match
Before

“I want more control.”

✗
After

“Closing the month takes 8 days, and sales don’t match the commercial team’s.”

✓
↓ Next: what gets decided with it?

What gets decided with it?

Which expense to stop
Before

Seeing the numbers.

✗
After

Deciding which expense to stop before month-end.

✓
↓ Next: who, and how often?

Who, and how often?

Finance manager, every Friday
Before

All management, online.

✗
After

The finance manager decides, every Friday.

✓
↓ Next: how will we know it worked?

How will we know it worked?

Close in 3 days
Before

That it’s in real time.

✗
After

Close in 3 days and one sales figure.

✓
↓ Next: what stays out?

What stays out?

Cash flow: version 2
Before

All together.

✗
After

Cash flow, to version 2. 3 pages remain.

✓
✓ Done: that’s what gets built.

What do they ask for?

I ask before building.
Before

“A logistics dashboard, with every KPI.”

✗
After

Built as asked, it’s 8 pages. I ask first.

✓
↓ Next: what really hurts?

What really hurts?

Three calls every morning
Before

“Orders arrive late.”

✗
After

“Every morning I call three warehouses to learn what’s late.”

✓
↓ Next: what gets decided with it?

What gets decided with it?

Which order gets priority
Before

Seeing OTIF.

✗
After

Deciding which order gets priority today.

✓
↓ Next: who, and how often?

Who, and how often?

Dispatch lead, at 8
Before

Management, once a month.

✗
After

The dispatch lead, every morning at 8.

✓
↓ Next: how will we know it worked?

How will we know it worked?

Zero calls; OTIF 96%
Before

A higher OTIF, someday.

✗
After

Zero calls, and OTIF from 92% to 96%.

✓
↓ Next: what stays out?

What stays out?

Fleet: version 2
Before

Everything in version one.

✗
After

Fleet, to version 2. 3 pages remain.

✓
✓ Done: that’s what gets built.

What do they ask for?

I ask before building.
Before

“An HR dashboard, with turnover and everything else.”

✗
After

Built as asked, it’s 8 pages. I ask first.

✓
↓ Next: what really hurts?

What really hurts?

Two weeks with an uncovered shift
Before

“Turnover is high.”

✗
After

“Each resignation leaves a shift uncovered for two weeks.”

✓
↓ Next: what gets decided with it?

What gets decided with it?

Where to reinforce and who to hire
Before

Looking at turnover.

✗
After

Deciding which stores to reinforce and who to hire first.

✓
↓ Next: who, and how often?

Who, and how often?

Store lead, every 15 days
Before

All of HR.

✗
After

The store lead decides, every 15 days.

✓
↓ Next: how will we know it worked?

How will we know it worked?

From 14 to 7 days
Before

Having the KPI.

✗
After

Go from 14 to 7 days with an uncovered post.

✓
↓ Next: what stays out?

What stays out?

Climate: version 2
Before

All of HR, at once.

✗
After

Climate, to version 2. 3 pages remain.

✓
✓ Done: that’s what gets built.
What was going to be built8 pages · 60 visualsOpened twiceThen back to ExcelNow it answers somethingNow it has an ownerNow it can be measuredUsed every MondayUsed every FridayUsed every morningUsed every 15 days
Margin
Customers
Products
Reps
Warehouses
Stock
History
Map
The brief fills up
PainMargin by hand, every Monday
DecisionWhat to push and what to stop buying
WhoCarlos and Paula, every Monday
SuccessPaula stops exporting
OutReps: version 2
Results
Budget
Expenses
Cash flow
Receivables
Cost centers
KPIs
Live
The brief fills up
Pain8-day close; figures that don’t match
DecisionWhich expense to stop
WhoFinance manager, every Friday
SuccessClose in 3 days
OutCash flow: version 2
Today’s delays
Warehouses
Summary
Fleet
Suppliers
Costs
Returns
Map
The brief fills up
PainThree calls every morning
DecisionWhich order gets priority
WhoDispatch lead, at 8
SuccessZero calls; OTIF 96%
OutFleet: version 2
Vacancies
Turnover
Staffing
Climate
Training
Absence
Pay
Org chart
The brief fills up
PainTwo weeks with an uncovered shift
DecisionWhere to reinforce and who to hire
WhoStore lead, every 15 days
SuccessFrom 14 to 7 days
OutClimate: version 2
00Why it matters

A dashboard nobody usescosts you twice.

Once when it’s paid for. Again when the team goes back to Excel and stops trusting the data.

When…
1The request arrives
2Something must change
3Something new shows up
4Someone asks about sales
5Two weeks go by
690 days go by
✗Not defined
60 visualsEverything, just in case
10 hoursIt’s already built
All inScope grows by itself
3 figuresEach team has its own
Nobody opens itBack to Excel
Did it work?Nobody defined it
✓Well defined
3 pagesOnly what decides
10 minutesIt’s still a sketch
Goes to V2If something enters, something leaves
1 figureWith an owner and a signature
It’s usedEvery Monday, by name
It’s measuredWhat was agreed at the start
00What I do and don’t

What I don’t do,and what I do.

1Who I listen to
✗I don’t

Just one person

✓I do

Who decides and who suffers the data

2Where I start
✗I don’t

“What reports do you need?”

✓I do

The Monday Excel

3The scope
✗I don’t

“I want to see everything”

✓I do

From “all” to one decision

4Success
✗I don’t

Promise a chart blindly

✓I do

Agree how it’s measured

5The first meeting
✗I don’t

Open Power BI

✓I do

I leave with a brief

00The first meeting

45 minutes,and not one chart.

I show no designs and don’t open Power BI. I listen and take notes.

✗
Not this questionWhat reports do you need?

You get a list of charts, and nobody says what gets decided.

✓
This oneWhat decision do you make with this, who makes it and how often?

You get the problem, the owner and the rhythm.

45 minutes, step by step
10–5′25–20′320–30′430–40′540–45′
  1. 1Context0–5 min

    I learn the business.

    I askWhat’s a normal week like here?
    I leave with✓Examples that fit
  2. 2The jobs5–20 min

    I listen to what hurts and write exact quotes.

    I askWhat did you decide last week with numbers?Show me how you got them.
    I leave with✓3 jobs that hurt
  3. 3Prioritize20–30 min

    I propose two and ask to be corrected.

    I askWhich costs more each month?
    I leave with✓2 jobs, never more
  4. 4Data and limits30–40 min

    I check what sinks projects.

    I askWhat time does the data arrive?Who signs this?
    I leave with✓The conditions, in writing
  5. 5Close40–45 min

    I agree on success and the next date.

    I askHow will we know in three months it worked?
    I leave with✓Success and a date
00Is it a dashboard?

Before drawing:is this a dashboard?

Click, or scroll to say “Yes”. Of 8 exits, only 2 are a dashboard. Each “No” has its own solution.

Of 8 exits, only 2 are a dashboard.This one is yours. Tap a dot to go back.
1/7This checks: The owner

Does someone specific come back to this question on a fixed rhythm?

By name, every week or every month.

2/7This checks: The data

Does the data exist and can it be connected?

Where does it come from today? Can you show me?

3/7This checks: The decision

Does looking at it change what someone does?

What do they do differently when they see the number?

4/7This checks: The role

Do they want to see what happens, not have the system decide?

A person looks and decides.

5/7This checks: The definitions

Is there someone who decides which figure is right?

“Each team has its own sales number.”

6/7This checks: The form

Will they look at it, not just download the file?

What do they do after downloading it?

7/7This checks: The conditions

Are there any conditions?

Phone, who sees what, external users, late data.

This branch ends here

An analysis, not a dashboard

It’s answered once and written down. Nobody will open a dashboard twice for this.

This branch ends here

First, a data project

The dashboard makes sense, but today there’s nowhere to get the data. Source first, with its timeline.

This branch ends here

An alert, not a screen

If nobody will be looking when it happens, you don’t build a screen.

This branch ends here

A model, not a dashboard

It’s another craft and another timeline. Power BI can show the result afterwards.

This branch ends here

First, agree on definitions

If I build the dashboard now, it’ll be the fifth version of sales.

This branch ends here

Excel connected to the model

They stay in their Excel, but with the same number as everyone.

Your pathTap the map to go back

It could still be any of these

  • Written analysis
  • Data project
  • Alert
  • Predictive model
  • Dictionary
  • Connected Excel
  • Dashboard
Why did sales fall in March?

Three warehouses explain almost all the fall. Check the north one first.

1 or 2 pages, in a week. Nothing to maintain.

Phase 1Sort out the sourceOr a capture app, if it’s born when typed
→
Phase 2The dashboardNow on something real

Two timelines, in order.

Coffee stock: 10 days leftIt reaches Teams, only when it happens

Zero pages. It costs a fraction of a dashboard.

customerleaves
Las Rosas82 %
El Puente64 %
Central31 %

BigQuery ML or Python, with its own timeline.

KPIdefinitionowner
Net salesInvoiced − credit notesControl ✓
MarginSales − day’s costFinance ✓

A dictionary with owner and signature. One week.

areaQ1Q2
North412398
South305321

Insert › PivotTable › From Power BI.

The verdict, in one sentence

A 3-page dashboard for Paula, reviewed every Monday to decide what to push and what to stop buying.

    00What I hear

    What I hear,and what’s behind it.

    The request is the symptom, not the diagnosis.

    What I hear→What it really is→What I do
    “I need a dashboard with everything.”
    It’sA wish list

    ✓I look for the decision. 3 pages come out.

    “I want it in real time.”
    It’sA clock question

    ✓I ask how much delay works.

    “I want to download everything to Excel.”
    It’sAn extract

    ✓Excel connected to the model.

    “Why did sales fall in March?”
    It’sAn analysis

    ✓Two pages with the conclusion.

    “Each team has its own number.”
    It’sA definitions problem

    ✓A dictionary with owner and signature.

    “Tell me if it drops below this.”
    It’sAn alert

    ✓An automatic notice. Zero screens.

    “Tell me which customers will leave.”
    It’sA predictive model

    ✓BigQuery ML or Python.

    00Saying no

    Saying “this isn’t a dashboard”builds the most trust.

    I don’t sell what I know: I solve what’s there.

    When the request is a question answered once, I say no to the dashboard and yes to the answer.

    A managerBuild me a dashboard to see why sales fell in March.
    1I name what it isWhat you describe is an analysis, and I can do it.
    2I say why notA dashboard is for looking at the same thing every week. This gets answered once.
    3I propose, with a dateIn one week I hand you the written conclusion.
    4I leave the door openIf something shows up to watch every week, that’s the dashboard.
    ✗If I say yes

    How long6 weeks of work

    What they getA dashboard opened once

    What remainsThe question stays unanswered

    ✓If I say no

    How long1 week

    What they get2 pages with the answer

    What remainsNext time they call me first

    They win: an answer, and sooner. I win: next time they ask me before deciding what to ask for.

    00The deliverable

    One brief,on a single page.

    If it doesn’t fit on one page, we still don’t understand the problem.

    The brief1 page · version 1 in two weeks · reviews at 30, 60 and 90 days
    1. Which decision?

      What to push and what to stop buying.

    2. Who, and how often?

      Carlos and Paula, every Monday.

    3. What’s delivered?

      3 pages: margin, customers and products.

    4. What stays out?

      Reps and stock: version 2.

    5. What does the team provide?

      Paula tests on Fridays. Accounting validates sales.

    6. How will we know it worked?

      Paula stops exporting and margin rises 1 point.

    Signature✓Signed

    Week 8. Someone says…

    ✗Without a brief: it’s an argument✓With it: it’s answered
    “I asked for something else.”The brief says what was agreed.
    “And this too?”If something enters, something leaves.
    “Did it work?”What was signed gets measured.
    00A case

    One case,from start to finish.

    1What they asked forA sales dashboard for the whole company.

    Distributor with 6 areas.

    2What I found
    • On Mondays6 managers decide who to visit.
    • With an ExcelIt arrives on Sunday, sometimes late.
    • That doesn’t matchIt doesn’t deduct credit notes.
    • In the carBetween customers.
    3What I proposed

    One screen, on the phone. Each manager sees their area.

    4What changed
    Sunday ExcelOff in 6 weeks
    3 sales figures1, signed
    Everyone sees everythingEach manager, their area
    Out, with a destinationThe big customer: an analysis“Tell me”: an alert
    Fictional case.
    00How I know I’m done

    The brief is signed.Now it can be built.

    Defining ends when these four things are on paper and the owner signs off.

    I’m done when there is…
    1. ✓
      One decisionWhat to push and what to stop buying.
    2. ✓
      An owner and a rhythmCarlos and Paula, every Monday.
    3. ✓
      Success, measured at 90 daysPaula stops exporting; margin rises 1 point.
    4. ✓
      What stays out, in writingBy rep: version 2.
    ✓Signed

    With the signature, it gets built. Next comes Review: checking the data holds up.