Data Visualization Skill

---
skill: 'data-visualization'
version: '2.0.0'
updated: '2025-12-31'
category: 'documentation'
complexity: 'intermediate'
prerequisite_skills: []
composable_with:
  - 'financial-modeling'
  - 'metrics-analytics'
  - 'document-structure'
  - 'technical-writing'
---

# Data Visualization Skill

## Overview
Expertise in creating clear, impactful visualizations for metrics, comparisons, and trends in the FTE+AI documentation.

## Visualization Types

### For Comparisons
**Bar Charts**
- Vendor costs vs. AI costs
- Before/after productivity metrics
- Tool comparison scores

**Side-by-Side Tables**
```markdown
| Metric | Before AI | After AI | Change |
|--------|-----------|----------|--------|
| Weekly cost | $10,000 | $2,500 | -75% |
| Delivery time | 2 weeks | 3 days | -78% |
| Quality score | 85% | 96% | +13% |
```

### For Trends Over Time
**Line Charts** (described for implementation)
- Cost savings accumulation
- Productivity improvements
- Adoption rates

**Timeline Diagrams**
```markdown
## Implementation Timeline

**Q1 2024**
- Pilot program launch
- Team training (2 weeks)
- Initial tool integration

**Q2 2024**
- Full rollout
- Vendor contract renegotiation
- Results measurement begins

**Q3 2024**
- Optimization phase
- Scaling to additional teams
```

### For Hierarchies and Flows
**Decision Trees**
```markdown
Should you replace this vendor with AI?

└─ Is the work repetitive? 
   ├─ YES → High AI potential
   │  └─ Is data/examples available?
   │     ├─ YES → ✅ Strong candidate
   │     └─ NO → Train/prepare data first
   └─ NO → Lower AI potential
      └─ Does it require creativity?
         ├─ YES → Consider AI augmentation
         └─ NO → Evaluate case-by-case
```

**Process Flows**
```markdown
### AI-Augmented Code Review Workflow

1. Developer submits PR
   ↓
2. AI pre-review (30 seconds)
   ├─ Auto-approve minor changes
   └─ Flag issues for human review
   ↓
3. Human reviewer (only complex items)
   ↓
4. Approval & merge

**Time saved:** 60% reduction in review time
```

### For Proportions
**Pie Chart Data** (as tables)
```markdown
## Time Allocation: Before vs. After AI

### Before AI
| Activity | Hours/Week | Percentage |
|----------|------------|------------|
| Coding | 20 | 50% |
| Code review | 10 | 25% |
| Documentation | 6 | 15% |
| Debugging | 4 | 10% |

### After AI
| Activity | Hours/Week | Percentage |
|----------|------------|------------|
| Coding | 24 | 60% |
| Code review | 4 | 10% |
| Documentation | 2 | 5% |
| Strategy/Innovation | 10 | 25% |
```

### For Relationships
**Matrix Diagrams**
```markdown
## AI Tool Selection Matrix

|  | Cost | Ease of Use | Accuracy | Speed |
|--|------|-------------|----------|-------|
| **GitHub Copilot** | ⭐⭐⭐ | ⭐⭐⭐⭐⭐ | ⭐⭐⭐⭐ | ⭐⭐⭐⭐⭐ |
| **ChatGPT Plus** | ⭐⭐⭐⭐ | ⭐⭐⭐⭐⭐ | ⭐⭐⭐⭐⭐ | ⭐⭐⭐⭐ |
| **Claude Pro** | ⭐⭐⭐⭐ | ⭐⭐⭐⭐ | ⭐⭐⭐⭐⭐ | ⭐⭐⭐⭐ |
| **Custom Model** | ⭐⭐ | ⭐⭐ | ⭐⭐⭐⭐⭐ | ⭐⭐⭐ |

⭐⭐⭐⭐⭐ = Excellent | ⭐ = Poor
```

## Markdown Visualization Techniques

### Progress Indicators
```markdown
**Implementation Progress:**

Setup [████████████████████] 100%
Training [████████████░░░░░░░░] 60%
Deployment [████░░░░░░░░░░░░░░░░] 20%
```

### Scorecard Format
```markdown
## Vendor Replacement Scorecard

| Category | Score | Notes |
|----------|-------|-------|
| 💰 Cost Savings | 9/10 | 70% reduction achieved |
| ⚡ Speed | 8/10 | 5x faster delivery |
| 🎯 Quality | 10/10 | Zero defects last quarter |
| 😊 Team Satisfaction | 9/10 | 4.5/5 survey rating |
| 🔒 Risk Reduction | 8/10 | Full IP ownership now |

**Overall Score: 8.8/10** ✅ Highly Successful
```

### Color Coding with Emojis
```markdown
| Metric | Status | Value |
|--------|--------|-------|
| API Latency | 🟢 Excellent | < 100ms |
| Cost per Query | 🟡 Moderate | $0.02 |
| Error Rate | 🟢 Excellent | 0.1% |
| Adoption | 🟡 Growing | 65% |
```

Legend: 🟢 Good | 🟡 Moderate | 🔴 Needs Attention

### Comparison Arrows
```markdown
## Key Metrics Change

- **Development Cost:** $50K/month → $15K/month (↓ 70%)
- **Delivery Speed:** 14 days → 3 days (↓ 78%)
- **Code Quality:** 82% → 94% (↑ 15%)
- **Team Capacity:** 5 FTEs → 12 effective FTEs (↑ 140%)
- **Vendor Dependency:** 100% → 0% (↓ 100%)
```

## ROI Visualization

