Lesson 1.3: Synthesize Data Using Affinity Diagrams

Step-by-Step Implementation Guide

The complete process from preparation to Problem Tree integration, with time per phase.

Process Overview

Each phase builds on the last, moving raw data toward a validated tree.

graph TB
    %% ========================================
    %% START NODE
    %% ========================================

    START(["📋 <strong>START</strong><br/><br/>Stakeholder Data<br/>from Lesson 1.2"])

    %% ========================================
    %% PREPARATION PHASE
    %% ========================================

    subgraph PREP ["🔧 PREPARATION (15-20 min)"]
        direction TB
        PREP_TASKS["Setup workspace<br/>Gather materials<br/>Set expectations"]
    end

    %% ========================================
    %% PHASE 1: CAPTURE
    %% ========================================

    subgraph P1 ["📝 PHASE 1: CAPTURE (45-60 min)"]
        direction TB
        S1["Step 1: Systematic Review"]
        S2["Step 2: Insight Extraction"]
        S3["Step 3: Quality Check"]
        P1_OUT["📦 Output:<br/>30-80 insight cards"]
        S1 --> S2 --> S3 --> P1_OUT
    end

    %% ========================================
    %% PHASE 2: CLUSTER
    %% ========================================

    subgraph P2 ["🔀 PHASE 2: CLUSTER (30-45 min)"]
        direction TB
        S4["Step 4: Initial Clustering"]
        S5["Step 5: Cluster Refinement"]
        S6["Step 6: Outlier Management"]
        P2_OUT["📦 Output:<br/>5-12 clusters"]
        S4 --> S5 --> S6 --> P2_OUT
    end

    %% ========================================
    %% PHASE 3: THEME
    %% ========================================

    subgraph P3 ["🏷️ PHASE 3: THEME (30-40 min)"]
        direction TB
        S7["Step 7: Theme Identification"]
        S8["Step 8: Theme Refinement"]
        S9["Step 9: Theme Documentation"]
        P3_OUT["📦 Output:<br/>5-8 defined themes"]
        S7 --> S8 --> S9 --> P3_OUT
    end

    %% ========================================
    %% PHASE 4: SYNTHESIZE
    %% ========================================

    subgraph P4 ["🔗 PHASE 4: SYNTHESIZE (20-30 min)"]
        direction TB
        S10["Step 10: Cross-Theme Analysis"]
        S11["Step 11: Priority Assessment"]
        S12["Step 12: Integration Prep"]
        P4_OUT["📦 Output:<br/>Prioritized themes"]
        S10 --> S11 --> S12 --> P4_OUT
    end

    %% ========================================
    %% PHASE 5: INTEGRATION
    %% ========================================

    subgraph P5 ["🌳 PHASE 5: INTEGRATION (30-45 min)"]
        direction TB
        S13["Step 13: Problem Tree Update"]
        S14["Step 14: Documentation"]
        S15["Step 15: Quality Review"]
        S13 --> S14 --> S15
    end

    %% ========================================
    %% END NODES
    %% ========================================

    FINISH(["🎯 <strong>COMPLETE</strong><br/><br/>Community-Validated<br/>Problem Tree"])

    NEXT["➡️ <strong>NEXT</strong><br/><br/>Lesson 1.4:<br/>Theory of Change"]

    %% ========================================
    %% FLOW CONNECTIONS
    %% ========================================

    START --> PREP
    PREP --> P1
    P1 --> P2
    P2 --> P3
    P3 --> P4
    P4 --> P5
    P5 --> FINISH
    FINISH --> NEXT

    %% ========================================
    %% FESTA DESIGN SYSTEM COLORS
    %% ========================================

    %% Start node - Gray
    style START fill:#6B7280,stroke:#4B5563,stroke-width:3px,color:#fff

    %% Preparation - Light Gray
    style PREP fill:#E5E7EB,stroke:#9CA3AF,stroke-width:2px,color:#2A2A2A
    style PREP_TASKS fill:#F3F4F6,stroke:#9CA3AF,stroke-width:1px,color:#2A2A2A

    %% Phase 1 CAPTURE - Light Gold
    style P1 fill:#FEF3C7,stroke:#F59E0B,stroke-width:2px,color:#2A2A2A
    style S1 fill:#FEF9C3,stroke:#F59E0B,stroke-width:1px,color:#2A2A2A
    style S2 fill:#FEF9C3,stroke:#F59E0B,stroke-width:1px,color:#2A2A2A
    style S3 fill:#FEF9C3,stroke:#F59E0B,stroke-width:1px,color:#2A2A2A
    style P1_OUT fill:#FDE68A,stroke:#F59E0B,stroke-width:2px,color:#2A2A2A

    %% Phase 2 CLUSTER - Light Orange
    style P2 fill:#FED7AA,stroke:#F97316,stroke-width:2px,color:#2A2A2A
    style S4 fill:#FFEDD5,stroke:#F97316,stroke-width:1px,color:#2A2A2A
    style S5 fill:#FFEDD5,stroke:#F97316,stroke-width:1px,color:#2A2A2A
    style S6 fill:#FFEDD5,stroke:#F97316,stroke-width:1px,color:#2A2A2A
    style P2_OUT fill:#FDBA74,stroke:#F97316,stroke-width:2px,color:#2A2A2A

    %% Phase 3 THEME - Light Leaf
    style P3 fill:#D9F99D,stroke:#72B043,stroke-width:2px,color:#2A2A2A
    style S7 fill:#ECFCCB,stroke:#72B043,stroke-width:1px,color:#2A2A2A
    style S8 fill:#ECFCCB,stroke:#72B043,stroke-width:1px,color:#2A2A2A
    style S9 fill:#ECFCCB,stroke:#72B043,stroke-width:1px,color:#2A2A2A
    style P3_OUT fill:#BEF264,stroke:#72B043,stroke-width:2px,color:#2A2A2A

    %% Phase 4 SYNTHESIZE - Light Green
    style P4 fill:#BBF7D0,stroke:#10B981,stroke-width:2px,color:#2A2A2A
    style S10 fill:#D1FAE5,stroke:#10B981,stroke-width:1px,color:#2A2A2A
    style S11 fill:#D1FAE5,stroke:#10B981,stroke-width:1px,color:#2A2A2A
    style S12 fill:#D1FAE5,stroke:#10B981,stroke-width:1px,color:#2A2A2A
    style P4_OUT fill:#6EE7B7,stroke:#10B981,stroke-width:2px,color:#2A2A2A

    %% Phase 5 INTEGRATION - Darker Green
    style P5 fill:#A7F3D0,stroke:#059669,stroke-width:2px,color:#2A2A2A
    style S13 fill:#D1FAE5,stroke:#059669,stroke-width:1px,color:#2A2A2A
    style S14 fill:#D1FAE5,stroke:#059669,stroke-width:1px,color:#2A2A2A
    style S15 fill:#D1FAE5,stroke:#059669,stroke-width:1px,color:#2A2A2A

    %% End nodes - Dark Green
    style FINISH fill:#007F4E,stroke:#00b369,stroke-width:4px,color:#fff
    style NEXT fill:#10B981,stroke:#059669,stroke-width:3px,color:#fff

