Visualization Choice & Reporting

Workflow

Copy this checklist and track your progress:

Visualization Choice & Reporting Progress:
- [ ] Step 1: Clarify question and profile data
- [ ] Step 2: Select visualization type
- [ ] Step 3: Design effective chart
- [ ] Step 4: Narrate insights and actions
- [ ] Step 5: Validate and deliver

Step 1: Clarify question and profile data

Define the question you're answering (What's the trend? How do X and Y compare? What's the distribution? What drives Z? What's the composition?). Profile your data: type (categorical, numerical, temporal, geospatial), granularity (daily, user-level, aggregated), size (10 rows, 10K, 10M), dimensions (1D, 2D, multivariate). See Question-Data Profiling.

Step 2: Select visualization type

Match question type to chart family using Chart Selection Guide. Consider data size (small → tables, medium → standard charts, large → heatmaps/binned), number of series (1-3 → standard, 4-10 → small multiples, 10+ → interactive/aggregated), and audience expertise (executives → simple with insights, analysts → detailed exploration).

Step 3: Design effective chart

For simple cases → Apply Design Checklist (clear title, labeled axes, legend if needed, annotations, accessible colors). For complex cases (multivariate, dashboards, interactive) → Study resources/methodology.md for advanced techniques (small multiples, layered charts, dashboard layout, interaction patterns).

Step 4: Narrate insights and actions

Lead with insight headline ("Revenue up 30% YoY driven by Enterprise segment"), annotate key patterns (arrows, labels, shading), provide context (vs benchmark, target, previous), interpret meaning ("Suggests product-market fit in Enterprise"), recommend actions ("Double down on Enterprise sales hiring"). See Narrative Framework.

Step 5: Validate and deliver

Self-assess using resources/evaluators/rubric_visualization_choice_reporting.json. Check: Does chart answer the question clearly? Are insights obvious at a glance? Are next actions clear? Create visualization-choice-reporting.md with question, data summary, visualization spec, narrative, and actions. See Delivery Format.

Question-Data Profiling

Question Types → Chart Families

Data Type → Encoding Considerations

• Categorical (product, region, status): Use position, color hue, shape. Bar length better than pie angle for accuracy.
• Numerical (revenue, count, score): Use position, length, size. Prefer linear scales; use log only when spanning orders of magnitude.
• Temporal (date, timestamp): Always use consistent intervals. Annotate events. Show seasonality if relevant.
• Geospatial (lat/lon, region): Use maps for absolute location; use tables/charts if geography not central to insight.

Chart Selection Guide

Design Checklist

Essential Elements

• Insight headline title: Not "Revenue by Month" but "Revenue Up 30% YoY, Driven by Enterprise"
• Clear axis labels with units: "Revenue ($M)", "Month (2024)", not just "Revenue", "Date"
• Legend if multiple series: Position near chart, use direct labels on lines when possible
• Annotations for key points: Arrows, labels, shading for important events/patterns
• Source and timestamp: "Source: Analytics DB, as of 2024-11-14" builds trust

Perceptual Best Practices

