Donezo/TemplatesOpen Docs

KPI Dashboard Template

Guide: How to build a quarterly KPI dashboard
Pick the few numbers that matter, show their direction, and say what they mean.
Guide · not printed

What it is

A KPI dashboard is a one-page view of the numbers a team has agreed to watch for the quarter. Metric tiles show the current value, the change against last quarter and a short trend. Goal bars show progress toward quarterly targets. A channel breakdown and a month-over-month table explain where the movement comes from, and a written key insight states what the numbers mean and where attention goes next.

When to use it

  • Use it at the end of each quarter to report performance to leadership, a board or investors on a single page.
  • Use it at the start of a quarter to agree on which numbers the team owns and what the targets are.
  • Use it when a team has many reports and no shared view, to force a choice about which few numbers matter.
  • Use it before a planning session, so the discussion starts from the same facts.

What it must include

  • Header details for team, period, owner and update date, so readers know whose numbers these are and how current they are.
  • Four to six metric tiles, each with a comparison to the prior period, because a number without a reference point says nothing about direction.
  • Quarterly goals with the current value beside the target, so progress reads as distance to the goal.
  • A breakdown, such as revenue by channel, that shows which part of the business drives the headline number.
  • A month-over-month table for metrics that move too slowly or too unevenly to read from a single tile.
  • A key insight of two or three sentences that names the standout result, the main gap and the focus for the next period.

People also ask

What is the difference between a KPI and a metric?

Every KPI is a metric, and only a few metrics qualify as key performance indicators: the ones that tell people what to do to improve performance. David Parmenter separates key result indicators, which summarize outcomes for a board, from KPIs, which are measured often and point to a clear action. As a rough guide for a whole organization, he suggests about 10 key result indicators, up to 80 performance indicators and 10 KPIs. On a team dashboard, keep the tiles for numbers the team can act on this quarter and move the rest to a supporting table. Source: David Parmenter, Key Performance Indicators, 3rd edition (2015).

What is the difference between leading and lagging indicators?

A lagging indicator reports a result after it has happened, and a leading indicator measures an activity or condition that drives that result. Revenue and churn are lagging. Activation rate, pipeline created and support response time are often leading, because they move first. Robert Kaplan and David Norton built the balanced scorecard on this pairing of outcome measures with the performance drivers that produce them. A useful dashboard shows both, so a team can act on the driver while there is still time to change the outcome. Source: Robert S. Kaplan and David P. Norton, The Balanced Scorecard (1996).

How many KPIs should be on a dashboard?

Show as many as fit on one screen without scrolling, which for most teams means a handful of headline numbers. Stephen Few defines a dashboard as a single-screen display of the most important information people need to do a job, designed to be monitored at a glance. Once a reader has to scroll, comparing one metric with another gets harder and the overall picture blurs. If the team cannot agree on what to cut, ask which numbers would change a decision this quarter. Keep those on the dashboard and move the others to a supporting report. Source: Stephen Few, Information Dashboard Design (2006).

How do you write a key insight for a KPI dashboard?

Write two or three sentences that state what the numbers mean and what should happen next. Cole Nussbaumer Knaflic calls the core of this the big idea: a single sentence that carries your point of view and what is at stake. Lead with the result that changes the picture, name the gap that matters most, then say where attention goes in the next period. A reader who sees only the insight should still reach the right conclusion. Keep every number in it identical to the tiles, so nobody has to reconcile two versions. Source: Cole Nussbaumer Knaflic, Storytelling with Data (2015).

Why do KPIs sometimes cause the wrong behavior?

A KPI draws attention to what it measures, so people improve that number even when something else suffers. Andy Grove observed that indicators direct attention toward what they monitor, and recommended pairing each one with a counter-indicator that shows the side effect. If you track inventory reduction, also track stock shortages. If you track tickets closed, also track tickets reopened. On a dashboard, place each pair side by side, so a gain on one tile is read against its cost on the other. Source: Andrew S. Grove, High Output Management (1983).

KPI Dashboard  ·  Performance Overview

Q2 2026 Business Performance

Team
Growth & Revenue
Period
Apr to Jun 2026
Updated
30 June 2026
Owner
Sarah Kowalski
Key Metrics
Monthly Revenue
€284K
↑ 12.4%
vs €253K last quarter
40,55,48,70,62,80,100
Comma-separated values 0-100
New Customers
1,842
↑ 8.1%
vs 1,704 last quarter
50,60,55,65,75,88,100
Comma-separated values 0-100
Churn Rate
2.3%
↓ −0.4pp
Target: below 3.0%
100,90,80,72,60,52,40
Comma-separated values 0-100
NPS Score
67
→ 0
Unchanged from Q1
60,65,70,65,68,70,70
Comma-separated values 0-100
Quarterly Goals
Annual Recurring Revenue
78
Current: €3.41M
Target: €4.38M
New Enterprise Accounts
53
Current: 16 accounts
Target: 30 accounts
Support Ticket Resolution <24h
94
Current: 94% resolved
Target: 90%
Product Activation Rate
41
Current: 41% of signups
Target: 65%
Revenue by Channel
Direct Sales
82
Partnerships
54
Self-Serve
37
Marketplace
20
Edit the number on the right of each bar to update the bar width (0-100)
Month-over-Month Trends
Metric Month 1 Month 2 Month 3 Trend
Revenue 88 94 102 ↑ 15.9%
Active Users 9210 9840 10430 ↑ 13.2%
Avg. Session (sec) 252 248 251 → −0.4%
Conversion Rate 3.1 3.4 3.8 ↑ 22.6%
Support Tickets 312 287 241 ↑ −22.8%
Key Insight
Summary
Revenue growth of 12.4% reflects the success of the new enterprise pricing tier. Churn improvement to 2.3% is the standout result · customer success investment is paying off. Product activation at 41% remains the critical gap to address in Q3.

More templates

Business Performance Tracker TemplateOKR Dashboard TemplateBelief Pipeline Tracker: Sales CRM TemplateRisk Register Template
All templates
Made with ♥ by Sequence Theory · donezo.space