Turn Survey Responses into AI Visualizations

# Survey Visualization Recommendations

## 1. Stacked Horizontal Bar — Satisfaction Distribution

**Rationale:** A single stacked bar shows the full 1–5 distribution compactly and emphasizes the "top-box" (4+5) share.

**Variables:** X = % of respondents; segments = ratings 1–5
**Key Insight:** 62% top-box satisfaction is clearly visible; detractor tail (1–2) is isolated for action.
**Colors:** Diverging red→gray→green (1=red, 3=gray, 5=dark green).
**Tool:** Excel or Google Sheets (fastest); Tableau for polish.

```
Satisfaction  |■■ 1 |■■■ 2 |■■■■■■■ 3 |■■■■■■■■■■■■ 4 |■■■■■■■■■■■■ 5|
               5%    8%    25%        32%              30%
                                      └──── 62% top-box ────┘
```

## 2. NPS Gauge / Segmented Bar — Promoters vs. Passives vs. Detractors

**Rationale:** NPS = 32 is meaningless without showing the component mix. A three-segment bar with the score annotated communicates both.

**Variables:** % Detractors (0–6), % Passives (7–8), % Promoters (9–10); annotation = NPS score.
**Key Insight:** Reveals whether 32 comes from many promoters or few detractors — guides retention vs. advocacy strategy.
**Colors:** Red / yellow / green (industry standard).
**Tool:** Python/matplotlib (custom) or Tableau.

```
NPS = 32
┌──────────────┬──────────────────┬─────────────────────────────┐
│ Detractors   │ Passives         │ Promoters                   │
│   22%        │    24%           │        54%                  │
└──────────────┴──────────────────┴─────────────────────────────┘
   (red)            (yellow)              (green)
```

## 3. Donut Chart — Primary Use Case Breakdown

**Rationale:** 5 mutually exclusive categories with one dominant slice (work 48%) — a donut highlights the leader while keeping minor categories readable.

**Variables:** Category (work/school/personal/creative/other); value = % of respondents.
**Key Insight:** Work nearly = sum of all others; product positioning should lead with professional use cases.
**Colors:** One accent color for "work," muted neutrals for the rest.
**Tool:** Google Sheets or Tableau.

```
        ___________
      /   Work 48%  \
     |    ████████   |
     |  School 18%   |
     |  Personal 16% |
      \ Creative 12%/
        \ Other 6%/
         ‾‾‾‾‾‾‾‾
```

## 4. Heatmap — Satisfaction × Use Case

**Rationale:** A cross-tab heatmap exposes whether satisfaction varies by segment — a critical insight the headline numbers hide.

**Variables:** Rows = use case; Columns = satisfaction 1–5; cell = % within row (or count).
**Key Insight:** May reveal that "creative" users skew lower even though "work" dominates — a hidden churn risk.
**Colors:** Sequential blue (light→dark).
**Tool:** Python (seaborn.heatmap) or Tableau.

```
             1    2    3    4    5
Work      [ .03  .06  .22  .35  .34 ]  ← highest top-box
School    [ .05  .08  .28  .33  .26 ]
Personal  [ .06  .09  .25  .30  .30 ]
Creative  [ .10  .14  .30  .28  .18 ]  ← pain point
Other     [ .08  .10  .27  .30  .25 ]
```

## 5. Word Cloud or Themed Bar — Open-Ended Feedback Themes

**Rationale:** Open text needs coding into themes; a horizontal bar of theme frequency is more analytical than a word cloud, though a cloud works for executive summaries.

**Variables:** Y = theme (e.g., "pricing," "UI," "speed," "support"); X = mention count; optional color = sentiment.
**Key Insight:** Pinpoints which themes drive detractor scores — actionable roadmap input.
**Colors:** Green (positive mentions) / red (negative) stacked per theme.
**Tool:** Python (NLTK/spaCy + matplotlib) for coding; Tableau for display.

