kpi-tree-architectlisted
Install: claude install-skill florianbonnet14/ThePowerOfAnalytics_ClaudeSkills
# KPI Tree Architect
Build hierarchical KPI structures that decompose North Star metrics into actionable drivers using MECE principles.
## Core Principle: MECE Decomposition
**Mutually Exclusive & Collectively Exhaustive**
- **Mutually Exclusive**: No overlapping drivers (no double-counting)
- **Collectively Exhaustive**: No missing drivers (sum of parts = whole)
Visual analogy: Tangram puzzle pieces that don't overlap and cover the entire area.
## Three Decomposition Methods
### 1. Mathematical Decomposition
Use when metric has clear mathematical formula.
**Example**: Upselling Rate = # Customers Buying Higher Tier / Total # Customers
- Decomposes to numerator and denominator
- Common patterns: Rate = Numerator/Denominator, Average = Sum/Count
### 2. Process Decomposition
Use when metric depends on sequential steps (funnels, workflows).
**Example**: # Customers Buying = Visits × Click Rate × Checkout Completion
- Decomposes by funnel stages
- Common patterns: Conversion funnels, customer journeys
### 3. Segmentation Decomposition
Use when metric varies significantly by groups.
**Example**: Total Visits = Organic + Email Campaign + Other Channels
- Decomposes by segments
- Common patterns: Customer types, product categories, regions, channels
## Workflow Choice
**First, always ask the user**: "Would you like me to:
1. **Generate the complete tree at once** (I'll build the full decomposition and present it), or
2. **Build it collaboratively** (we'll work through