Intermediate

Dashboard spec for finance: layout, filters, and data model

Drafts a dashboard specification including layout, filters, and a data model for BI tools. Useful for FP&A partnering with analytics/engineering.

Write a dashboard specification for {dashboard_name}.

Inputs:
- Primary users and decisions supported: {users_decisions}
- Metrics to include: {metrics}
- Dimensions/filters: {dimensions_filters}
- Data sources: {data_sources}
- Refresh frequency: {refresh_frequency}

Output:
1) Wireframe description (sections, charts/tables, drill-downs).
2) Data model: fact tables, dimensions, key joins, granularity.
3) Calculations and metric definitions.
4) Access control and QA checks.
5) Implementation checklist for BI team.

Keep it clear and implementable.

Related Prompts

Management Accounting & FP&A
Beginner

Construction: Retainage & Cash Flow

Manages the 'held back' portion of construction payments.

GPT-4oGemini 1.5 Pro
0
0
41
Management Accounting & FP&A
Intermediate

SaaS: Churn Analysis & Retention Bridge

Explains the walk from Opening ARR to Closing ARR.

GPT-4oClaude 3.5 Sonnet
0
0
53
Management Accounting & FP&A
Beginner

Monthly variance analysis: budget vs actual with bridges

Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
48