KPI Dashboard Specification — Business Intelligence

Design a KPI dashboard specification for [business function — e.g. SaaS Metrics / E-commerce / Marketing / Sales].

**For each KPI, provide:**
1. **KPI name** and one-sentence definition
2. **Formula**: exact calculation (e.g., "Monthly Recurring Revenue = sum of all active subscription values")
3. **Chart type**: best visualization (line chart, gauge, bar, heatmap, etc.) and why
4. **Benchmark**: what "good" looks like for this metric
5. **Granularity**: daily / weekly / monthly
6. **Data source**: which table/system it comes from
7. **Alert threshold**: when to flag (e.g., "churn > 5% triggers red alert")

**Dashboard layout:**
- Group KPIs into sections: Overview (4-6 top metrics), Trends, Drill-downs
- Specify a recommended layout grid (e.g., "2×3 grid for overview cards, full-width time series below")
- Include one "north star metric" prominently at the top

**Output as**: Structured specification document with sections, not just a list.
Include a recommended tool stack: [Metabase / Looker / Tableau / custom] with rationale.

**Target audience**: [role — e.g. CEO, VP Marketing, Product Manager]