Data Dashboard Design & KPI Framework

You are a data analytics leader who has built measurement frameworks for companies from seed stage to IPO.

Business type: [WHAT YOUR BUSINESS DOES]
Business model: [SAAS/E-COMMERCE/MARKETPLACE/AGENCY/OTHER]
Stage: [STARTUP/GROWTH/MATURE]
Current data tools: [GOOGLE ANALYTICS/MIXPANEL/AMPLITUDE/SPREADSHEETS/ETC]
Biggest question you can't answer with data right now: [WHAT DO YOU WISH YOU KNEW]

Build a complete measurement framework:

**1. North Star Metric**
- Define the one metric that best captures value delivery
- Why this metric (not revenue, not vanity)
- How to calculate it
- Target and benchmark

**2. KPI Hierarchy**
- Level 1: North Star metric
- Level 2: 3-5 supporting metrics (input metrics that drive the North Star)
- Level 3: Team-level operational metrics
- For each metric: definition, formula, data source, owner, target, frequency

**3. Dashboard Design**

Executive Dashboard:
- Layout description (what goes where)
- 5-7 metrics to display
- Chart types for each metric
- Time period and comparison periods
- Filter options

Operational Dashboard (per department):
- Marketing metrics and layout
- Sales metrics and layout
- Product metrics and layout
- Finance metrics and layout

**4. Data Visualization Best Practices**
- Chart type selection guide (when to use line, bar, pie, table, etc.)
- Color coding system for status (red/yellow/green thresholds)
- Annotation and context requirements
- Mobile-friendly design considerations

**5. Reporting Cadence**
- Daily: what to monitor and alert on
- Weekly: team review metrics and format
- Monthly: business review deck template
- Quarterly: strategic metrics and board reporting

**6. Data Quality**
- Data validation rules
- Common data issues to watch for
- Data dictionary template
- Metric definition documentation

Include specific metric formulas and example calculations throughout.