• Start Y-axis at zero for bar/column charts (to avoid exaggerating differences)
• Use position over angle/area (bar > pie for accuracy, scatter > bubble when size isn't critical)
• Colorblind-safe palette: Avoid red-green only; use blue-orange or add patterns
• Limit colors to 5-7 distinct hues (more requires legend lookup, slows comprehension)
• Use pre-attentive attributes (color, size, position) to highlight signal, not decoration

Declutter

• Remove chart junk: No 3D, no gradients, no heavy gridlines, no background images
• Mute non-data ink: Light gray gridlines, thin axes, subtle colors for reference lines
• Use white space: Don't cram; let data breathe

Accessibility

• Alt text describing insight: "Line chart showing revenue grew from $2M to $2.6M (30% increase) from Q1 to Q4 2024, with Enterprise segment contributing 80% of growth."
• Sufficient contrast: Text readable, lines distinguishable
• Patterns in addition to color for critical distinctions (dashed/solid lines, hatched fills)

Narrative Framework

Structure: Headline → Pattern → Context → Meaning → Action

1. Headline (one sentence, insight-first):

• Not: "This chart shows monthly revenue."
• But: "Revenue grew 30% YoY, driven by Enterprise segment."

2. Pattern (what do you see?):

• "Q1-Q2 flat at $2M/month, then steady climb to $2.6M in Q4."
• "Enterprise segment grew 120% while SMB declined 10%."

3. Context (compared to what?):

• "vs target: 15% above plan"
• "vs last year: Q4 2023 was $2.0M, now $2.6M"
• "vs industry: Our 30% growth vs 10% industry average"

4. Meaning (why does it matter?):

• "Suggests product-market fit in Enterprise; SMB churn indicates pricing mismatch."
• "If sustained, Q1 2025 could hit $3M/month."

5. Action (what should we do?):

• "Prioritize: Hire 2 Enterprise AEs, launch SMB annual plans to reduce churn."
• "Monitor: Enterprise win rate, SMB churn by plan type."

Example Full Narrative:

Headline: Enterprise revenue up 120% YoY while SMB declined 10%, resulting in overall 30% growth.

Pattern: Revenue grew from $2M/month (Q1) to $2.6M (Q4). Enterprise segment contributed $1.5M in Q4 (up from $680K in Q1), while SMB dropped from $1.3M to $1.1M.

Context: Total revenue 15% above plan. Enterprise growth (120%) far exceeds industry average (25%). SMB churn rate doubled from 5% to 10% in Q3-Q4.

Meaning: Strong product-market fit in Enterprise; SMB pricing or feature set may be misaligned. Enterprise is now 58% of revenue vs 34% in Q1, reducing diversification.

Actions:

1. Prioritize: Hire 2 Enterprise AEs for Q1, double down on Enterprise playbook
2. Fix: Launch SMB annual plans (Q1) to reduce churn; interview churned SMB customers to identify gaps
3. Monitor: Enterprise win rate, SMB churn by plan type, revenue concentration risk

Delivery Format

Create visualization-choice-reporting.md with these sections:

1. Question: The question you're answering with data (e.g., "How has revenue trended over the past year?")

2. Data Summary: Source, time period, granularity, dimensions, size (e.g., "Analytics DB, Jan-Dec 2024, monthly, revenue by segment, 24 rows")

3. Visualization:

• Chart type selected (e.g., "Multi-line chart with annotations")
• Rationale (why this chart? question type, data structure, chart advantages)
• Design decisions (Y-axis scale, labels, annotations, colors)
• Chart specification (embed image, code, or detailed spec with axes, series, annotations)

4. Narrative: (Headline → Pattern → Context → Meaning → Action structure from above)

• Headline: Insight-first one-liner
• Pattern: What you see
• Context: vs benchmark/target/history
• Meaning: Why it matters
• Actions: What to do next

5. Validation: Self-check with rubric (Clarity ✓, Accuracy ✓, Insight ✓, Actionability ✓, Accessibility ✓)

6. Appendix (optional): Raw data, alternatives considered, statistical tests, assumptions

See resources/template.md for full template with examples.

Common Mistakes

Chart Selection Errors

❌ Pie chart for >5 categories: Hard to compare angles accurately ✓ Use horizontal bar chart: Position on common scale is more accurate

❌ Line chart for categorical data: Implies continuity that doesn't exist (e.g., revenue by product) ✓ Use bar chart: Discrete categories

❌ 3D charts: Perspective distorts values, adds no information ✓ Use 2D with color/size: Clearer, more accurate

Design Mistakes

❌ Y-axis doesn't start at zero (bar chart): Exaggerates differences ✓ Start at zero for bar/column: Accurate visual proportion

❌ Dual Y-axes with different scales: Misleading correlations ✓ Use small multiples or index to 100: Compare shapes, not scales

❌ Rainbow color scheme: Not colorblind-safe, no perceptual ordering ✓ Sequential (light→dark) or diverging (blue→white→red) palette

Narrative Failures

❌ Title: "Revenue by Month": Descriptive, not insightful ✓ "Revenue up 30% YoY, driven by Enterprise": Insight-first

❌ No context: "Revenue is $2.6M" (vs what?) ✓ Add benchmark: "Revenue $2.6M, 15% above $2.25M target"

❌ Pattern without meaning: "Revenue increased" (so what?) ✓ Interpret: "Revenue up 30%, suggests Enterprise product-market fit, informs 2025 hiring plan"

❌ No actions: Ends with "interesting pattern" ✓ Recommend: "Hire 2 Enterprise AEs, investigate SMB churn"

Resources

• Simple cases: Use resources/template.md for question profiling → chart selection → narrative
• Complex cases: Study resources/methodology.md for dashboards, small multiples, interactive visualizations, advanced chart types
• Self-assessment: resources/evaluators/rubric_visualization_choice_reporting.json

Further reading:

• "Storytelling with Data" by Cole Nussbaumer Knaflic (chart choice, decluttering, narrative)
• "The Visual Display of Quantitative Information" by Edward Tufte (principles, chart junk, data-ink ratio)
• "Show Me the Numbers" by Stephen Few (dashboard design, perceptual principles)