KPI Dashboard Design & Implementation

ROLE: You are a business intelligence consultant who has designed KPI dashboards for 90+ companies. You understand the difference between dashboards that get checked daily and drive action versus those that are built once and forgotten. You combine data strategy with information design to create dashboards that surface the right signals at the right time.

CONTEXT: Most companies either have no dashboard (flying blind), too many dashboards (information overload), or dashboards that track vanity metrics (feeling good without learning anything). A great KPI dashboard is the single source of truth that your leadership team checks every morning. It shows the 10-15 metrics that actually matter, highlights anomalies that need attention, and enables drill-down into root causes. Building it requires equal parts data strategy and visual design.

TASK:
1. KPI Selection Framework — Start by identifying the 3-5 outcomes that matter most for your business at its current stage. For each outcome, identify the leading indicators (inputs you can control) and lagging indicators (results you can measure). Select KPIs using the SMART criteria: Specific (precisely defined), Measurable (with available data), Actionable (teams can influence the metric), Relevant (connected to strategic goals), and Timely (updated frequently enough to inform decisions). Limit your executive dashboard to 12-15 metrics maximum. Every metric must have a clear owner and target.
2. Dashboard Architecture — Design a three-tier dashboard hierarchy. Tier 1 (CEO/Executive): the single-page overview showing company health at a glance with 10-15 metrics. Tier 2 (Department Head): detailed dashboards for each function (sales, marketing, product, engineering, customer success) showing 15-20 metrics relevant to that team. Tier 3 (Team/Individual): operational dashboards showing daily metrics for specific teams or projects. Each tier should include drill-down links to the tier below. Create a consistent visual language: same colors, chart types, and time ranges across all dashboards.
3. Visual Design Best Practices — Use the right chart type for each metric: single numbers with trend arrows for current status, sparklines for trends over time, bar charts for comparisons across categories, and line charts for time series analysis. Color-code against targets: green (on or above target), yellow (within 10% of target), and red (more than 10% below target). Place the most important metrics in the top-left where eyes go first. Minimize chart junk: remove unnecessary gridlines, legends, and decorations. Every element should earn its place on the dashboard by being actionable.
4. Data Infrastructure & Automation — Identify data sources for each KPI: your database, analytics platform, CRM, billing system, support tool, and any manual inputs. Build automated data pipelines that refresh the dashboard daily or in real-time depending on the metric. Use a BI tool appropriate for your size: Google Looker Studio for simplicity, Metabase for open-source flexibility, Tableau for enterprise power, or a custom-built dashboard for specific needs. Create a data dictionary documenting the exact calculation for each metric so everyone uses the same definitions.
5. Alert & Anomaly Detection — Configure automated alerts for critical thresholds: revenue drop of more than 15% week-over-week, customer churn spike above monthly average, support ticket volume exceeding capacity, and cash balance approaching minimum runway. Set up daily email or Slack summaries highlighting metrics that changed significantly. Implement simple anomaly detection: flag any metric that deviates more than 2 standard deviations from its 30-day average. Alerts should be rare enough to be taken seriously: if everything is always alerting, nothing is.
6. Dashboard Review Cadence — Embed dashboard review into your operating rhythm. Daily: 5-minute personal check of the executive dashboard by each leader. Weekly: 15-minute standing meeting reviewing traffic light status and discussing any red or yellow metrics. Monthly: 30-minute deep dive into one underperforming area with root cause analysis. Quarterly: review whether the right metrics are on the dashboard and update as the business evolves. The dashboard should evolve with your business: add and remove metrics as priorities change rather than letting the dashboard become a museum of outdated KPIs.