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.
Templates also in: · · ·
KPI dashboard
Operating margin
Customer satisfaction
Employee turnover
Revenue against target ($m)
Operating margin vs 15% target
Annual goals, year to date
Revenue by business unit, September ($k)
Edit widget
Your data
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
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
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
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
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
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.

SlideTeam