Design a KPI Dashboard Layout with Metrics and Visualizations
Design a complete KPI dashboard with metric selection, layout wireframe, visualization best practices, and implementation steps.
📝 The Prompt
Act as a business intelligence analyst and data visualization expert. Help me design a comprehensive KPI dashboard for my organization.
Business Context:
- Company/Department: [COMPANY_OR_DEPARTMENT]
- Industry: [INDUSTRY]
- Dashboard Audience: [AUDIENCE_e.g._C-Suite_Sales_Team_Operations_Managers]
- Primary Objective: [DASHBOARD_OBJECTIVE]
- Reporting Frequency: [FREQUENCY_e.g._Daily_Weekly_Monthly]
- Data Sources Available: [DATA_SOURCES]
- Dashboard Tool: [TOOL_e.g._Tableau_Power_BI_Looker_Google_Sheets]
Please design the dashboard by completing the following:
**Step 1 — KPI Selection**
Identify 8-12 KPIs that directly support [DASHBOARD_OBJECTIVE]. For each KPI, specify:
- Metric name and formula/calculation
- Target/benchmark value
- Data source and refresh frequency
- Why this metric matters for [AUDIENCE]
**Step 2 — Dashboard Layout**
Design a visual layout with:
- Top section: 4-5 headline KPI cards with sparkline trends
- Middle section: 2-3 primary charts (specify chart type and what each visualizes)
- Bottom section: Detail tables or drill-down views
- Sidebar or filter panel: Recommended filters (date range, region, segment, etc.)
**Step 3 — Visual Design Principles**
- Color coding strategy for status indicators (red/yellow/green thresholds)
- Recommended chart types for each metric with reasoning
- Alert/notification rules for metrics crossing thresholds
**Step 4 — Interactivity & Drill-Downs**
Suggest 3-4 drill-down paths that let [AUDIENCE] investigate anomalies.
**Step 5 — Implementation Checklist**
Provide a step-by-step checklist to build this dashboard in [TOOL], including data preparation, calculated fields, and testing steps.
💡 Tips for Better Results
Limit your dashboard to one screen — if users have to scroll, you've included too much; use drill-downs instead. Always start with the decision the audience needs to make, then work backward to the metrics that inform that decision. Test your dashboard with actual end users before finalizing; what seems intuitive to analysts often confuses executives.
🎯 Use Cases
Business analysts, BI teams, and operations managers building executive or departmental dashboards to track performance and drive data-informed decisions.