Kpiloom
KPIs

What Is a KPI Dashboard? Examples, the Best KPIs and How to Build One

A KPI dashboard shows your most important numbers on one screen. See examples by department, how to choose the right KPIs, and how to build one in Excel or Power BI.

By the Kpiloom team · · 4 min read


A KPI dashboard is a single screen that shows the handful of numbers that tell you whether a business, team or project is on track. KPI stands for key performance indicator: a number you have decided matters enough to watch every week.

KPI dashboard vs report

A report lists everything that happened. A KPI dashboard answers one question quickly: are we on track, and if not, where is the problem? That is why good dashboards are short. Most need five to eight KPIs, a trend chart and one or two breakdowns.

How to choose the right KPIs

Use these four tests for every number you consider:

  1. It links to a goal. Revenue growth links to a sales target; attrition links to a hiring plan.
  2. Someone can act on it. If the number moves, a person knows what to do.
  3. It is measured the same way every time. Write the formula down.
  4. It has a comparison. A number alone means little. Show it against last month, last year or a target.

KPI dashboard examples by department

Here are the KPIs we include in each type of Kpiloom dashboard. Each link opens the full list with definitions and formulas.

DashboardCore KPIs
Sales dashboardRevenue, win rate, average deal size, pipeline value, quota attainment
Finance dashboardGross margin, net profit, operating expenses, cash runway, days sales outstanding
Marketing dashboardLeads, cost per lead, conversion rate, ROAS, customer acquisition cost
HR dashboardHeadcount, attrition rate, time to hire, absenteeism, eNPS
Inventory dashboardStock value, stock turnover, out-of-stock items, days of inventory, fill rate
Executive dashboardRevenue, revenue growth, net profit, cash balance, customers, NPS

A worked example: one small shop, six numbers

Picture a clothing store with two branches. The owner opens a retail executive dashboard in Excel every Monday. This month it shows revenue of ₹8,40,000 against a target of ₹9,00,000, so the shop is at 93% of plan. Gross margin is 41%, down from 44% last month. Footfall is steady, but the average bill fell from ₹2,150 to ₹1,980.

Those three numbers together tell a clear story: the same number of people came in, but they bought less and the shop earned less on each sale. The breakdown by branch shows the drop came from one store running a clearance sale. Without a dashboard, the owner would only have seen "sales are a bit low" at month end. With it, the fix is obvious on day one: end the discount early and push full-price stock at that branch.

The same idea works in any business. An online store watches traffic, conversion rate and cost per order on an e-commerce marketing dashboard. A software company watches monthly recurring revenue, churn and cash runway on a SaaS finance dashboard in Excel.

Leading and lagging KPIs

Lagging KPIs, such as revenue and profit, tell you what already happened. Leading KPIs, such as pipeline value, website leads or open support tickets, warn you about what is coming. A useful dashboard shows both: lagging KPIs at the top for the score, leading KPIs below for the early warning.

The layout that works

  • Top: KPI cards with the current value and the change versus the comparison period. Use green and red only for the change, not for decoration.
  • Middle: one trend chart for the most important KPI.
  • Bottom: breakdowns by region, product, team or customer, so you can see where a change came from.
  • Filters: a date range and one or two slicers, such as region or product.

Common KPI dashboard mistakes

  • Too many numbers. Twenty KPI cards on one screen means nobody knows where to look. Keep the first page to the five to eight that drive decisions.
  • No comparison. "Revenue: ₹8.4 lakh" says little. "₹8.4 lakh, 7% below target" says what to do.
  • Different definitions. If sales counts an order when it is booked and finance counts it when it is paid, the dashboard will start arguments instead of ending them.
  • Stale data. A dashboard updated once a quarter is a report. Refresh it at least as often as you make decisions.

Where to build it

  • Excel is ideal if your data already lives in spreadsheets and you want to work offline.
  • Google Sheets is best when several people need to see the same live numbers.
  • Power BI suits larger data and drill-down from year to month to week.
  • Looker Studio is free and connects directly to Google Sheets, GA4 and Google Ads.

Not sure which? Read our comparison of Power BI vs Excel for dashboards.

Start from a template

Every Kpiloom dashboard comes with its KPIs already defined, the formulas written and a clean layout, for 53 industries. A good place to start is the executive dashboard, which puts a company's most important numbers on one page.

Frequently asked questions

How many KPIs should a dashboard have?

Usually five to eight. More than that makes it hard to see what matters. Put extra detail on a second page.

What is the difference between a KPI and a metric?

Every KPI is a metric, but only the few metrics tied directly to your goals are KPIs. Website visits is a metric; leads from the website against target is a KPI.

How often should a KPI dashboard be updated?

Match it to how often you make decisions: daily for operations and sales teams, weekly or monthly for finance and leadership.

Skip the build. Start with a ready dashboard.

Templates for Excel and Google Sheets, with live previews.

Browse dashboards

Dashboards related to this article

Keep reading