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.

Need More Prompts?

Explore our full library of 60+ professional AI prompt templates

Browse All Prompts →