Executive KPI Dashboard Blueprint Architect
Designs a single-screen executive KPI dashboard layout with metric hierarchy, chart selection, and drill-down logic.
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
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
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
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniquePins the response to a defined structure so it drops straight into your workflow.
Learn this techniqueRecommended models
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
Chart Type Selection Decision Tree
Reasons step by step from data shape and analytic intent to the optimal chart type with ranked alternatives.
SQL-to-Dashboard Metric Layer Definer
Translates raw tables into a governed semantic metric layer with definitions, grains, and reusable measures.
Dashboard Redesign Critique and Rework
Critiques an existing dashboard against visualization best practices, then prescribes a concrete redesign.
Color Palette System for Data Encoding
Builds an accessible categorical, sequential, and diverging color system mapped to dashboard semantics.