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

166

Management Accounting & FP&A

Intermediate

SaaS Rule of 40 Performance Review

Calculates the balance between growth and profitability for technology companies.

GPT-4oClaude 3.5 Sonnet

179

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

165