How to build a KPI dashboard your team will actually use

By Ranjit Bhinge, founder of Blur Studio · Updated October 24, 2026 · 7 min read

Short answer: A KPI dashboard shows the few numbers that tell you how your business is doing, updated by itself from the tools you already use. Start with five to eight numbers, name one owner for each, and connect them to a free or low-cost tool such as Google's Data Studio, Power BI or Databox. Choose a custom dashboard when your data sits in systems these tools cannot reach or you need to show it inside your own app.

You want a dashboard your team actually opens every week.

I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.

What is a KPI dashboard?

KPI stands for key performance indicator. A KPI is a number that tells you if an important part of the business is on track. Examples include monthly revenue, cash in the bank, new leads, jobs completed and customer reviews.

A KPI dashboard puts those numbers on one screen. It pulls data from your tools on a schedule, so nobody has to type it in. A good business dashboard answers one question in under a minute: "Are we on track this week?"

Why do most dashboards get built once and never opened again?

Informal industry polling suggests only around 30% of dashboards are still actually being used three to six months after they were built. The other 70% get opened once at launch and then quietly ignored. The reasons are consistent enough to plan around.

The wrong metrics, for the wrong audience. A dashboard built around what is easy to measure instead of what the viewer actually needs to decide gets opened once and abandoned, no matter how well it is designed.
Too many numbers on one screen. Handed 20 charts instead of the 3 that actually matter, most people give up and go back to asking someone directly or opening the old spreadsheet.
No single source of truth. If the dashboard number and the spreadsheet number disagree, people stop trusting the dashboard, not the spreadsheet.
Raw numbers with no threshold. Even an expert rarely holds a reliable sense of what "good" looks like for dozens of different measures. A number with nothing to compare it to does not answer the question "is this okay."

The fix is a clear hierarchy, not more charts. A useful starting structure is 3 to 5 top-level numbers that answer one question, is everything okay right now, with the detail behind each one available but not forced onto the first screen. Decide what those 3 to 5 numbers are before you decide what the dashboard looks like.

Which KPIs should a small business track?

Pick five to eight numbers. More than that and people stop reading. Choose one or two from each part of the business.

Money: Revenue this month, gross margin, cash in the bank and unpaid invoices.
Sales: New leads, quotes sent, quotes won and average deal size.
Delivery: Jobs completed, jobs late and average time to finish a job.
Customers: Repeat customers, refunds and review scores.
Team: Billable hours or jobs per person.

For each number, write down four things before you build anything.

The exact definition: "Revenue" means invoiced or paid? Before or after tax?
The source: Which tool holds the true figure?
The owner: Which person explains the number when it moves?
The target: What does good look like this month?

This step matters more than the tool. Most dashboards fail because two people define the same number in two ways.

What tools can you use to build a business dashboard?

These are popular tools a non-technical owner can use. I took each price from the vendor's own pricing page in October 2026, and all are in US dollars.

Tool	Best for	Listed price
Data Studio (formerly Looker Studio)	Google Sheets, Google Ads and Google Analytics users	Free; Pro is $9 per user per project a month
Power BI	Businesses on Microsoft 365 and Excel	Free to build alone; Pro is $14 per user a month paid yearly; Premium Per User is $24
Databox	Owners who want ready-made links to sales and marketing tools	Free plan; Analyst $71 a month billed yearly; Team plans cost more
Custom dashboard	Data from many systems, or a dashboard inside your own app	Quoted per project

Data Studio (formerly Looker Studio)

Google has gone back to the name Data Studio for the tool many people know as Looker Studio. It is free for people who build reports and people who view them. Google says it connects to more than 1,400 data sources, including Google Sheets, Google Ads, BigQuery and Google Analytics. The Pro version adds team management and Google Cloud support.

Power BI

Power BI is Microsoft's reporting tool. You can build reports for free in Power BI Desktop. To share reports with your team, each person needs a Pro or Premium Per User license. Microsoft includes Power BI Pro in Microsoft 365 E5. Premium Per User adds larger data models and more frequent refreshes.

Databox

Databox is built for small teams that want quick results. Its free plan allows one user, three data sources and one dashboard, with data synced daily. Paid plans add more users, more sources and hourly syncs. Sharing by link and alerts start on the Team plans.

How do you build a KPI dashboard step by step?

You can build a first version in a day or two.

Write your KPI list: Use the four-part definition above for each number.
List your data sources: Note which tool holds each number and who has the login.
Pick a tool: Choose the one that connects to most of your sources with the least work.
Connect the sources: Use the tool's built-in links first. Put any manual data in one clean Google Sheet or Excel file.
Build one page: Put the five to eight KPIs at the top, each with its target. Add charts below for detail.
Set the refresh: Choose daily or hourly updates, based on how fast you act on the number.
Share it: Give view access to the people who own each number.
Review it weekly: Open the dashboard at your weekly meeting. Ask each owner to explain any big change.

