AI for Data Analysis & Decision MakingCharts and insight narratives · Lesson 11 of 16

From analysis to insight narratives

Article · 11 min · 8 min lecture

Video lecture

From analysis to insight narratives

16 chapters · about 8 min · full transcript

Coming soon

Chapter 1 of 16

Insight narratives

  • Situation, Insight, Implication, Action
  • Prompts with guardrails
  • The 'so what' test
  • Audience versions
  • A narrative checker

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

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

  1. Situation: the context and the question. "We asked whether the SUMMER10 discount is worth continuing."
  2. 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."
  3. Implication: what it means for the business. "The discount appears to shift timing and margin rather than create loyal customers."
  4. 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.

  1. An AI draft says 'satisfaction drove repeat orders' but the analysis only shows both rose. What should you do?
  2. Why instruct the AI to use only numbers from the provided tables?
  3. What belongs in the 'Implication' part of the structure?

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.