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

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

Management Accounting & FP&A

Intermediate

Cost allocation model: shared services and drivers

Designs a cost allocation approach for shared services using clear drivers and documentation. Useful for management reporting and chargeback models.

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

Management Accounting & FP&A

Beginner

Metric definition library (single source of truth) template

Creates a standardized metric dictionary to prevent KPI drift across teams. Useful for scaling reporting and ensuring consistent definitions.

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