KPI Dashboards and Commentary

A dashboard without good commentary is just numbers. AI can help you turn raw KPI data into compelling performance narratives — the kind that actually drive decision-making rather than just reporting what happened.

This lesson covers how to use AI to generate KPI commentary, improve dashboard narratives, and create consistent performance language across your business.

The Gap Between Data and Insight

Most KPI dashboards show what happened. Good commentary explains:

• Why it happened
• Whether it matters (one-off vs trend)
• What it implies for the business
• What action should follow

Finance teams often spend most of their time on "what" and not enough on "why" and "so what." AI can handle the structural writing so you have more time for genuine interpretation.

Generating KPI Commentary

The core prompt

"Here are this month's KPIs for our [business/division]:

KPI	Actual	Budget	Last Month	Last Year
Revenue	£4.2m	£4.5m	£3.9m	£3.8m
Gross Margin %	39.1%	41.0%	40.2%	38.5%
Customer Count	1,240	1,300	1,210	1,050
Revenue per Customer	£3,387	£3,462	£3,223	£3,619

Write performance commentary for each KPI using this structure:

• One sentence on headline result
• One sentence on key driver
• One sentence on trend or outlook

Audience: monthly management meeting. Tone: direct, analytical, not defensive."

Commentary for Different KPI Types

Revenue KPIs

"Revenue came in at £4.2m, £300k (6.7%) below budget but £400k (10.5%) ahead of the same month last year. The shortfall versus budget is entirely attributable to a delayed order from a top-5 customer, with core underlying performance on track."

Operational KPIs

"Here is our operational performance data for [month]: [paste data]

Write a 2-sentence commentary on each metric that explains the result and what it means for financial performance. Flag any metrics that indicate an emerging risk."

Leading Indicators

"We track these leading indicators that predict future revenue performance: [list with current readings].

Based on this data, write a 100-word forward-looking commentary for the board. What do these leading indicators suggest about the next 2-3 months?"

Improving Existing Commentary

Paste your existing KPI commentary and ask:

"Here is the KPI commentary from last month's management report:

[paste commentary]

Critique this: what's missing, what's vague, what should be cut? Then rewrite it to be sharper and more insightful. Same word count or shorter."

Creating a Commentary Framework

For recurring dashboards, build a consistent framework once:

"Create a commentary framework for a [sector] business monthly dashboard. For each of these KPI categories — Revenue, Margin, Cost, Cash, and Customer — define:

1. What the commentary should always address
2. The sentence structure to use
3. What to include when performance is adverse vs favourable

Output as a template I can reuse each month."

Before/After Example

Before: "Customer count increased to 1,240. Revenue per customer was £3,387."

After: "Active customer count grew to 1,240 (+30 vs last month, +190 vs last year), reflecting the impact of the Q3 sales campaign. Revenue per customer of £3,387 was below budget (£3,462) and below last year (£3,619), indicating the new customer cohort is generating lower initial transaction values — a pattern consistent with the onboarding period seen in previous cohorts."

Your Turn

Copy the KPI data from your most recent management report or dashboard. Paste it with the commentary prompt above. Compare what AI generates to what you wrote. Focus especially on whether the AI's "so what" statements match your understanding of the business.