financeintermediate520 tokens
Financial Dashboard Requirements
Design effective financial dashboards for stakeholders
financial-dashboardbusiness-intelligencekpifinancereportingdata-viz
Prompt Template
Design a financial dashboard for stakeholders:
**Audience:** {audience}
**Update Frequency:** {frequency}
**Key Decisions:** {decisions}
**Dashboard Structure:**
**1. Executive KPIs (Top Row):**
| Metric | Current | vs Last Period | vs Plan | Trend |
|--------|---------|----------------|---------|-------|
| Revenue | ${current_rev} | {rev_change}% | {rev_vs_plan}% | {rev_trend} |
| Gross Margin % | {current_gm}% | {gm_change}bps | {gm_vs_plan}bps | {gm_trend} |
| EBITDA | ${current_ebitda} | {ebitda_change}% | {ebitda_vs_plan}% | {ebitda_trend} |
| Cash | ${current_cash} | {cash_change}% | {days_cash} days | {cash_trend} |
**2. Revenue Metrics:**
- ARR/MRR trend (line chart)
- Revenue by product line (stacked bar)
- New vs expansion vs churn (waterfall)
- Customer count & ACV trends
**3. Profitability Metrics:**
- Gross margin trend (line chart)
- EBITDA margin trend (line chart)
- Operating expenses by category (pie chart)
- Burn rate & runway (line chart)
**4. Cash Flow Metrics:**
- Cash flow sources and uses (waterfall)
- Working capital metrics (DSO, DIO, DPO)
- Runway calculation
- Covenant compliance status
**5. Unit Economics:**
- CAC by channel
- LTV:CAC ratio
- Payback period
- Cohort retention curves
**6. Filters & Interactivity:**
- [ ] Time period selector (MTD, QTD, YTD)
- [ ] Department/product line filter
- [ ] Budget vs actual toggle
- [ ] Export to Excel/PDF
**7. Alerts & Notifications:**
Setup automatic alerts when:
- Cash drops below ${min_cash}
- Burn rate exceeds ${max_burn}
- Any metric misses plan by >{variance_threshold}%
- Covenant breach risk detected
**8. Data Sources:**
- Accounting system: {accounting_system}
- CRM: {crm_system}
- Data warehouse: {data_warehouse}
- Update frequency: {update_frequency}
**9. Technical Requirements:**
- Platform: {platform}
- Access control: {access_levels}
- Mobile responsive: {yes/no}
- Real-time vs batch: {real_time}
**10. Success Metrics:**
How to measure dashboard effectiveness:
- Adoption rate: Target {adoption_target}%
- Time to insight: < {time_target} minutes
- Decision improvement: {improvement_target}%
- User satisfaction: > {satisfaction_target}/5
Provide: Complete dashboard spec + wireframes + data requirements.Variables to Replace
{audience}{frequency}{decisions}{current_rev}{rev_change}{rev_vs_plan}{rev_trend}{current_gm}{gm_change}{gm_vs_plan}{gm_trend}{current_ebitda}{ebitda_change}{ebitda_vs_plan}{ebitda_trend}{current_cash}{cash_change}{days_cash}{cash_trend}{min_cash}{max_burn}{variance_threshold}{accounting_system}{crm_system}{data_warehouse}{update_frequency}{platform}{access_levels}{real_time}{adoption_target}{time_target}{improvement_target}{satisfaction_target}Pro Tips
Show trends not just snapshots. Use visual encoding (color, size). Drill-down capability crucial. Test with end users.
Related Prompts
Financial Report Summarizer
financeSummarize complex financial reports for executives
intermediate•380 tokens
Visualization Recommendations
data-scienceChoose and create effective data visualizations with best practices
intermediate•1120 tokens
Product Requirements Document (PRD) Generator
architectureCreate comprehensive PRDs for new features or products
advanced•580 tokens
Need More Prompts?
Explore our full library of 60+ professional AI prompt templates
Browse All Prompts →