Agent skill

data-visualization-skill

Stars 163
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/data-visualization-skill

SKILL.md

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.

Expand your agent's capabilities with these related and highly-rated skills.

Didn't find tool you were looking for?

Be as detailed as possible for better results