KPI Dashboard: Examples, Tools, and How to Build One
A KPI dashboard (key performance indicator dashboard) is a visual display that tracks a company's KPIs on one screen, each shown with its target, its actual result, and its status. Teams no longer need to rebuild the same manual report every month.
A KPI dashboard matters most when KPI numbers sit in ERP, CRM, HRIS, and spreadsheets. This guide covers the types of KPI dashboards, examples by department, KPI dashboard software and tools, and how to build one in Power BI.
What Is a KPI Dashboard?
Technically, a KPI dashboard pulls figures from source systems automatically, calculates each KPI with an agreed formula, and compares the result with its target.
Every KPI dashboard has four basic components:
Component | Purpose | Example |
|---|---|---|
KPI | The measure being tracked | Sales target achievement |
Target | The number to reach in a period | 100% per month |
Actual | The result from the source data | 92% this month |
Status and trend | Color signal and movement chart | Yellow, up from last month |
Benefits of a KPI Dashboard for Large Companies
For companies with many business units, a KPI dashboard delivers four benefits:
One number across all branches: sales is calculated with the same formula in every branch, so executives no longer reconcile five different files.
Current data: the dashboard pulls from source systems on a schedule, so the figures on screen match today's position.
Drill-down to detail: managers can open a national figure and trace it to region, branch, and product.
A named owner for each KPI: every KPI has one person responsible, so everyone knows who follows up when a number drops.
Types of KPI Dashboards
KPI dashboards fall into four types by audience: strategic, operational, tactical, and analytical. The table shows who uses each type and how often it refreshes.
Type | Users | Typical refresh | Example KPIs |
|---|---|---|---|
Strategic | Executives, C-level | Monthly or quarterly | Revenue, net profit margin, market share |
Operational | Supervisors, unit heads | Daily or near real time | On-time delivery, machine downtime, open tickets |
Tactical | Department managers | Weekly or monthly | Win rate, CAC, employee turnover |
Analytical | Data analysts | As analysis requires | Historical trends, root causes, forecasts |
KPI Dashboard Examples by Department
The layout is the same in every department: headline numbers on top, trends in the middle, and detail by branch or product at the bottom. The examples below use KPIs that large companies typically track, and you can see finished dashboards in these Power BI dashboard examples for different teams and industries.
Sales Dashboard
How close is the team to its sales target, and how efficiently do opportunities become deals? A sales dashboard answers both.
KPI | Formula | Data source |
|---|---|---|
Sales target achievement | Actual ÷ target × 100% | ERP, CRM |
Sales growth | (Current period − previous period) ÷ previous period × 100% | ERP |
Win rate | Deals won ÷ total closed deals × 100% | CRM |
Sales cycle length | Average days from lead to closed deal | CRM |
Built in Power BI, these KPIs can sit next to marketing's in one view, as in this Power BI sales and marketing dashboard.
Marketing Dashboard
Marketing dashboards tie campaign spend to the leads and customers that result, so lead conversion rate and customer acquisition cost belong side by side.
KPI | Formula | Data source |
|---|---|---|
Lead conversion rate | Leads converted to customers ÷ total leads × 100% | CRM |
Customer acquisition cost (CAC) | Sales and marketing cost ÷ new customers | Accounting, CRM |
Return on ad spend (ROAS) | Ad revenue ÷ ad spend | Ad platforms |
Cost per lead | Campaign cost ÷ number of leads | Ad platforms, CRM |
Finance Dashboard
Executives often ask for a finance dashboard to see financial health and cash flow on one page.
KPI | Formula | Data source |
|---|---|---|
Net profit margin | Net profit ÷ revenue × 100% | Accounting system |
Days sales outstanding (DSO) | Receivables ÷ credit sales × number of days | Accounting system |
Debt-to-equity ratio | Total debt ÷ total equity | Balance sheet |
Budget variance | (Actual − budget) ÷ budget × 100% | ERP |
A DSO that rises over several months signals slower collections, and this example Power BI finance dashboard shows that shift month by month without a manual report.
HR Dashboard
Hiring and retention show up in the HR dashboard, built from data already stored in the HRIS.
KPI | Formula | Data source |
|---|---|---|
Employee turnover | Leavers ÷ average headcount × 100% | HRIS |
Time-to-fill | Average days from job opening to accepted offer | Recruitment system |
Absence rate | Days absent ÷ total working days × 100% | Attendance system |
Employee engagement score | Average survey score | Internal survey |
Agree on the definition of turnover first, for example whether contractors count. An example Power BI HR dashboard puts turnover, time-to-fill, and engagement score on one screen.
Supply Chain Dashboard
Supply chain dashboards follow goods from supplier to customer.
KPI | Formula | Data source |
|---|---|---|
Inventory turnover | Cost of goods sold ÷ average inventory | ERP, warehouse |
On-time delivery | On-time shipments ÷ total shipments × 100% | ERP, logistics |
Order fulfillment cycle time | Average time from order received to delivery | ERP |
Supply chain cost per unit | Total supply chain cost ÷ units | ERP, accounting |
Inventory turnover, order fulfillment cycle time, and cost per unit share one view in this example Power BI supply chain dashboard.
Manufacturing Dashboard
A manufacturing KPI dashboard shows how efficiently machines and production lines turn materials into goods that pass quality control.
KPI | Formula | Data source |
|---|---|---|
Overall equipment effectiveness (OEE) | Availability × performance × quality | Machines, production system |
Defect rate | Defective units ÷ total units produced × 100% | Quality control records |
First pass yield | Units passing first time ÷ units started × 100% | Production system |
Downtime | Machine stopped hours ÷ scheduled operating hours × 100% | Machines, maintenance logs |
OEE multiplies three percentages: availability (time the machine actually runs), performance (actual speed against standard speed), and quality (share of units that pass). A machine with 90% availability, 95% performance, and 98% quality has an OEE of about 83.8%. The same approach applies to a manufacturer such as PT Onda Mega Industri, which tracks sell-in and sell-out KPIs in Power BI.
KPI Dashboard Software and Tools
Choose a tool based on the number of data sources, the need for automatic refresh, the number of users, and the licenses your company already holds.
Tool | Best for | Notes |
|---|---|---|
Excel or Google Sheets | Small team, one data source | Quick to build, hard to keep consistent |
Power BI | Many data sources, Microsoft ecosystem | Desktop is free; sharing needs Pro, PPU, or Premium capacity |
Tableau | Analyst teams, deep visual exploration | Licensing by role: Creator, Explorer, Viewer |
Qlik Sense | Exploring data across many tables | Available in the cloud or on your own server |
Looker Studio | Marketing reports on Google data | Free; non-Google sources often need connectors |
Built-in HRIS, CRM, or ERP dashboards | KPIs for one function inside one system | Often limited to that system's own data |
A KPI dashboard in Excel is enough when one team uses the numbers and the data lives in one file. Once data comes from several systems or must reach many branches, a BI tool is the better fit. BI Solusi delivers multi-source dashboards through its data visualization services.
KPI Dashboard Templates in Excel
Excel provides PivotTables, charts, and conditional formatting, so a KPI dashboard template in Excel works well for one team that tracks a handful of KPIs from a single workbook. It stops working when people copy the file into different versions, when the data comes from several systems, or when each branch should see only its own figures. At that point, a BI tool with scheduled refresh and access control replaces the template.
How to Build a KPI Dashboard
These seven steps apply to any tool and start from the business decision the dashboard should support:
Define the goal and the users: write down which decision the dashboard should support and who will open it, for example executives monthly or supervisors daily.
Select the KPIs: choose 5 to 9 headline numbers per page, each tied to a company goal.
Agree on definitions: set the formula, data source, and owner for every KPI, especially when the company has several branches or systems.
Connect the data sources: pull figures from ERP, CRM, HRIS, or the files that store them, then clean the formats.
Design the layout: put headline numbers at the top, trends in the middle, and detail at the bottom, with consistent status colors.
Set targets and status thresholds: define the green, yellow, and red limits from the last 6 to 12 months of data.
Set refresh and access: schedule data refresh and restrict who can see each branch's data.
How to Build a KPI Dashboard in Power BI
You build the dashboard in Power BI Desktop and publish it to the Power BI service so other teams can open it. Follow these steps:
Connect the data sources: in Power BI Desktop, choose Get Data and connect your ERP database, Excel files, or CRM source.
Clean the data with Power Query: change data types, combine branch tables, and remove duplicates.
Build the data model: separate the transaction table from the date, branch, and product tables, then link them with relationships. Keep targets in their own table, for example loaded from an Excel sheet, because the KPI visual needs a target value.
Write the KPI measures in DAX: for target achievement, use Achievement = DIVIDE(Actual], Target]). If the target is zero, DIVIDE returns blank and shows no error.
Choose the visuals: use the new Power BI card visual to build KPI cards for headline numbers, the KPI visual for value against target with a trend, and a bar chart to compare branches.
Add status colors: set conditional formatting so numbers turn green, yellow, or red against the thresholds you defined.
Publish and schedule refresh: send the report to the Power BI service and schedule data refresh. Use row-level security (restricting data per user) so each branch sees only its own data.
A KPI visual in Power BI needs one value measure, one target, and one trend axis. Set the sort order of the trend axis before you convert the visual to a KPI. The team that maintains the dashboard should know Power Query and DAX.
Mistakes to Avoid When Building a KPI Dashboard
Five mistakes make people open a dashboard once and then abandon it:
Too many KPIs: a page full of numbers leaves users unsure which ones need action.
Different definitions across units: turnover or sales calculated with different formulas cannot be compared.
No targets or status thresholds: a number without a benchmark does not show whether performance is good or bad.
No KPI owner: when a number drops, nobody follows up.
Stale data: a dashboard showing figures that are two weeks old loses its users' trust.
KPI Dashboards for Companies With Many Systems
In large companies, the hardest part of building a KPI dashboard is unifying data from different systems. BI Solusi connects ERP, CRM, HRIS, and spreadsheets into one data model through Power BI implementation services, then builds dashboards around the KPI definitions you agree with each department.
If you already have a KPI list but no way to track it on one screen, tell us what you need and we will walk through the first steps with you.
Frequently Asked Questions
How many KPIs should a dashboard have?
As a rule of thumb, 5 to 9 headline numbers per page keep users focused. Supporting KPIs belong on a detail page.
How often should a KPI dashboard refresh?
Refresh frequency follows the dashboard type: operational dashboards refresh daily or near real time, while strategic dashboards need only a monthly or quarterly refresh. Match the refresh schedule to the meeting that uses the dashboard.
What is the difference between a KPI dashboard and a regular dashboard?
A KPI dashboard shows only indicators tied directly to business goals, with targets and status. A regular dashboard can show any data without comparing it with a target.
Can you build a KPI dashboard for free?
Yes, for personal use or a small team: Power BI Desktop and Looker Studio are free for building reports, and Excel adds no cost if your company already has it. Sharing a Power BI dashboard with many branches requires Power BI licenses or capacity, and BI Solusi can help you choose the right license option.
What are the four KPI perspectives?
The four perspectives in the balanced scorecard are financial, customer, internal process, and learning and growth. Companies typically pick a few KPIs from each so that monitoring covers more than financial figures.
BI Solusi is your trusted partner for data-driven success in Indonesia, serving companies in the Southeast Asia region and beyond. We specialize in implementing cutting-edge Data Analytics, Business Intelligence platform, and Big Data solution, complemented by expert Data Science services.
We offer flexible nearshore and offshore BI implementation models to meet your specific needs and deliver the highest-quality results.
Our BI Consulting expertise encompasses Data Integration services (ETL), Data Warehousing, and the utilization of Data Visualization tools such as Microsoft Power BI, Qlik Sense, and Tableau for Reports and Dashboards implementation.
Let us help you unlock the full potential of your data and achieve your business goals.
Comments