AI for Data Analysis & Decision MakingCharts and insight narratives · Lesson 11 of 16
From analysis to insight narratives
Video lecture
From analysis to insight narratives
The narrated lecture is in production
Every chapter is scripted and ready. Browse the chapters and read the full transcript now — the video will appear here when it’s published.
Chapters
Transcript of the narration, chapter by chapter.
0:00 Insight narratives
Here's a sentence from a real AI-drafted report: customer satisfaction drove a nine percent increase in repeat orders. Both numbers were real. The word drove was not. Nothing in the analysis showed that one caused the other. In this lecture you'll learn to turn analysis into narratives that drive decisions: the Situation, Insight, Implication, Action structure, prompts with guardrails, the so what test, versions for different audiences, and a checker prompt that catches invented numbers and unsupported causal claims.
0:34 Why it matters
Why does this matter? Because decision-makers rarely read your full analysis. They read the summary. If the summary overclaims, the decision follows the overclaim. AI is an excellent drafting partner here, but it tends toward two failures: bland summaries that list numbers, or confident stories that add causation and even figures that aren't in your tables. Your job is to keep the narrative specific, honest and actionable.
1:03 S-I-I-A
Here's the structure. Situation: the context and the question, for example, we asked whether the SUMMER10 discount is worth continuing. Insight: the key finding with supporting numbers, like discounted orders had lower order values and similar repeat rates. Implication: what it means, like the discount seems to shift timing and margin rather than create loyal customers. Action: the recommendation and next step, like end it in July and run a small holdout if we want stronger evidence. Then one clear line on confidence and the main caveat.
1:41 Guardrails
Now prompting with guardrails. Give the AI the tables and the decision, and ask for a two-hundred-word summary for, say, the marketing director, using Situation, Insight, Implication, Action. Then the rules. Use only numbers from the tables; don't introduce new figures. State the confidence level and the main caveat in one sentence. Avoid causal language unless the tables come from a controlled test. Plain English, no jargon. Without those rules, drafts routinely add plausible numbers, overclaim causation, or bury the recommendation.
2:16 The 'so what' test
Next, the so what test. For every sentence, ask so what? If the answer isn't clear, cut it or connect it to the decision. Traffic from Instagram rose twelve percent, is an observation. Instagram traffic rose twelve percent, but it converts at half the rate of search, so it added little revenue, and we shouldn't shift budget there yet, is a sentence that earns its place. Think of each sentence as paying rent in the reader's attention. If it doesn't pay, it goes.
2:52 Audiences and honesty
Tailor to the audience, but keep facts identical. Executives: one paragraph, decision first. Team leads: key numbers by segment and next steps. Analysts: methods, definitions, limitations and links to code. Ask the AI for each version, then check it didn't change any number while rewriting. And storytelling without spin: include the strongest counter-evidence you found, and explain why your recommendation still holds, or what would change it. Readers trust analysts who show their doubts.
3:24 Example 1: the quarterly note
First example, a simple one. An operations analyst in Dubai asks the AI to draft a quarterly note from four tables. The first draft claims customer satisfaction drove a nine percent increase in repeat orders. The analyst checks: the tables show both rose, but nothing links them. The revised line: repeat orders rose nine percent and satisfaction scores improved; we haven't established whether one caused the other. The recommendation stays clear, and the director isn't misled into over-investing in a single lever.
4:00 Example 2: UAE hotel pricing
Second example, a business case. An analyst at a UAE hotel group drafts a note recommending a weekend rate increase. The checker prompt flags two numbers that don't appear in the tables, because the AI had rounded occupancy into a different figure, and one causal phrase: the event drove occupancy, based on observational data. The corrected note uses the exact figures, says occupancy was higher during the event weekends, and recommends a two-weekend price test at two properties, owned by revenue management, reviewed in six weeks.
4:37 Watch me do it, part 1
Watch me run the checker. I paste my draft and the source tables, and ask four things. One, list every number in the draft and the table cell it comes from, marking any number not in the tables. Two, list every causal phrase, like drove, caused, because of or led to, and say whether the data is from a controlled test; if not, suggest non-causal wording. Three, is the recommendation clear, owned and dated? Four, is the main caveat stated near the top? Only then, return a corrected draft.
5:16 Watch me do it, part 2
The response maps eleven numbers to cells and flags one it can't find. It was a percentage I'd calculated in my head. I recompute it properly and it changes slightly. It lists two causal phrases; one is fine because it refers to our controlled email test, the other I rewrite. And it notes my recommendation has no owner. I add one: the head of e-commerce, by the fifteenth. The final note is shorter, more precise, and much harder to misread.
5:51 Length and format
On length and format: most decision narratives should fit on one screen. Lead with the recommendation for senior readers, put supporting numbers in a short table, and link to the full analysis. Ask the AI for a version that works as a chat message as well as a longer document, because many decisions are actually made from the short version in a chat thread.
6:19 Confidence language
Confidence language deserves one more minute, because it's where narratives quietly go wrong. Agree on a small set of phrases and what they mean: almost certain, likely, uncertain, unlikely. Use ranges where the data supports them. And say whether the uncertainty changes the decision: even at the low end of the range, the campaign pays back, is far more useful than a paragraph of hedges. We'll go deeper on this in module six, but build the habit in every summary you write.
6:55 Measuring narratives
How do you know your narratives work? Decisions get made from the summary without a meeting to explain it. Stakeholders quote your numbers correctly later. Recommendations have owners who actually act by the date. And nobody feels misled when they read the full analysis afterward. That last one is the real test of an honest narrative.
7:19 Common mistakes
Common mistakes. Numbers not traceable to a table. Causal language without causal evidence. Caveats hidden in footnotes, or so many caveats that the important one is lost. Recommendations without owners or dates. Changed numbers between audience versions. And words like proves or guarantees.
7:38 Recap
Recap. Structure narratives as Situation, Insight, Implication, Action, plus one confidence line. Prompt with guardrails: only provided numbers, no unsupported causation, plain English. Apply the so what test, tailor by audience while keeping facts identical, and include counter-evidence. And run a checker pass before sending.
7:58 Try this now
Try this now. Write a two-hundred-word Situation, Insight, Implication, Action summary of a recent analysis with AI help, using the guardrail prompt. Then run the checker prompt on it. Trace every number to its source, fix any causal phrase you can't support, and add one line of counter-evidence and an owner with a date.
Numbers don't speak for themselves
Decision-makers rarely want your full analysis. They want to know what is happening, why it matters, and what to do. An insight narrative connects data to a decision. AI is an excellent drafting partner here, but it tends to produce either bland summaries or overconfident stories. Your job is to keep it specific and honest.
A simple structure: Situation, Insight, Implication, Action
- Situation: the context and the question. "We asked whether the SUMMER10 discount is worth continuing."
- Insight: the key finding with the numbers that support it. "Discounted orders had a lower average order value, and repeat purchase rates were similar to non-discounted orders."
- Implication: what it means for the business. "The discount appears to shift timing and margin rather than create loyal customers."
- Action: the recommendation and next step. "End the discount in July, and run a small holdout test if we want stronger evidence."
Add confidence and caveats as a short, clear line, not buried in footnotes.
Prompting for a narrative
Here are the analysis results (tables below) and the decision we face.
Write a 200-word summary for the marketing director using:
Situation, Insight, Implication, Action.
Rules:
- Use only numbers from the tables; do not introduce new figures.
- State the confidence level and the main caveat in one sentence.
- Avoid causal language unless the tables come from a controlled test.
- Plain English, no jargon.The rules matter. Without them, AI drafts often add plausible-sounding numbers, overclaim causation or bury the recommendation.
The "so what" test
For each sentence, ask "so what?" If the answer is not clear, cut it or connect it to the decision. "Traffic from Instagram rose 12%" becomes "Instagram traffic rose 12%, but it converts at half the rate of search, so it added little revenue; we should not shift budget there yet."
Tailoring to the audience
Ask the AI for versions for different readers:
- Executives: one-paragraph summary, decision first.
- Team leads: key numbers by segment and next steps.
- Analysts: methods, definitions, limitations, code links.
The underlying facts must stay identical across versions; check that the AI hasn't changed numbers when rewriting.
Checking the narrative
Before sending:
- Every number traced back to a table or query.
- No causal claim without causal evidence.
- Caveats proportionate: not hidden, not overwhelming.
- Recommendation clear and actionable.
- Nothing that overstates certainty ("proves", "guarantees").
Worked example: quarterly performance email
An operations analyst in Dubai asks the AI to draft a quarterly performance note from four tables. The first draft claims "customer satisfaction drove a 9% increase in repeat orders". The analyst checks: the tables show both rose, but no analysis links them. The revised line: "Repeat orders rose 9% and satisfaction scores improved; we haven't established whether one caused the other." The recommendation remains clear, and the director is not misled into over-investing in a single lever.
Storytelling without spin
Good narratives are persuasive because they are clear, not because they are one-sided. Include the strongest counter-evidence you found, and explain why your recommendation still holds (or state what would change it). Readers trust analysts who show their doubts.
Length and format
Most decision narratives should fit on one screen. Lead with the recommendation for senior readers, put supporting numbers in a short table, and link to the full analysis. Ask the AI for a version that works as a message in your team's chat tool as well as a longer document; many decisions are made from the short version.
Hands-on: a narrative checker prompt
After drafting, run a second pass that checks the draft against the source tables:
Here is my draft summary and the tables it is based on.
1) List every number in the draft and the table cell it comes from. Mark any number not in the tables.
2) List every causal phrase ("drove", "caused", "because of", "led to") and say whether the tables come
from a controlled test. If not, suggest non-causal wording.
3) Is the recommendation clear, owned and dated? If not, say what is missing.
4) Is the main caveat stated in one sentence near the top?
Return a corrected draft only after listing the issues.One message, three audiences
EXEC (chat, 60 words): Recommendation first, one number, one caveat, decision needed by date.
TEAM LEADS (email, 150 words): Key numbers by segment, what changes for their team, next steps.
ANALYSTS (doc): Methods, definitions, data version, limitations, links to notebook and queries.
Rule: numbers identical across versions; only depth changes.Second worked example: a UAE hotel group's pricing note
An analyst drafts a note recommending a weekend rate increase. The checker flags two numbers that do not appear in the tables (the AI had "rounded" occupancy into a different figure) and one causal phrase ("the event drove occupancy") based on observational data. The corrected note uses the exact figures, says occupancy "was higher during the event weekends", and recommends a two-weekend price test at two properties, owned by revenue management, reviewed in six weeks.
Going further
Create a narrative template for your team (sections, tone, confidence language, a checklist) and provide it to the AI with each request. Combined with a metrics glossary, this makes AI-drafted summaries consistent and much faster to review.
Key takeaways
- Structure narratives as Situation, Insight, Implication, Action, plus a clear confidence line.
- Prompt with rules: only use provided numbers, avoid unsupported causal language, plain English.
- Apply the 'so what' test and tailor versions by audience while keeping facts identical.
- Trace every number, include counter-evidence, and avoid overstating certainty.
Check your understanding
Quick questions to lock in the lesson. They don’t count towards your certificate.
Put it into practice
Write a 200-word Situation-Insight-Implication-Action summary of a recent analysis with AI help. Trace every number back to its source and add one line of counter-evidence.
Enrol for free to save your progress
Reading is always free. Enrol to keep your place, take the final assessment and earn a verifiable certificate.