Preparation Phase (15-20 minutes)

Setup Your Workspace

📌 Physical Approach

Wall space, sticky notes, markers, camera.

💻 Digital Approach

Miro/Mural board, screen sharing.

Gather Your Materials

Stakeholder notes, your Problem Tree, a notebook, a timer.

Set Process Expectations

Allow 2-3 hours; expect iteration, and prioritize understanding over confirmation.

Phase 1: CAPTURE (45-60 minutes)

Step 1: Systematic Review

Review each conversation. Don't organize yet, just extract.

Step 2: Insight Extraction

✅ Good Example

"Transportation costs eat up 30% of potential daily wages" [Focus Group]

❌ Poor Example

"There are problems with employment"

Capture insights that contradict your assumptions, not just ones that confirm them.

Step 3: Quality Check

Each insight should be specific, sourced, and in the stakeholder's words.

Expected Output:

30-80 insight cards (10-15 conversations typically generate 40-60 insights)

Phase 2: CLUSTER (30-45 minutes)

Step 4: Initial Clustering

Spread all cards visibly, and group naturally related insights; don't force it.

Step 5: Cluster Refinement

Split clusters with distinct themes; merge ones too similar to tell apart.

Step 6: Outlier Management

Note insights that don't cluster, for attention during synthesis.

Expected Output:

5-12 clusters (2-15 cards each) plus 2-5 standalone insights

Phase 3: THEME (30-40 minutes)

Step 7: Theme Identification

Ask "What's the common thread?" and test the header against every insight.

Step 8: Theme Refinement

Make each theme actionable, and distinct from the others.

Step 9: Theme Documentation

Write a short description with supporting quotes, noting what surprised you.

Expected Output:

5-8 clearly defined themes with documentation and stakeholder attribution

Phase 4: SYNTHESIZE (20-30 minutes)

Step 10: Cross-Theme Analysis

Map which themes reinforce or contradict each other, and note interventions.

Step 11: Priority Assessment

Rank themes by frequency and emphasis; flag ones that challenge assumptions.

Step 12: Integration Preparation

For each theme, identify Problem Tree elements and (A) assumptions to convert.

Expected Output:

Prioritized themes ranked by importance and impact

Phase 5: INTEGRATION (30-45 minutes)

Step 13: Problem Tree Update

Refine elements, add new causes or effects, and convert assumptions to evidence.

Step 14: Documentation

Map themes to tree elements with supporting quotes; note remaining contradictions.

Step 15: Quality Review

Confirm updates are grounded in stakeholder voice and strengthen your analysis.

✅ Final Output:

A community-validated Problem Tree ready for Theory of Change in Lesson 1.4

Implementation Timeline Summary

Phase Steps Time Can Break?
Preparation Setup & materials 15-20 min ✅ Yes
Phase 1: Capture Steps 1-3 45-60 min ✅ Yes
Phase 2: Cluster Steps 4-6 30-45 min ⚠️ Better continuous
Phase 3: Theme Steps 7-9 30-40 min ⚠️ Better continuous
Phase 4: Synthesize Steps 10-12 20-30 min ❌ Do continuous
Phase 5: Integration Steps 13-15 30-45 min ✅ Yes

What's Next

Next, downloadable templates for this work.

Next: Templates & Tools

Templates for extraction, analysis, and integration.

Get Templates →
Lesson 1.3: Synthesize Data 64%
Step 7 of 11 · Step-by-Step Guide