KPI dashboard

KPI dashboard is a single view of the small set of key performance indicators that drive business decisions. The point is not to show every metric; the point is to surface the 5-10 numbers a decision-maker actually uses, and to do so in a glance. KPI dashboards differ from analytical reports: a report explores, a dashboard monitors.

Dr Waqas Rafique · Founder & CTO · PhD, Statistical Machine Learning
LinkedIn · About

Lagging vs leading indicators

A lagging indicator tells you what already happened (revenue, churn, active users). A leading indicator predicts what will happen (trial signups, demo-booked, NPS). A good dashboard shows both. Most dashboards show only lagging indicators — you find out about a problem after it's irrecoverable.

The 5-10 rule

More than 10 KPIs and the dashboard becomes a wall of numbers nobody reads. Fewer than 5 and it's not a dashboard, it's a metric. Pick the 5-10 that, if all green, mean the business is healthy.

Design heuristics

Position the most important metric top-left (Western reading order). Show change vs prior period prominently — absolute numbers are useless without context. Use sparklines for trend, not gauges (they're space-inefficient). Annotate anomalies in-line, not in a separate alerts panel.

Common mistakes

1. Showing month-to-date vs same-period-last-month for highly seasonal businesses (you'll panic in February every year). 2. Mixing leading and lagging on the same row without indicating which is which. 3. Choosing KPIs because the data exists, not because the decision exists. 4. Updating the dashboard but not the decision-maker's behaviour — if no one acts on the alert, the alert is decoration.

Tools

Tableau and Power BI are overkill for most teams. Spreadsheet-native dashboard tools covering 80% of needs at 1/30th the cost. Use the heavy enterprise BI stack only when you have a data engineer and >20 dashboard editors.

Frequently asked questions

What's the difference between a KPI and a metric?

A metric is any measurable quantity. A KPI (Key Performance Indicator) is a metric tied to a business outcome — chosen because changes in it should change decisions. Most dashboards mix the two; the discipline of a good dashboard is using only KPIs.

How many KPIs should a dashboard show?

5-10. Fewer than 5 isn't a dashboard, it's a metric. More than 10 and the dashboard becomes a wall of numbers nobody reads. Pick the 5-10 that, if all green, mean the business is healthy.

What's a leading vs lagging KPI?

A lagging KPI tells you what already happened (revenue, churn). A leading KPI predicts what will happen (trial signups, NPS). Good dashboards show both — most show only lagging, which means you find out about problems too late to act.