Loading source
Pulling the file list, source metadata, and syntax-aware rendering for this listing.
Source from repo
Transform data into compelling narratives with effective chart selection, annotation, and insight framing.
Files
Skill
Size
Entrypoint
Format
Open file
Syntax-highlighted preview of this file as included in the skill package.
references/details.md
1# data-storytelling — detailed patterns and worked examples23## Story Frameworks45### Framework 1: The Problem-Solution Story67```markdown8# Customer Churn Analysis910## The Hook1112"We're losing $2.4M annually to preventable churn."1314## The Context1516- Current churn rate: 8.5% (industry average: 5%)17- Average customer lifetime value: $4,80018- 500 customers churned last quarter1920## The Problem2122Analysis of churned customers reveals a pattern:2324- 73% churned within first 90 days25- Common factor: < 3 support interactions26- Low feature adoption in first month2728## The Insight2930[Show engagement curve visualization]31Customers who don't engage in the first 14 days32are 4x more likely to churn.3334## The Solution35361. Implement 14-day onboarding sequence372. Proactive outreach at day 7383. Feature adoption tracking3940## Expected Impact4142- Reduce early churn by 40%43- Save $960K annually44- Payback period: 3 months4546## Call to Action4748Approve $50K budget for onboarding automation.49```5051### Framework 2: The Trend Story5253```markdown54# Q4 Performance Analysis5556## Where We Started5758Q3 ended with $1.2M MRR, 15% below target.59Team morale was low after missed goals.6061## What Changed6263[Timeline visualization]6465- Oct: Launched self-serve pricing66- Nov: Reduced friction in signup67- Dec: Added customer success calls6869## The Transformation7071[Before/after comparison chart]72| Metric | Q3 | Q4 | Change |73|----------------|--------|--------|--------|74| Trial → Paid | 8% | 15% | +87% |75| Time to Value | 14 days| 5 days | -64% |76| Expansion Rate | 2% | 8% | +300% |7778## Key Insight7980Self-serve + high-touch creates compound growth.81Customers who self-serve AND get a success call82have 3x higher expansion rate.8384## Going Forward8586Double down on hybrid model.87Target: $1.8M MRR by Q2.88```8990### Framework 3: The Comparison Story9192```markdown93# Market Opportunity Analysis9495## The Question9697Should we expand into EMEA or APAC first?9899## The Comparison100101[Side-by-side market analysis]102103### EMEA104105- Market size: $4.2B106- Growth rate: 8%107- Competition: High108- Regulatory: Complex (GDPR)109- Language: Multiple110111### APAC112113- Market size: $3.8B114- Growth rate: 15%115- Competition: Moderate116- Regulatory: Varied117- Language: Multiple118119## The Analysis120121[Weighted scoring matrix visualization]122123| Factor | Weight | EMEA Score | APAC Score |124| ----------- | ------ | ---------- | ---------- |125| Market Size | 25% | 5 | 4 |126| Growth | 30% | 3 | 5 |127| Competition | 20% | 2 | 4 |128| Ease | 25% | 2 | 3 |129| **Total** | | **2.9** | **4.1** |130131## The Recommendation132133APAC first. Higher growth, less competition.134Start with Singapore hub (English, business-friendly).135Enter EMEA in Year 2 with localization ready.136137## Risk Mitigation138139- Timezone coverage: Hire 24/7 support140- Cultural fit: Local partnerships141- Payment: Multi-currency from day 1142```143144## Visualization Techniques145146### Technique 1: Progressive Reveal147148```markdown149Start simple, add layers:150151Slide 1: "Revenue is growing" [single line chart]152Slide 2: "But growth is slowing" [add growth rate overlay]153Slide 3: "Driven by one segment" [add segment breakdown]154Slide 4: "Which is saturating" [add market share]155Slide 5: "We need new segments" [add opportunity zones]156```157158### Technique 2: Contrast and Compare159160```markdown161Before/After:162┌─────────────────┬─────────────────┐163│ BEFORE │ AFTER │164│ │ │165│ Process: 5 days│ Process: 1 day │166│ Errors: 15% │ Errors: 2% │167│ Cost: $50/unit │ Cost: $20/unit │168└─────────────────┴─────────────────┘169170This/That (emphasize difference):171┌─────────────────────────────────────┐172│ CUSTOMER A vs B │173│ ┌──────────┐ ┌──────────┐ │174│ │ ████████ │ │ ██ │ │175│ │ $45,000 │ │ $8,000 │ │176│ │ LTV │ │ LTV │ │177│ └──────────┘ └──────────┘ │178│ Onboarded No onboarding │179└─────────────────────────────────────┘180```181182### Technique 3: Annotation and Highlight183184```python185import matplotlib.pyplot as plt186import pandas as pd187188fig, ax = plt.subplots(figsize=(12, 6))189190# Plot the main data191ax.plot(dates, revenue, linewidth=2, color='#2E86AB')192193# Add annotation for key events194ax.annotate(195'Product Launch\n+32% spike',196xy=(launch_date, launch_revenue),197xytext=(launch_date, launch_revenue * 1.2),198fontsize=10,199arrowprops=dict(arrowstyle='->', color='#E63946'),200color='#E63946'201)202203# Highlight a region204ax.axvspan(growth_start, growth_end, alpha=0.2, color='green',205label='Growth Period')206207# Add threshold line208ax.axhline(y=target, color='gray', linestyle='--',209label=f'Target: ${target:,.0f}')210211ax.set_title('Revenue Growth Story', fontsize=14, fontweight='bold')212ax.legend()213```214215## Presentation Templates216217### Template 1: Executive Summary Slide218219```220┌─────────────────────────────────────────────────────────────┐221│ KEY INSIGHT │222│ ══════════════════════════════════════════════════════════│223│ │224│ "Customers who complete onboarding in week 1 │225│ have 3x higher lifetime value" │226│ │227├──────────────────────┬──────────────────────────────────────┤228│ │ │229│ THE DATA │ THE IMPLICATION │230│ │ │231│ Week 1 completers: │ ✓ Prioritize onboarding UX │232│ • LTV: $4,500 │ ✓ Add day-1 success milestones │233│ • Retention: 85% │ ✓ Proactive week-1 outreach │234│ • NPS: 72 │ │235│ │ Investment: $75K │236│ Others: │ Expected ROI: 8x │237│ • LTV: $1,500 │ │238│ • Retention: 45% │ │239│ • NPS: 34 │ │240│ │ │241└──────────────────────┴──────────────────────────────────────┘242```243244### Template 2: Data Story Flow245246```247Slide 1: THE HEADLINE248"We can grow 40% faster by fixing onboarding"249250Slide 2: THE CONTEXT251Current state metrics252Industry benchmarks253Gap analysis254255Slide 3: THE DISCOVERY256What the data revealed257Surprising finding258Pattern identification259260Slide 4: THE DEEP DIVE261Root cause analysis262Segment breakdowns263Statistical significance264265Slide 5: THE RECOMMENDATION266Proposed actions267Resource requirements268Timeline269270Slide 6: THE IMPACT271Expected outcomes272ROI calculation273Risk assessment274275Slide 7: THE ASK276Specific request277Decision needed278Next steps279```280281### Template 3: One-Page Dashboard Story282283```markdown284# Monthly Business Review: January 2024285286## THE HEADLINE287288Revenue up 15% but CAC increasing faster than LTV289290## KEY METRICS AT A GLANCE291292┌────────┬────────┬────────┬────────┐293│ MRR │ NRR │ CAC │ LTV │294│ $125K │ 108% │ $450 │ $2,200 │295│ ▲15% │ ▲3% │ ▲22% │ ▲8% │296└────────┴────────┴────────┴────────┘297298## WHAT'S WORKING299300✓ Enterprise segment growing 25% MoM301✓ Referral program driving 30% of new logos302✓ Support satisfaction at all-time high (94%)303304## WHAT NEEDS ATTENTION305306✗ SMB acquisition cost up 40%307✗ Trial conversion down 5 points308✗ Time-to-value increased by 3 days309310## ROOT CAUSE311312[Mini chart showing SMB vs Enterprise CAC trend]313SMB paid ads becoming less efficient.314CPC up 35% while conversion flat.315316## RECOMMENDATION3173181. Shift $20K/mo from paid to content3192. Launch SMB self-serve trial3203. A/B test shorter onboarding321322## NEXT MONTH'S FOCUS323324- Launch content marketing pilot325- Complete self-serve MVP326- Reduce time-to-value to < 7 days327```328329## Writing Techniques330331### Headlines That Work332333```markdown334BAD: "Q4 Sales Analysis"335GOOD: "Q4 Sales Beat Target by 23% - Here's Why"336337BAD: "Customer Churn Report"338GOOD: "We're Losing $2.4M to Preventable Churn"339340BAD: "Marketing Performance"341GOOD: "Content Marketing Delivers 4x ROI vs. Paid"342343Formula:344[Specific Number] + [Business Impact] + [Actionable Context]345```346347### Transition Phrases348349```markdown350Building the narrative:351• "This leads us to ask..."352• "When we dig deeper..."353• "The pattern becomes clear when..."354• "Contrast this with..."355356Introducing insights:357• "The data reveals..."358• "What surprised us was..."359• "The inflection point came when..."360• "The key finding is..."361362Moving to action:363• "This insight suggests..."364• "Based on this analysis..."365• "The implication is clear..."366• "Our recommendation is..."367```368369### Handling Uncertainty370371```markdown372Acknowledge limitations:373• "With 95% confidence, we can say..."374• "The sample size of 500 shows..."375• "While correlation is strong, causation requires..."376• "This trend holds for [segment], though [caveat]..."377378Present ranges:379• "Impact estimate: $400K-$600K"380• "Confidence interval: 15-20% improvement"381• "Best case: X, Conservative: Y"382```383