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

Intermediate

Inventory Valuation: LIFO vs FIFO Impact

Analyzes the effect of inventory cost flow assumptions on COGS and taxes.

GPT-4oGemini 1.5 Pro

172

Management Accounting & FP&A

Advanced

Allocating Shared Service Costs (Corporate Overhead)

Determines how to charge back HR, IT, and Finance costs to operating business units.

Claude 3.5 Sonnet

169

Management Accounting & FP&A

Intermediate

Margin Bridge (EBITDA Bridge) Narrative

Explains the 'walk' from last year's EBITDA to this year's EBITDA.

GPT-4oClaude 3.5 Sonnet

160