The 14-year-old dashboard method I stole from P&G’s CIO (it’s yours in 5-steps)

The skills you need for a $400k finance role:
 
15 years’ CPA experience, and then this:
“Demonstrated experience using generative AI tools.”
5 years ago, that line wasn’t on any job description. Today it’s on the highest-paying ones. In 2 years it’ll be on all of them.So, to make sure you don’t fall behind in your career, join me for this free 60-min masterclass.
 
I’ll show you:
 
  • How to build a 5-year, 3-scenario model in minutes (and use it in a board meeting as a live tool)
  • How to auto-generate the branded PowerPoint from the same model (without formatting a single slide)
  • The one Copilot setting 90% of finance pros don’t know exists
 
1,332 pros joined me last time. 95% stayed for the full hour.
So, to get ahead of AI and improve your career, make sure to save your seat here before we are full.
 

Before AI, I waited 6 months for a dashboard. It never came.

It took 3-4 days of work in Excel for my team to create cost centre reports for each department.

Then a BI team arrived and we were so happy we thought we’d have everything automated, and on a dashboard by the end of the month.

Six months later? Nothing.

Now AI can build the same thing in 10 minutes.

But thinking about this now, I don’t think the BI team failed because they were slow.

I think they failed because nobody ever agreed on what the dashboard was for.

And here’s what’s crazy. Procter & Gamble had solved this exact problem 14 years ago. Before AI even existed. They built dashboards around decisions (not data) and killed more than 80% of their BI reports doing it. I just didn’t know yet.

Dashboards you build too quickly become AI slop that nobody looks at. So today, I’m going to show you the method P&G proved works over a decade ago — and how to apply it to your AI dashboards this afternoon.


Avoid becoming a ‘Data Decorator’

Important – If you’ve not built an AI dashboard yet, you need to do this.

Upload a file, ask AI to build something, play with the output. That is how you learn what the tools can do.

But that is practice, and not always something that you want to present.

For a full step by step on creating AI dashboards, you can read my previous newsletter here.

The moment you want to show an AI-built dashboard lands in front of the CEO, the board, or your team, the rules change.

You need to have put real time into the design thinking first. Things like the decision you want to make, the KPIs that support it, and the layout.

If you skip this, you are just creating AI slop that shows your data in a different way. And your credibility goes with it.

You become a ‘data decorator’ where your CEO looks, nods, and forgets about it.

In my AI Finance Accelerator we make all participants create a dashboard using AI in week 2. But, one that they can then use to create an impact in their business. Here are some examples of what they produce:


The ‘Decision Cockpit’

Back to P&G.

In 2012, their Business Services Group President Filippo Passerini asked a different question.

Instead of “what dashboards should we build?” he asked, “what decisions do our leaders need to make?”

Then he built dashboards around those decisions. He called them Decision Cockpits. And they replaced more than 80% of P&G’s standardized reports, which were then deployed to 50,000+ employees across 50+ offices.

Source | Practical Analytics

Passerini’s own description: his dashboards were “focused on forward-looking projections rather than historical reporting.”

That difference (building around the decision, not the data) was the focus in 2012 when P&G did it without AI.

It’s still the focus in 2026, when you can build the same thing with AI in 10 minutes.

Your edge is your brief.

You know which decisions matter. You know which KPIs drive them. You know what is important to the board.

AI can build in 10 minutes what a BI team could not build in 6 months.

But only you can decide what the dashboard is for.


5 steps to your first decision-first dashboard

Step 1. Name the one decision (on a Post-It, before AI)

Write one sentence: “This dashboard helps [role] decide [action] each [cadence].”

Example: “This dashboard helps the CEO decide whether to approve Q2 hiring requests, monthly.”

If you cannot finish the sentence, do not build the dashboard.

Step 2. Name the owner and the cadence

Who acts on it, and how often? If the answer is “everyone, whenever” – stop.

A dashboard with no named owner has no owner. Pick one name and one cadence. Weekly, monthly, per board meeting.

