Skip to content

KPI dashboard builder

Your headline KPIs against target, with trends and a red-amber-green scorecard. Replace the sample numbers with yours and download an editable slide or workbook.

New here? — takes 2 minutes.

KPI dashboard

Monthly management KPIs — Rolling six months to September

Revenue

$4.2m
+3.4% vs target

Operating margin

14.8%
+1.1 pts

Customer satisfaction

4.4 /5
+0.1

Employee turnover

9.2%
−0.6 pts

Revenue against target ($m)

ActualTarget
3.3
3.6
3.9
4.2
4.5
4.24.1
AprMayJunJulAugSep

Operating margin vs 15% target

14.8%Target 15%

Annual goals, year to date

Revenue $48m, good74%
New customers 1,200, good69%
Cost savings $2.5m, warning52%
Product launches (4), warning50%
Safety incidents below 6, critical33%

Revenue by business unit, September ($k)

Enterprise1.5k
Mid-market1.1k
Small business760
Public sector510
International330

4 KPI Dashboard templates

Every template opens as a finished dashboard. Pick the closest one, then change anything.

Metrics and how to calculate them

The KPIs these templates are built on, with the formula behind each one.

Revenue against target
Actual revenue ÷ target revenue for the period × 100.
Operating margin
Operating profit ÷ revenue × 100.
KPIs on target
KPIs meeting or beating target ÷ all KPIs tracked × 100.
Variance to budget
Actual − budget for each line; favorable when revenue is above or cost is below budget.
Return on capital employed
Earnings before interest and tax ÷ (total assets − current liabilities) × 100.
Employee turnover
Leavers in the last 12 months ÷ average headcount over those months × 100.
Net Promoter Score
Percentage of promoters (9–10) minus percentage of detractors (0–6).

How to make your KPI Dashboard

Pick a template, put your numbers in, download — about two minutes. Nothing to install; the PDF and every other format come with a SlideTeam plan.

  1. 1

    Pick your dashboard

    Click Pick Your Dashboard. This dashboard has 4 ready-made layouts, such as KPI dashboard and Monthly KPI tracker. Each opens finished, with example figures.

  2. 2

    Change the numbers

    Point at any widget (tap it on a phone) and choose Edit to type or paste its numbers and labels — a column copied from Excel pastes straight in. Click the dashboard's title to rename it.

  3. 3

    Use your own data

    Upload CSV or Excel takes a CSV, .xlsx or .xls file and shows exactly what it read: pick the sheet, the label column and how repeated rows are combined (sum, average, count), then Build a new dashboard or Fill this template with your columns. Not sure of the layout? Download the sample CSV and replace the numbers.

  4. 4

    Download PDF, PowerPoint, Excel and more

    Download (right end of the toolbar) lists every format: a PDF (free), PowerPoint with native charts you can still edit (right-click › Edit data), a report pack (summary slide plus one slide per chart) as PowerPoint or PDF, Excel (opens on a Dashboard sheet with live charts) and a CSV for Power BI, Tableau or Google Sheets.

  5. 5

    More options: add widgets, brand it, share

    More options (top right) shows the rest: Add widget puts in a chart, KPI tile, table, funnel or a Text / commentary box; the arrows on a widget move it and ✕ removes it; click the subtitle to edit it. Customise sets the currency, template language, slide size, brand colour and logo. Sheets / Slides shows how to open your file in Google Sheets or Slides; Share copies a link to this exact dashboard.

Common questions

What is a KPI dashboard?

A KPI dashboard shows the handful of measures that tell you whether the business or team is on track, each against a target, with enough trend to see direction. The first template is a general-purpose monthly version.

How many KPIs should a dashboard have?

Four to eight headline KPIs on one page is usually enough. Track the rest in a scorecard table like the Monthly KPI tracker, with an owner and red-amber-green status for each.

Can I download the KPI dashboard as an Excel file?

Yes. Download Excel gives you a free workbook with each chart's data and a live chart, and Download PowerPoint gives you an editable slide.

What is the difference between a KPI dashboard and a balanced scorecard?

A balanced scorecard groups KPIs under four perspectives — financial, customer, internal process and learning — and ties each to a strategic objective. Use the Balanced scorecard template for that layout.

Goes well with this — from our other free tools

The figures in the example dashboards are illustrative and exist so each page shows a finished dashboard rather than an empty grid. Replace them with yours before sharing anything.