### Simple ROI Table
```markdown
## 3-Year ROI Projection

| Year | Investment | Savings | Net | Cumulative ROI |
|------|-----------|---------|-----|----------------|
| Year 1 | $50,000 | $120,000 | +$70,000 | 140% |
| Year 2 | $20,000 | $180,000 | +$160,000 | 350% |
| Year 3 | $20,000 | $180,000 | +$160,000 | 530% |

**Payback Period:** 5 months
```

### Cost Breakdown
```markdown
## Annual Cost Comparison

### Traditional Vendor Approach
```
Total: $240,000/year
├─ Offshore developers (3): $180,000
├─ Project management: $30,000
├─ Communication overhead: $20,000
└─ Contract/legal: $10,000
```

### AI-Augmented FTE Approach
```
Total: $72,000/year
├─ AI tools (Copilot, GPT-4): $12,000
├─ Additional compute: $10,000
├─ Training/upskilling: $20,000
└─ Platform subscriptions: $30,000
```

**Annual Savings: $168,000 (70% reduction)**
```

## Dashboard Layout Pattern

```markdown
# FTE+AI Implementation Dashboard

## 📊 Key Metrics (This Month)

| Metric | Value | vs. Last Month |
|--------|-------|----------------|
| Cost Savings | $14,000 | +$2,000 (↑) |
| AI Utilization | 78% | +8% (↑) |
| FTE Productivity | 2.4x | +0.3x (↑) |
| Quality Score | 96% | +2% (↑) |

## 🎯 Goals Progress

- Reduce vendor dependency to < 20%: [████████████████░░░░] 80%
- Achieve 2x FTE productivity: [████████████████████] 100% ✅
- Save $150K annually: [████████████████░░░░] 82%

## ⚠️ Attention Areas

- Training completion rate: 67% (target: 90%)
- API error rate increased to 2.1% (investigate)

## 📈 Trend Highlights

- Month-over-month savings: increasing
- Team satisfaction: 4.5/5 stars
- AI adoption: steady growth across teams
```

## Chart Description Format

When actual charting tools aren't available, describe charts clearly:

```markdown
### Chart: Monthly Cost Savings Trend

**Type:** Line chart
**X-axis:** Months (Jan - Dec 2024)
**Y-axis:** Cumulative savings ($)

**Data points:**
- Jan: $8,000
- Feb: $18,000
- Mar: $32,000
- Apr: $48,000
- May: $67,000
- Jun: $89,000
- Jul: $112,000
- Aug: $138,000
- Sep: $165,000
- Oct: $195,000
- Nov: $228,000
- Dec: $264,000

**Trend:** Steady linear growth with acceleration in Q4
**Key insight:** Savings compound as more teams adopt AI
```

## Visual Hierarchy Principles

1. **Use headers** to create clear sections
2. **Bold key numbers** to draw attention
3. **Use bullets** for lists
4. **Use tables** for structured comparisons
5. **Use blockquotes** for important callouts
6. **Use emojis sparingly** for visual markers
7. **Use whitespace** to prevent overwhelming readers

## Callout Boxes

```markdown
> **💡 Key Insight**
> 
> Teams that complete AI training see 3x higher productivity gains than those who skip it. Invest in training early.

> **⚠️ Warning**
> 
> Initial AI adoption may temporarily slow productivity (2-4 weeks) as teams learn new tools. Plan accordingly.

> **✅ Success Metric**
> 
> If you achieve 2x FTE productivity within 6 months, your implementation is on track.
```

## Best Practices

- **Keep it simple:** Don't overload with too many charts
- **Tell a story:** Visualizations should support narrative
- **Label clearly:** Every axis, unit, and data point
- **Use consistent colors:** Same meaning = same color
- **Provide context:** Add benchmarks or targets
- **Show trends:** Not just current state
- **Make it actionable:** Viewers should know what to do next

## Tools References

For creating actual visualizations (outside markdown):
- Excel/Google Sheets: Standard charts
- Mermaid.js: Flowcharts and diagrams in markdown
- Lucidchart: Professional diagrams
- Tableau/PowerBI: Interactive dashboards
- Python (matplotlib, seaborn): Custom data viz

## Example: Complete ROI Visualization

```markdown
# Vendor Replacement ROI Analysis

## Executive Summary

**Bottom Line:** Replacing offshore vendor with AI-augmented FTEs saves **$168K annually** with **5-month payback**.

## Cost Comparison

| Category | Before (Vendor) | After (AI) | Savings |
|----------|----------------|------------|---------|
| **Monthly** | $20,000 | $6,000 | $14,000 (70%) |
| **Annual** | $240,000 | $72,000 | $168,000 (70%) |
| **3-Year** | $720,000 | $216,000 | $504,000 (70%) |

## Implementation Costs

| Item | Cost | Timeline |
|------|------|----------|
| AI tools setup | $10,000 | Month 1 |
| Team training | $20,000 | Months 1-2 |
| Process migration | $20,000 | Months 1-3 |
| **Total Investment** | **$50,000** | **3 months** |

## Payback Analysis

- **Monthly savings:** $14,000
- **Payback period:** $50,000 ÷ $14,000 = **3.6 months**
- **Year 1 ROI:** ($168K - $50K) / $50K = **236%**

## Timeline to Value

```
Month 1-2: [Investment] -$50K total
Month 3: [Break even approaching]
Month 4: [✅ Break even achieved]
Month 5-12: [Profit accumulation] +$112K
Year 2-3: [Full savings] +$336K

Total 3-year value: $448K net profit
```

## Risk Assessment

| Risk | Probability | Mitigation |
|------|-------------|------------|
| Slower adoption | Medium | Enhanced training |
| AI costs increase | Low | Multi-provider strategy |
| Quality issues | Low | Human oversight layer |

**Overall Risk Level:** 🟢 Low
```

This comprehensive visualization approach ensures complex data is accessible and actionable for all audiences in the FTE+AI documentation.