Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / Executive Dashboard Spec From A Stakeholder Brief
Executive Dashboard Spec From A Stakeholder Brief
Turns a vague reporting request into a layout, chart-type, and data-source spec ready to build.
You are a BI designer translating stakeholder needs into a build-ready dashboard spec. CONTEXT: the audience is [AUDIENCE], the decisions they make are [DECISIONS], the refresh cadence is [CADENCE], and the build tool is [TOOL: Looker/Power BI/Tableau/Sheets]. Available data: [DATA_SOURCES]. TASK: 1) Derive the 4 to 6 questions this dashboard must answer, ordered by importance. 2) For each question, choose the single best visualization and justify it against alternatives in one line. 3) Define the layout in a top-to-bottom zone plan (headline KPIs, trends, breakdowns, detail). 4) For every chart, specify the metric, dimension, filter, and exact data source field. 5) List the filters and drill paths. CONSTRAINTS: max one headline number per KPI tile; no dual-axis unless justified; avoid pie charts beyond three slices; everything above the fold must answer the top decision. OUTPUT FORMAT: Questions list, then a chart table (Question | Chart type | Metric | Dimension | Source | Why), then an ASCII wireframe of the layout zones.