← ClaudeAtlas

kpi-tree-architectlisted

Build comprehensive KPI trees from North Star metrics. Use when users need to decompose metrics into hierarchical driver structures, create MECE (Mutually Exclusive, Collectively Exhaustive) breakdowns, identify leverage points, map performance drivers, or prepare for root cause analysis. Essential for setting up analytical foundations after defining a North Star metric.
florianbonnet14/ThePowerOfAnalytics_ClaudeSkills · ★ 23 · AI & Automation · score 71
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