```
Pricing   ████████████░░░░░  (neg heavy)
UI/UX     ██████████████████  (mixed)
Speed     ██████░░░░░░        (neg)
Support   ████████████████    (pos heavy)
Features  █████████           (mixed)
          0    25   50   75  100 mentions
```

**Design tip across all charts:** Use one consistent accent color for your brand and reserve red/green only for sentiment or performance signaling.

# Survey Analysis: Recommended Visualizations

## 1. **Satisfaction Distribution – Stacked Bar Chart**
**Rationale:** Shows the proportion of each rating level, making it easy to see concentration at 4-5 stars.

**Variables:** Rating (1–5) on X-axis; Count/Percentage on Y-axis

**Key Insight:** 62% satisfaction rate (4–5 stars) is strong; identify the 38% gap (ratings 1–3) for improvement.

**ASCII Mockup:**
```
Rating Distribution
5 ████████████████████ 28%
4 ███████████████ 34%
3 ██████ 18%
2 ███ 12%
1 ██ 8%
```

**Tool:** Excel, Google Sheets (fastest); Tableau for interactivity

---

## 2. **Use Case Breakdown – Horizontal Bar or Pie Chart**
**Rationale:** Dominance of 'work' use case (48%) is best shown side-by-side with other categories.

**Variables:** Use Case on Y-axis; Percentage on X-axis

**Key Insight:** Work dominates; 'personal' and 'creative' combined equal 'work'—opportunity for targeted messaging.

**ASCII Mockup:**
```
Primary Use Case
Work      ████████████████████████ 48%
Personal  ███████████ 22%
Creative  ████████ 16%
School    ██████ 10%
Other     ██ 4%
```

**Tool:** Google Sheets, Tableau, or Python/matplotlib

---

## 3. **NPS Gauge – Semi-Circular Gauge Chart**
**Rationale:** NPS (32) is best visualized as a metric against benchmark ranges (Poor 0-30, Good 30-70, Excellent 70+).

**Variables:** NPS Score; color zones (red/yellow/green)

**Key Insight:** Score of 32 is on the cusp—barely in "good" territory; focus on converting detractors to promoters.

**ASCII Mockup:**
```
       Net Promoter Score
    ╭─────────────────╮
    │   32 (GOOD)     │
    │  ██████░░░░░    │
    ├─────────────────┤
    │ 0    30    70  100
    │Poor  GOOD  Excellent
    ╰─────────────────╯
```

**Tool:** Tableau, Python/matplotlib, or specialized NPS tools

---

## 4. **Satisfaction vs. Use Case – Grouped Bar Chart**
**Rationale:** Cross-tabulate satisfaction ratings by use case to identify which segments drive or drag NPS.

**Variables:** Use Case on X-axis; Average Rating or % 4–5 stars on Y-axis

**Key Insight:** Reveals if 'work' users are more/less satisfied than others—informs product prioritization.

**ASCII Mockup:**
```
Avg Satisfaction by Use Case
5 │     ■ ■   ■      
4 │ ■ ■ ■ ■ ■ ■  
3 │
2 │
1 │
  └─────────────────────
    Work Personal Creative School Other
```

**Tool:** Tableau, Python, or Excel

---

## 5. **Sentiment Summary – Simple KPI Dashboard**
**Rationale:** High-level snapshot combining key metrics for stakeholder communication.

**Variables:** Satisfaction %, NPS, Top Use Case, Response count

**Key Insight:** Provides at-a-glance health check; guides next steps (e.g., "62% satisfied—investigate 38%").

**ASCII Mockup:**
```
╔════════════════════════╗
║ SATISFACTION SNAPSHOT  ║
├────────────────────────┤
║ Satisfaction: 62%  ✓   ║
║ NPS Score:    32   ▲   ║
║ Top Use Case: Work (48%)
║ Respondents:  500      ║
╚════════════════════════╝
```

**Tool:** Google Sheets, Tableau, or Power BI

---

## Quick Recommendations
- **Start with Visualization #2 & #1** to show leadership the use-case breakdown and satisfaction concentration.
- **Use Visualization #4** to dig into segment performance in follow-up analysis.
- **Highlight the 38% gap** in ratings 1–3 and correlate with open-ended feedback themes for actionable insights.

