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.

Recommended models

claudegpt-4ogemini

More in Data Visualization & BI Dashboards