Gains:
- Ability to produce board-friendly KPI summary with context and trend from raw metrics
- Ability to design reports that present each metric with action suggestions and source tags
- Ability to establish discipline that will make the source of each number in the report traceable and prevent exaggeration
It's the end of the month and you need to prepare a presentation to the board of directors. You have dozens of metrics: turnover, gross margin, collection period, revenue per employee, customer churn rate... But the board of directors does not want to see a pile of numbers; "where is our business going and what should we do?" searches for the answer to the question. In this unit, we will learn to use artificial intelligence (AI) as a reporting assistant that translates raw metrics into the language of the decision maker.
What is KPI and how is it different from Metrics?
Metric is anything that can be measured. KPI (Key Performance Indicator) is a limited number of metrics that the decision maker actually looks at, showing how close the company is to its goals. A good management report does not present 40 metrics but 6-8 KPIs with context, trends and action.
AI does three jobs at this point: it contextualizes the numbers (by previous period, target), translates the trend into narrative, and formulates recommended actions. Your job is to keep the source of each figure traceable and to prevent the narrative from becoming exaggerated.
Tip: Ask him to present each KPI with the “number + change + reason + action” quartet. Instead of the bare "Turnover 12M", "Turnover 12M (+8% compared to last quarter), the new dealer channel is dragging, consider shifting the budget to this channel" is much more valuable.
Step by Step: From Raw Metrics to Management Report
- You determine your KPI set. Don't let the model fit; Give which 6-8 indicators.
- Add comparison basis. Target and/or previous period for each KPI.
- Adjust the narrative level. Specify a target audience, such as "to non-financial executives."
- Ask for action, but tie it to data. Each recommendation should be based on a finding.
- Require source note. Let it be traceable where each number comes from.
Weak Prompt / Strong Prompt
Weak prompt: Write a management report from these figures. [metrics]
This produces blank text with a “we had a great quarter” tone that embellishes the numbers but provides no direction to the decision maker.
Powerful prompt:Your role: management report assistant to a CFO.Task: Write a 1-page summary to the board of directors from the following KPIs.Structure:- 3-sentence executive summary at the top- For each KPI: value | previous period | change% | one sentence comment | suggested action- “3 risks to watch” at the end Tone: understated, neutral, suitable for a non-financial board.Constraint: Use only the numbers in the data. Write the source with the [source] tag next to each number. Do not comment if you are not sure.<kpi>Turnover: 12,400,000 this quarter | 11,500,000 last quarter [income statement]Gross margin: 34% | last quarter 37% [income statement]Collection period: 58 days | last quarter 49 days [current account]Customer churn: 6% | last quarter 4% [CRM]</kpi>
This prompt; It presents in a balanced manner that the turnover is growing but the margin and collection are deteriorating and asks "is the growth profitable and converted into cash?" puts the question before the management.
Good and Bad KPI Presentation
poor presentation
Powerful presentation
"Turnover 12.4M"
"Turnover 12.4M, +8% quarterly; growth continues"
"Margin has fallen"
"Gross margin 37%→34%; cost increase reduced the margin by 3 points"
"Collection is bad"
"Collection 49→58 days; cash cycle extended by 9 days, liquidity risk"
no action
"Suggestion: review payment terms on the 5 slowest customers"
Defining the Metric Correctly
A KPI is only meaningful when it is clear how it is calculated. “Profitability” might be gross margin for one, net margin for another, EBITDA (earnings before interest, depreciation and amortization) for another. Even within the same team, the same word can refer to different numbers. When having AI produce KPIs, clearly provide the definition and formula for each metric; Otherwise, the model calculates with its own assumptions and the report becomes open to discussion.
When reporting the following KPIs, for each: metric name | formula |source of the numbers you use | Fill in the calculated value columns. If I did not give the formula, write the definition you assumed clearly as "ASSUMPTION" so that I can confirm it. Especially mark metrics that can be interpreted differently (profitability, growth).
This step seems small, but at the meeting, "What margin do you call 34%?" ends his discussion from the beginning. Clarity of definition is the basis for confidence in the report.
Visualization and Narrative Balance
AI does not draw the chart itself, but suggests which chart will convey which message best and writes the explanation text under the chart.
Create a management presentation plan for the following set of KPIs: - Suggest the most appropriate chart type for each KPI (line for trend, bar for breakout, indicator for goal-realization) and write the reason - Write a 1-sentence "main message" text below each chart - Suggest the slide order with the logic of "result first, then detail"
Beware: AI may be tempted to overstate a trend to make it look impressive (like "strong rebound"). The tone in the management report should be neutral. Include the instruction each time: "Don't exaggerate, stick to the data, write the negative clearly."
Same Number, Different Report Depending on Target Audience
The same financial truth is expressed in completely different ways depending on who it is presented to. The board wants strategic trend and risk; a bank's collateral and repayment ability; department manager operational detail of his/her unit. If you explicitly tell AI the target audience and that audience's decision question, it can produce three different but consistent reports from the same data.
Produce THREE separate summaries from the following set of KPIs:1) For the board: strategic trend, 3 risks, source labeled, half page2) For the bank: cash generating power, debt service capacity, liquidity ratios3) For the sales manager: sales and margin breakdown only, action-orientedUse the same numbers in all three summaries; just change emphasis and language. Do not exaggerate any numbers; State the negatives honestly in all three.
This approach saves time and maintains consistency: since all three reports come from the same source, there are no conflicts in the meeting. The key rule does not change: the numbers are constant, only the focus of the narrative shifts according to the target.
Tip: Define a “threshold” for each KPI in the management report and have the model say “colour mark those that exceed/below the threshold.” The red/yellow/green logic draws the decision maker's eye to the most critical indicator within seconds.
Mini Cases
Case 1 — The risk behind growth. At a SaaS company, revenue grew 8% quarterly and the team was ready to celebrate. When the AI report puts together that customer loss increased from 4% to 6% in the same period, it was seen that the growth came not with new customers, but with the price increase and the base melted. Management has turned the priority to retention.
Case 2 — Assembly package ready in one hour. A finance manager reduced the 6-hour board report every month to approximately 90 minutes with the KPI template + resource tag prompt. As important as saving time, the source of each number is labeled, so the question in the meeting is "where is this number from?" He was able to answer questions immediately.
Case 3 — Catching up on the hype. In the first draft, AI had softened the 3-point drop in margin as “slight fluctuation.” The principal added the rule "neutral tone, write the negative clearly" and had it reproduced; The second version presented the risk honestly. Lesson: integrity in management reporting trumps fluency.
Common mistakes
- Having the model choose the KPI set. Which indicators to monitor is a strategic decision; you decide.
- Not giving a basis for comparison. Without a target or previous period, the number is meaningless.
- Leaving the source untraceable. “Where is this number from?” If you cannot answer the question, the report loses confidence.
- Allowing for exaggerated tone. A management report is not a sales brochure; It should be neutral and honest.
- Separating the action from the finding. The "Let's do this" suggestion must be based on data.
In summary
- The management report is not a pile of numbers; Presenting each KPI with context, trend and recommended action adds value to the decision maker.
- You determine the KPI set and comparison basis (target/previous period); Do not make it fit the model.
- Making the source of each figure traceable is the basis of the reliability of the report.
- The tone in the management report should be neutral and honest; Print the negative clearly and avoid exaggeration.
- Every action recommendation should be based on a finding; AI also helps with graphic type and narrative layout.
Application task
Select 6-8 KPIs from your own business (or example), add the previous period value for each. Generate a one-page executive summary with a powerful prompt template; Make sure each figure has a source label. Then have the report produced once again using the "neutral tone" rule and compare the two versions. Finally, take one of the actions suggested by the model and evaluate whether it can actually be implemented.
checklist
- [ ] I have determined 6-8 KPIs to monitor.
- [ ] I added a target or previous period comparison for each KPI.
- [ ] I put a source label on each figure.
- [ ] I instructed a neutral, understated tone and printed the negative clearly.
- [ ] I have verified that each action recommendation is based on a finding.
- [ ] I have verified at least two of the key figures against the source.