Design a KPI Dashboard Layout for Business Performance Tracking

Design a KPI dashboard with metric selection, layout wireframe, data hygiene checklist, and stakeholder adoption plan.

๐Ÿ“ The Prompt

Act as a business intelligence consultant and data visualization expert. Help me design a comprehensive KPI dashboard for my [BUSINESS_TYPE] business. Business Context: - Company Stage: [COMPANY_STAGE] (e.g., early-stage startup, growth-stage, enterprise) - Industry: [INDUSTRY] - Primary Revenue Model: [REVENUE_MODEL] (e.g., subscription, transactional, advertising) - Key Departments to Track: [DEPARTMENTS] (e.g., Sales, Marketing, Product, Customer Success) - Dashboard Audience: [AUDIENCE] (e.g., C-suite, department heads, board of directors) - Reporting Cadence: [CADENCE] (e.g., real-time, daily, weekly, monthly) - Preferred BI Tool: [BI_TOOL] (e.g., Tableau, Looker, Power BI, Google Sheets) Please deliver the following: **Section 1 โ€” KPI Selection** For each department in [DEPARTMENTS], recommend 4-6 KPIs that align with [REVENUE_MODEL]. For each KPI, specify: the metric name, formula/calculation method, data source, benchmark range for [INDUSTRY], and why it matters at the [COMPANY_STAGE] stage. **Section 2 โ€” Dashboard Layout** Design a dashboard wireframe description with: - Executive summary row (3-4 headline metrics with trend indicators) - Department-specific sections with chart type recommendations (line, bar, funnel, gauge, etc.) - A cohort or trend analysis panel for tracking month-over-month changes - An alert/anomaly section highlighting metrics outside benchmark thresholds **Section 3 โ€” Data Hygiene Checklist** Provide a 10-point checklist for ensuring data accuracy, consistency, and freshness before the dashboard goes live. **Section 4 โ€” Stakeholder Adoption** Suggest a rollout plan including a weekly review ritual format, three questions the [AUDIENCE] should ask when reviewing the dashboard, and common pitfalls that cause dashboard abandonment.

๐Ÿ’ก Tips for Better Results

Limit the executive summary to no more than 4 headline metrics โ€” cognitive overload causes dashboard abandonment. Always pair each KPI with a benchmark or target so viewers instantly know if performance is good or bad. Schedule a recurring 15-minute dashboard review meeting to build the habit of data-driven decision-making.

๐ŸŽฏ Use Cases

Operations leaders, business analysts, and founders setting up performance dashboards to track company health and drive data-informed decisions.

๐Ÿ”— Related Prompts

๐Ÿ’ผ Business intermediate

Design a Complete OKR Framework for Your Team or Organization

Build a complete OKR framework with company, team, and individual objectives, scoring systems, and a 90-day rollout plan.

๐Ÿ’ผ Business intermediate

Write a Business Plan Executive Summary

Create a compelling executive summary for investors with market analysis, financials, and positioning.

๐Ÿ’ผ Business intermediate

Create a Project Proposal

Generate a complete project proposal with timeline, budget, risk assessment, and success metrics.

๐Ÿ’ผ Business advanced

Create a Compelling Investor Pitch Deck Outline

Generate a detailed investor pitch deck outline with slide-by-slide guidance, speaker notes, and visual suggestions for fundraising.

๐Ÿ’ผ Business advanced

Design an Equity Allocation Model for Co-Founders and Early Team

Build a fair co-founder equity split using a weighted scoring model, vesting schedules, option pool strategy, and cap table scenarios.

๐Ÿ’ผ Business beginner

SWOT Analysis Generator

Generate a detailed SWOT analysis with strategic recommendations and priority actions.