A good KPI dashboard answers one question for one person: are we on track this week? The six examples below (finance, sales, marketing, operations, customer service and an owner's summary) show which metrics belong on each, how many to show, and how to lay them out so people actually open the page.
We build these systems for small and medium businesses in Surrey and Metro Vancouver, so the examples lean on what we see in owner-run firms: a handful of tools, a spreadsheet or two, and not much time. You do not need a data team. You need a short list of numbers you trust.
Table of Contents
- What does a KPI dashboard actually show?
- How many KPIs should one dashboard have?
- Six KPI dashboard examples for a small business
- How do you design a dashboard people will actually use?
- Spreadsheet, template or custom build?
- What does it take to build a KPI dashboard?
- Common mistakes we see
- Our perspective: start with the question, then the tool
- When it makes sense to get help
- FAQ
- Sources
What does a KPI dashboard actually show?
A KPI dashboard pulls data from your different sources into one place and shows, at a glance, how you are doing against your targets. Microsoft describes it as a way to unite data sources and give visual feedback on performance, with a KPI being a measurable value that shows how effectively a business is meeting its goals.
The reason to bother is visibility. The Business Development Bank of Canada notes that as a company grows, the line of sight to sales or production gets blurry, which makes it harder to act early instead of waiting for month-end or year-end statements. A dashboard puts that line of sight back.
Two things a dashboard is not:
- It is not a report. A report explains; a dashboard flags. If you need three paragraphs to read it, it is the wrong format.
- It is not a trophy wall. Every number should lead to a decision, even if the decision is "nothing to do this week."
How many KPIs should one dashboard have?
Fewer than you think. BDC's guidance is that good KPIs are targeted to a specific level of the business, practical to collect (ideally automated), and sufficient without being excessive. In practice, we aim for five to eight numbers per dashboard, each with a target and a trend line.
A quick filter for each candidate metric:
- Who owns it? If nobody can change it, it is trivia.
- What would we do if it moved 20% the wrong way? If the answer is "nothing," drop it.
- Can it be refreshed without someone retyping data? If not, it will go stale within a month.
Six KPI dashboard examples for a small business
Each example lists the metrics, the layout and the question it answers. Targets are yours to set from your own history; we have deliberately not put benchmark numbers here, because they vary too much by industry to be useful without a source.
1. The owner's weekly summary
Question it answers: Is the business healthy this week?
This is the one-page view that sits above everything else. It borrows one or two numbers from each department dashboard below.
- Revenue this month against the same point last month
- Cash on hand
- Open pipeline value
- Jobs or projects in progress and how many are late
- Customer issues unresolved past your service promise
Put it on a single screen with no scrolling. If you run it in a Monday meeting, everyone sees the same numbers at the same time, which ends the "my spreadsheet says otherwise" conversation.
2. Finance dashboard
Question it answers: Are we making money, and will we have cash to pay for next month?
For financial performance, BDC recommends tracking revenue growth, net and gross profit margins, cash on hand and inventory turnover. Add two more that matter to most service businesses: unpaid invoices by age (0 to 30, 31 to 60, 60+ days) and revenue by client or project type.
| Metric | Why it earns a spot | Typical source |
|---|---|---|
| Revenue vs. last period | Shows direction | Invoicing or accounting system |
| Gross margin | Shows whether pricing holds | Accounting system |
| Cash on hand | Shows runway | Bank feed |
| Receivables by age | Shows who is slow to pay | Invoicing system |
| Inventory turnover (if you stock goods) | Shows tied-up cash | Inventory system |
If you bill by the hour, add profit per project. We cover that in our project profitability reporting template for services firms. Labour is often the biggest cost, so tracking hours accurately matters too: this piece on time tracking ROI for billable teams and field crews shows how hours data feeds profitability numbers.
3. Sales dashboard
Question it answers: Will we hit the number, and where are deals stalling?
- New leads this month, by source
- Lead-to-quote and quote-to-win rates
- Open pipeline value by stage
- Average deal size
- Days from first contact to signed work
The layout matters here. Put pipeline by stage as a simple funnel or bar chart in the centre, and the win rate beside it. The most useful number is usually not total sales but the stage where deals sit longest.
4. Marketing dashboard
Question it answers: Which channels bring in customers worth keeping?
Most free marketing templates you will find online are built around ad platforms: spend, clicks, impressions. Those are inputs. A small business dashboard should connect them to outcomes.
- Website visits and enquiries, by channel
- Cost per enquiry and cost per new customer
- Enquiry-to-customer rate
- Revenue from each channel, where you can trace it
- Repeat or referral share of new work
Be strict about vanity metrics. DigitalEnabler warns against follower counts and likes that do not lead to actionable insight. Followers are fine to watch if they drive enquiries. If they do not, leave them off.
To build one, start with a spreadsheet that has one row per enquiry: date, source, outcome, value. Once that is filled in for a couple of months, you will know which numbers deserve to be automated. Our piece on customer journey analytics for SMBs explains how to connect the same person across channels so these numbers are not double counted.
5. Operations dashboard
Question it answers: Is work getting done on time, and where is it piling up?
- Jobs started, completed and overdue
- Average turnaround time
- Scheduled hours vs. available hours (utilization)
- Rework or error rate
- Admin hours spent on repeat tasks
That last one is often the most revealing. Many owners are surprised by how much of a week disappears into re-entering data between tools. Our operational efficiency metrics and scorecard walks through four numbers that cover most of this ground.
6. Customer service dashboard
Question it answers: Are customers getting answers fast enough, and are they happy?
- Open requests and age of the oldest
- First response time
- Time to resolution
- Customer satisfaction score from a one-question survey
- Top three reasons customers contact you
The last item is the hidden gem. If the same question keeps arriving, you have a candidate for a better FAQ page or an AI chatbot for customer service. The chatbot is not the goal; fewer repeat questions is.
How do you design a dashboard people will actually use?
Design rules are mostly about restraint. Smartsheet's guidance on operations dashboards boils down to current, logically organized data that syncs automatically, reflects its audience, stays simple, and puts the important data in the upper left and centre. Our working version:
- One audience per dashboard. The owner, the bookkeeper and the service lead need different views. Build separate ones rather than one crowded page.
- Biggest number top left. People read in an F shape. Put the headline KPI there, with its target next to it.
- Always show a comparison. "42 open jobs" means nothing. "42 open jobs, up from 31 last week" means something.
- Use colour for exceptions only. If everything is red, green and amber, nothing stands out. Colour a number only when it crosses a threshold you chose in advance.
- Pick the simplest chart. A number with a sparkline, a bar chart or a table covers 90% of needs. Skip 3D charts and gauges.
- Label the definition. "Active customer" should mean the same thing to everyone. Write the definition in small text under the metric.
- Show when it last refreshed. A dashboard people cannot trust is worse than none.
Smartsheet also points out that dashboard projects need active executive sponsorship or they fade as business priorities shift. In a small firm, that means the owner uses the dashboard in a regular meeting. If it is never discussed, it will quietly die.
Spreadsheet, template or custom build?
There is no shame in starting with a spreadsheet. DigitalEnabler suggests using one to establish and confirm your KPIs for the first one to two months before moving to a more advanced business intelligence tool. We agree. It forces you to decide what you actually want to measure before you spend money on tooling.
For finance, BDC also offers a free Excel income statement template (in French on its site) that can feed your profit and margin figures.
Here is how the three paths compare:
| Spreadsheet | Off-the-shelf dashboard tool | Custom-built system | |
|---|---|---|---|
| Setup effort | Low | Medium | Higher, handled by us |
| Data refresh | Often manual | Automatic for supported tools | Automatic from your own systems |
| Fit to your process | Whatever you build | Template-driven | Built around how you work |
| Breaks when | Someone edits a formula | Your tools are not supported | Rarely, with proper support |
| Best for | Testing your KPIs | Standard needs, few tools | Many tools, repeated data entry |
The signal that you have outgrown a spreadsheet is simple: someone spends hours each week copying numbers from your CRM, invoicing tool and scheduler into one file. That copying is the cost a dashboard should remove.
What does it take to build a KPI dashboard?
Here is the sequence we follow, scaled down for a small business.
- Write down five decisions you make regularly. For example, whether to hire, chase a late payer, or push a channel. Metrics come from decisions, not the other way around.
- Choose one to three KPIs per decision. Define each in a sentence, with an owner and a target.
- Map where each number lives. CRM, invoicing, scheduling, bank, website analytics. Note which can export or connect automatically.
- Prototype in a spreadsheet. Run it for four to eight weeks. Drop numbers nobody looked at.
- Clean the data at the source. Inconsistent customer names or missing job codes will wreck any chart. Our guide to self-service analytics for SMBs starts with ten questions that expose these gaps.
- Automate the refresh. This is where you decide on a tool, or a custom build. If your data sits in many systems, read our take on data integration for Canadian SMBs.
- Review it on a schedule. Weekly for operations and sales, monthly for finance and strategy. Retire a metric each quarter if it has not driven a decision.
If you handle customer data, check privacy obligations before connecting systems. Our note on workflow automation and PIPEDA covers the basics, and your lawyer or privacy officer should confirm anything specific to your sector.
Common mistakes we see
- Tracking everything because you can. Twenty tiles means no one looks at any.
- Measuring activity, not results. Calls made is activity. Quotes accepted is a result.
- Mixing definitions. Revenue booked, invoiced and collected are three different numbers. Pick one per chart and label it.
- No targets. A number without a target is just a number.
- Building it for the owner only. If the people who change the numbers never see them, nothing improves.
- Expecting AI to fix messy data. AI summaries and forecasts are useful on top of clean data. On messy data, they produce confident nonsense. Be wary of anyone who promises otherwise.
Our perspective: start with the question, then the tool
We see the same pattern in most small firms. They have a CRM, an invoicing tool, a scheduler and a handful of spreadsheets, and the owner is the human connector between them. The dashboard request usually sounds like "we need better reporting," but the real problem is that the data lives in separate places and nobody trusts the totals.
Our view is that a dashboard is the visible tip of a connected system. If your tools share one source of truth, a dashboard is a few hours of configuration. If they do not, the dashboard becomes another thing someone has to update by hand. That is why we build around your actual processes, with CRM, invoicing, scheduling and reporting behind a single login, and why you own the code with no lock-in. Clients tell us they typically save 5 to 15 administrative hours a week once the repeat data entry is gone. That is a client-reported range, not a promise, and it depends on how fragmented things are today.
We also try to talk people out of overbuilding. If a spreadsheet answers your questions, use it. Come to us when the copying and reconciling is costing you more than the build would.
— Harry Gill
When it makes sense to get help
If your KPIs are clear but your data is scattered across tools, our data analysis and AI reporting service connects those sources and builds the dashboards your team will use. If you are not sure what to measure yet, an AI strategy consulting conversation is a lower-commitment place to start. For a sense of how this looks in practice, see our case study with a Surrey CPA firm. We work with businesses in Surrey, Vancouver, Richmond, Langley and across Metro Vancouver, with fixed pricing and regular milestones.
FAQ
What are the main types of KPI dashboards?
Most are described as operational (what is happening now), strategic (progress against long-term goals), analytical (trends and deeper analysis) and tactical (short-term projects and departments). For a small business, the six examples above map onto these: the owner summary is strategic, finance and sales are tactical, and operations and customer service are operational.
How many KPIs should a small business dashboard have?
Aim for five to eight per dashboard. BDC advises that KPIs be sufficient without being excessive, so each metric should have an owner, a target and a decision attached. If you cannot say what you would do when it changes, remove it.
Can I build a KPI dashboard in Excel or Google Sheets?
Yes, and it is a good first step. Use it to confirm which metrics you actually review before investing in automation. Move on when the manual copying between systems starts to eat hours every week or when errors creep in.
What is the difference between a KPI and a metric?
A metric is any number you can measure. A KPI is a metric tied to a business goal, with a target and an owner. Website visits are a metric; enquiries per month against a target of 40 is a KPI.
Sources
- What Is a KPI Dashboard, Microsoft Power BI
- Key Performance Indicators (KPIs): How to Set the Right Ones, BDC
- Free income statement template, BDC
- Creating Operations Dashboards, Smartsheet
- KPI Dashboard Template, DigitalEnabler
- Time Tracking ROI for Billable Teams and Field Crews