Data Storytelling Narrative Builder

Analytics CommunicationData StorytellingBusiness Intelligence

Problem Statement

The goal is to transform raw charts, tables, and analytic outputs into clear, audience-tailored decision narratives. The workflow must interpret quantitative results, highlight what matters, and produce recommendations aligned with the decision context. It must also surface uncertainty, provide necessary caveats, and prepare the user for likely stakeholder questions.

Steps

1

Ingest Inputs

INGEST

Collect the charts, tables, audience type, decision context, and uncertainty factors. Parse the content to understand available metrics, trends, and metadata.

2

Extract Core Insights

EXECUTE

Analyze the visuals to identify key patterns, anomalies, drivers, and implications relevant to the decision context. Summarize insights in plain language.

3

Tailor Narrative to Audience

EXECUTE

Adapt the insight summary into an audience-appropriate narrative that balances clarity, depth, and decision relevance. Adjust tone and vocabulary to match the audience’s technical expertise.

4

Assess Uncertainty and Caveats

EXECUTE

Identify limitations in the data, assumptions, or analysis. Translate uncertainty factors into clear caveats the audience can understand and act on.

5

Craft Recommendations and Q&A

EXECUTE

Provide an explicit recommendation aligned with the decision context and backed by the insights. Prepare anticipated skeptical questions and concise answers.

Prompt Configurations

Analytics Storytelling Draft Prompt

Model: gpt-4oTemp: 0.7
You are an analytics storytelling assistant. Convert the provided charts/tables into a clear, compelling narrative tailored to the specified audience type. Follow these rules: 1) Explain what matters and why, referencing visuals explicitly. 2) Use a tone that is clear, confident, and decision-supportive. 3) Tailor complexity and terminology to the audience expertise (avoid jargon for non-technical audiences). 4) Provide explicit caveats and an uncertainty assessment based only on the provided data—do not invent numbers. 5) Deliver a recommended decision with concise rationale. 6) Include a Q&A section anticipating skeptical or challenging questions and answering them clearly. Only use information from the provided materials.

Example Inputs/Outputs

Input:

Charts: Revenue by region (2021–2024) showing APAC growth +18% YoY, EU flat, NA –3% decline. Audience: Executive. Decision context: Allocate next year's marketing budget. Uncertainty factors: Limited Q4 data, potential currency effects.

Output:

Narrative: APAC continues to be the primary growth engine, expanding 18% YoY. EU remains flat, signaling saturation, while NA shows a modest decline likely linked to competitive pressures. Given the incomplete Q4 data and unknown currency impacts, trends should be interpreted directionally rather than as precise forecasts. Recommendation: Increase marketing investment in APAC where returns are strongest, maintain EU spend with targeted testing, and investigate NA competitiveness before committing incremental funds. Q&A Prep: Q1: Could currency fluctuations be masking NA performance? A: Yes, some portion may be currency-driven, but competitive activity in the region suggests structural factors as well. Q2: Is APAC growth sustainable? A: Based on the 3-year trend line, growth appears stable, though macroeconomic risks should be monitored.