Step 3. Name the trigger metric

What single number, if it moved, would change the decision? That is the top of your dashboard. Everything else is evidence.

Step 4. Brief the AI with the decision, not the data

Use this prompt pattern:

I am [role]. I need to decide [action]. The trigger metric is [KPI]. Build an HTML dashboard that surfaces [trigger metric] prominently, with 3 to 5 supporting KPIs as context. Attached: [data file].

Tell AI what the dashboard is for, before asking it to build.

In my last Crash Course I uploaded a file and said: “I am the finance manager, I want to understand how to increase sales. I want to build the best dashboard.”

I was not asking it to build yet. After one minute I had a proposed set of metrics and a layout, and that was my chance to push back.

One thing I push back on every time: data availability. Before you let AI do anything, walk through each proposed KPI and ask, can I pull this data from my systems, reliably, on the cadence the decision needs?

If the answer is no for even one KPI, change it out or find something different for now.

Otherwise you end up with a beautiful dashboard you can never populate and every month you waste time finding exports to create it.

Step 5. Review the layout before the data is plotted

When AI returns its proposed structure, check it against the decision.

Is the trigger metric the most prominent element? Does every other chart earn its place by supporting that one decision?

If not, keep on improving it.


The CFO of HPE did this, this year

Earlier this year, Fortune published the story of Marie Myers, CFO of Hewlett Packard Enterprise (article here).

Her weekly Monday review used to improve 100+ PowerPoint slides and hundreds of hours of manual prep across the business.

Her team built an AI dashboard called Alfred (yes, after Batman’s butler) that led to: A 40% cut in financial reporting cycle time, a 25% cut in processing costs, and 90% of the manual weekly prep removed.

The super important bit? Myers told Fortune: “The first move wasn’t to switch on AI, but to redesign the work.”

She rebuilt the process around the decisions her business needed to make – then switched on AI.

And if you’re thinking “yeah but I’m not Fortune 500” – this is good. You’ve got less complexity, less politics, and AI that costs $20 a month.

If the CFO of a Fortune 500 company had to start with a blank sheet of paper, so can you.


The One Thing To Remember

My BI team failed in 6 months. An AI dashboard can now fail in 10 minutes. The time saved is not the point. The decision behind the dashboard is.

P&G proved this in 2012, without AI. HPE proved it still works in 2026, with AI. The tools change. The method does not.

Your next dashboard should not start in Excel, in ChatGPT, or in Claude. It should start on a single sheet of paper, with one sentence:

“This dashboard helps [who] decide [what] each [when].”

If you can write that sentence, you are already the most valuable role in finance in 2026 – the person who owns the brief (and the decision).

Register for the Masterclass

How to Become an AI CFO.

Tuesday, June 16.

11am EST, 4pm UK, 5pm CET

By signing up, you agree to this website’s Privacy Policy.
You agree to receive SMS reminders from AI Finance Club GmbH about webinars you register for.
Message and data rates may apply. Frequency varies. Text STOP to unsubscribe. Also, you will be subscribed to our newsletter. You may unsubscribe at any time.

Days
Hours
Minutes
Seconds

Tuesday, June 16 | EST: 11am, UK: 4pm, CET: 5pm

Learn how to Become an AI CFO
in just 90 minutes

Join my free AI for Finance Masterclass and learn the exact AI workflows they use.

Contact.

Fill out the form below, and we will be in touch shortly.

Interest in AI Finance Club.

Fill out the form below, and we will be in touch shortly.

Almost there.

Now check your email to confirm your subscription.

(Make sure to add my email address email as contact and move my emails to your main inbox in case it landed in Spam or in the Promotion tab).

Almost there.

Now check your email to confirm your subscription and start your download.

(Make sure to add my email address email as contact and move my emails to your main inbox in case it landed in Spam or in the Promotion tab).

Free Download

Download This Guide Absolutely Free.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.

Free Download

Enter Your Email Address Below to Start Your Download.

You will be subscribed to my newsletter. Unsubscribe at any time.