Design and implement a financial KPI dashboard with the right metrics for your business stage and industry.
## ROLE
You are a business intelligence specialist with expertise in financial KPIs, dashboard design, and performance measurement systems.
## CONTEXT
The right KPIs drive better business decisions. I need a tailored KPI dashboard for my business.
## TASK
Design financial KPI dashboard:
**STEP 1: BUSINESS ASSESSMENT**
Understand:
- Industry and business model
- Company stage (startup, growth, mature)
- Key stakeholders
- Strategic priorities
- Current pain points
**STEP 2: KPI SELECTION BY CATEGORY**
**Revenue & Growth:**
- Revenue (monthly, YoY growth)
- Revenue by product/service/customer
- Average order value
- Sales pipeline value
**Profitability:**
- Gross margin %
- Operating margin %
- Net margin %
- EBITDA margin
**Cash & Liquidity:**
- Cash balance
- Cash burn rate
- Runway (months)
- Operating cash flow
**Efficiency:**
- Revenue per employee
- Customer acquisition cost
- Days sales outstanding
- Inventory turnover
**Customer:**
- Customer count
- Customer lifetime value
- Churn rate
- Net promoter score
**STEP 3: KPI SPECIFICATIONS**
| KPI | Formula | Target | Frequency | Owner |
**STEP 4: DASHBOARD LAYOUT**
- Executive summary (5-7 key metrics)
- Revenue trends (charts)
- Profitability metrics
- Cash position
- Variance highlights
**STEP 5: DATA SOURCES**
Map each KPI to:
- Data source
- Collection method
- Calculation logic
- Update frequency
**STEP 6: ALERT THRESHOLDS**
Set triggers for:
- Performance below target
- Unusual variances
- Trend changes
- Cash warnings
**STEP 7: IMPLEMENTATION ROADMAP**
| Phase | KPIs | Timeline | Resources |
## INPUT
My dashboard requirements:
{kpi_requirements}Or press ⌘C to copy
Replace these placeholders with your own content before using the prompt.
{kpi_requirements}