Keep it simple

One screen: If people have to scroll a lot, cut numbers.
Trends over totals: Show this month next to last month and the same month last year.
Clear colors: Use green and red only for on target and off target.
No vanity numbers: Drop any number nobody acts on.

How do you automate reporting and Excel reports?

Many owners still build a weekly Excel report by hand. You can automate most of that work.

Connect at the source: Link the dashboard tool straight to your CRM, accounting and ad accounts. That removes the export and paste step.
Use one data sheet: If some data must be typed, have staff enter it in one shared sheet with fixed columns. The dashboard reads from it.
Send it out: Databox lists sharing and notifications on its Team plans and above, so the numbers reach your team without a manual report.
Use an automation tool: Tools like Zapier or Make can copy new records from one app into your data sheet. My guide to Zapier vs Make compares them.

AI can help too. Databox includes 50 AI credits a month even on its free plan, and AI can draft a short note on what changed this week. Check those summaries against the numbers before you act on them.

What are the limits of ready-made dashboard tools?

These tools work well for most small businesses. They do have limits.

Missing connectors: Your job software or industry tool may not link to them.
Messy data: A dashboard cannot fix bad data. If your CRM has duplicates, your numbers will be wrong.
Per-user fees: Sharing with a large team can get costly on some plans.
Outside viewers: Showing each customer their own numbers needs secure logins, which these tools are not built for.

When does a custom KPI dashboard make sense?

Buy a tool first. Most owners never need more. A custom dashboard fits better in a few cases.

Data in many systems: Your numbers live in job software, a database and several spreadsheets that no tool connects.
Numbers that need rules: Margin per job needs data from three systems combined with your own rules.
Customer dashboards: You want each client to log in and see their own results.
Inside your own app: The dashboard must sit inside a portal or app you already run.
Data control: You need the data kept in a system you own.

Often the real job is the data underneath. Once your data sits in one clean place, any dashboard tool works better. My guide to moving from Excel to a web app covers that first step.

How does Blur Studio approach dashboards?

I start with the decisions a client actually makes each week, and only then pick the numbers, usually no more than 3 to 5 at the top level, for exactly the reason covered above: a dashboard with too many numbers gets opened once and ignored. I check each data source and fix gaps at the source rather than papering over them on the dashboard itself.

I use a tool like Data Studio or Power BI when it genuinely fits. When it does not, I build a custom dashboard or a small internal tool that pulls the data together properly. You own the code and the accounts, and I take care of it after launch so the numbers stay trustworthy as your systems change.

Questions people ask

What should be on a KPI dashboard?

A KPI dashboard should show five to eight numbers that tell you if the business is on track, such as revenue, cash, new leads and jobs completed. Each number needs a clear definition, a target and one person who owns it.

Is there a free KPI dashboard tool?

Google's Data Studio, formerly Looker Studio, is free for people who build and view reports. Databox has a free plan with one user and three data sources, and Power BI is free to build reports on your own computer.

Is Power BI or Data Studio better for a small business?

Power BI suits businesses that use Microsoft 365 and Excel, and sharing needs a Pro license at $14 per user a month as of October 2026. Data Studio suits businesses that use Google Sheets and Google Ads, and it is free.

How often should a KPI dashboard update?

Update each number as often as you act on it. Sales and cash numbers often need daily updates, while customer reviews and margins can update weekly.

When do I need a custom dashboard?

You need a custom dashboard when your data sits in systems that standard tools cannot reach. It also fits when customers must log in to see their own numbers. The same goes for a dashboard that must live inside your own app.

How many metrics should actually be on the main dashboard screen?

Three to five, at the top level. That is the number most people can hold in mind and actually use to answer the question a dashboard exists to answer, which is whether things are okay right now. Everything else belongs one click deeper, not on the first screen.

Why does nobody on my team open our dashboard anymore?

This is extremely common, roughly 70% of dashboards see this happen within a few months. It is almost always the metrics or the audience, not the design. Ask the people who stopped opening it what decision they actually needed to make, and check whether the dashboard ever answered that specific question.

Roughly what does this cost?

As a broad reference, fixes and finishes start at around $1,500, and new builds start higher, always a fixed price agreed in writing before I start, never an hourly rate. My AI app cost guide explains what actually drives a quote up or down.

Is my project too small for this?

No. Most of the owners I work with have no tech team at all, that is the whole point. If the smarter move is a cheap software subscription instead of custom software, I will tell you that on the first call, even though it means I do not get paid.