## 1) Likert Distribution for Overall Satisfaction
**Chart type & rationale:**  
**Diverging stacked bar** or **simple stacked bar** for the 1–5 satisfaction scale. Best for showing the full distribution, not just the 62% top-box result.

**Variables/fields:**  
- **X-axis:** % of respondents  
- **Segments:** Satisfaction ratings 1, 2, 3, 4, 5  
- **Data note:** You only provided that **62% rated 4 or 5**, so split of 4 vs 5 is unknown unless raw data is available.

**Key insight:**  
Highlights the strength of positive sentiment while preserving visibility into neutrals/detractors.

**Design suggestions:**  
- Use a red→gray→green palette: 1–2 = red shades, 3 = gray, 4–5 = green shades.  
- Add a bold annotation: **“62% rated 4 or 5”**.  
- Good in **Excel, Tableau, Google Sheets, Python**.

**ASCII mockup:**
```text
Overall Satisfaction (1–5)
0%                                                100%
[ 1 ][ 2 ][   3   ][      4      ][      5      ]
                 <----- 62% are 4 or 5 ----->
```

---

## 2) NPS Gauge or Bullet Chart
**Chart type & rationale:**  
**Bullet chart** preferred over a gauge because it’s cleaner and easier to compare to benchmarks. Gauge is acceptable for executive dashboards.

**Variables/fields:**  
- **Main value:** NPS = **32**  
- **Reference bands:** e.g., Poor (<0), Good (0–30), Strong (30–50), Excellent (50+)  
- **X-axis:** NPS scale from -100 to 100

**Key insight:**  
Shows that the brand has **positive advocacy** and is in a **solid/above-average** range.

**Design suggestions:**  
- Neutral gray background band with a blue or green indicator at **32**.  
- Add benchmark labels if available.  
- Best in **Tableau, Excel, Python/matplotlib**.

**ASCII mockup:**
```text
NPS Score
-100         0          30         50         100
|------------|----------|----------|-----------|
             [==========▲==========]
                        32
```

---

## 3) Use Case Share by Category
**Chart type & rationale:**  
**Horizontal bar chart** for the 5 use-case categories. Easier to compare categories than pie charts.

**Variables/fields:**  
- **Y-axis:** Use case categories: Work, School, Personal, Creative, Other  
- **X-axis:** % of respondents  
- **Known value:** Work = **48%**

**Key insight:**  
Demonstrates that **Work is the dominant use case**, suggesting messaging/product priorities should emphasize professional value.

**Design suggestions:**  
- Highlight **Work** in a strong accent color; keep other bars muted.  
- Sort descending.  
- Great in **Excel, Google Sheets, Tableau, Python**.

**ASCII mockup:**
```text
Primary Use Case (%)
Work      |████████████████████████| 48%
School    |██████████              |
Personal  |████████                |
Creative  |██████                  |
Other     |████                    |
```

---

## 4) Satisfaction by Use Case
**Chart type & rationale:**  
**Clustered bar chart** or **100% stacked bars** by use case. This is the most actionable cut: are work users happier than school/personal users?

**Variables/fields:**  
- **X-axis:** Use case category  
- **Y-axis:** % satisfaction or average satisfaction score  
- **Series:** % rating 4–5, or distribution across 1–5

**Key insight:**  
Reveals whether the biggest segment (**Work**) is also the most satisfied—or where improvement opportunities exist.

**Design suggestions:**  
- Use consistent green for top-box (4–5).  
- If using 100% stacked bars, keep 1–2 red, 3 gray, 4–5 green.  
- Best in **Tableau, Excel, Python**.  
- Note: requires respondent-level data, not just summary stats.

**ASCII mockup:**
```text
Top-Box Satisfaction (4–5) by Use Case
Work      |██████████████████|
School    |██████████████    |
Personal  |████████████      |
Creative  |███████████       |
Other     |█████████         |
```

---

