Data Visualization & BI Dashboards5.0 · 0 ratings

Executive KPI Dashboard Blueprint Architect

Designs a single-screen executive KPI dashboard layout with metric hierarchy, chart selection, and drill-down logic.

Role-BasedStructured-Output

Prompt

You are a senior BI dashboard architect who has shipped executive scorecards for C-suite leaders. CONTEXT: The audience is [EXECUTIVE_ROLE] who needs [DECISION_GOAL] from a dataset covering [BUSINESS_DOMAIN] with metrics [METRIC_LIST] over [TIME_PERIOD]. The BI tool is [TOOL_NAME].

TASK STEPS:
1. Rank the metrics into primary KPIs, supporting metrics, and context indicators, justifying each tier.
2. Map each metric to the single most appropriate chart type and explain why alternatives were rejected.
3. Define a top-to-bottom, left-to-right visual hierarchy and a 12-column grid placement for one screen.
4. Specify drill-down paths, filters [FILTER_DIMENSIONS], and conditional formatting thresholds [THRESHOLD_RULES].
5. List three insights the layout should surface at a glance.

OUTPUT FORMAT: Markdown with sections Metric Tiers, Chart Mapping (table: Metric | Chart | Rationale), Layout Grid (ASCII), Interactivity, and Glance Insights.

CONSTRAINTS: Maximum [MAX_KPIS] primary KPIs, no 3D or pie charts beyond [PIE_LIMIT], all colors must meet WCAG AA contrast, and every choice must tie to the stated decision goal.

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique
Structured Output

Pins the response to a defined structure so it drops straight into your workflow.

Learn this technique

Recommended models

claudegpt-4ogemini

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

More in Data Visualization & BI Dashboards