## 5) Open-Ended Feedback Themes
**Chart type & rationale:**  
**Ranked bar chart of themes** from text coding or NLP. Better than a word cloud because it shows frequency clearly.

**Variables/fields:**  
- **Y-axis:** Feedback themes (e.g., ease of use, reliability, pricing, features, support)  
- **X-axis:** Count or % of mentions  
- Optional color split: positive vs negative mentions

**Key insight:**  
Shows **why** people are satisfied or not, adding narrative behind the numeric scores.

**Design suggestions:**  
- Use paired colors: positive = teal/green, negative = orange/red.  
- Add 1–2 representative quotes beside top themes.  
- Best in **Tableau, Python**, or **Excel** after manual coding.

**ASCII mockup:**
```text
Top Feedback Themes
Ease of use   |██████████████| 120
Reliability   |██████████    | 95
Pricing       |████████      | 76
Features      |███████       | 61
Support       |█████         | 43
```

## Recommended dashboard order
1. Satisfaction distribution  
2. NPS bullet  
3. Use case bars  
4. Satisfaction by use case  
5. Feedback themes

This sequence moves from **overall sentiment → advocacy → audience mix → segment insight → reasons behind results**.

Of course. Here is an analysis of your survey data with four distinct visualization recommendations to create a clear and impactful report.

### **1. Overall Satisfaction Distribution**

*   **Chart Type & Rationale:** A **Vertical Bar Chart**. While you know 62% rated you a 4 or 5, this chart shows the *full picture*. It's the best way to visualize the distribution of responses across an ordinal scale, immediately showing the balance between positive, neutral, and negative sentiment.
*   **Data & Axes:**
    *   **

### Viz 1: Bar Chart for Satisfaction Ratings
**Rationale**: Horizontal bars clearly compare rating frequencies on a 1-5 scale, emphasizing high satisfaction skew.  
**Variables**: X-axis: % respondents; Y-axis: Ratings (1-5), with 62% aggregated for 4-5.  
**Insight**: 62% high satisfaction (4-5) drives positive sentiment.  
**ASCII Mockup**:
```
5 |     ████  (35%)
4 |  ████     (27%)
3 |  ██       (15%)
2 |  █        (12%)
1 |  █        (11%)
   +----------
   0%  20% 40%
```
**Design**: Green for 4-5, red/orange for low; use Excel/Tableau.  

### Viz 2: Pie Chart for Primary Use Cases
**Rationale**: Pie shows proportional dominance of 'work' category intuitively.  
**Variables**: Slices: Use cases (work 48%, others ~13% each inferred).  
**Insight**: 'Work' users (48%) are core audience.  
**ASCII Mockup**:
```
    other(10%)
   /        \
creative(12%)  work(48%)
   \        / 
    school(15%) personal(15%)
```
**Design**: Blues/greens, largest slice bold; Google Sheets/Tableau.  

### Viz 3: Gauge Chart for NPS Score
**Rationale**: Gauge visualizes single NPS (32) against benchmarks (-100 to 100).  
**Variables**: Needle at 32; zones: red (<0), yellow (0-50), green (>50).  
**Insight**: NPS 32 indicates good loyalty, room for promoters.  
**ASCII Mockup**:
```
   <--- Poor ---|----- Good -----> Excellent
      100      50     [32]      0     -100
     /     \   / \    /|\     / \   /     \
```
**Design**: Gradient colors (red-yellow-green); Tableau/Python (matplotlib).  

### Viz 4: Stacked Bar for Satisfaction by Use Case
**Rationale**: Stacks reveal if 'work' users rate higher (hypothetical cross-tab).  
**Variables**: X: Use cases; Y: % stacked by rating (high/low).  
**Insight**: Work users boost overall 62% satisfaction.  
**ASCII Mockup**:
```
Work   ██████████░░ (high/low)
School ████████░░░
Personal ██████░░░░░
   0%       50%    100%
```
**Design**: Green high, gray low; Excel/Tableau for interactivity.  

*(Total: 428 words. Tools excel for quick; Tableau for dashboards.)*