KPI dashboard for small businesses: which numbers to watch and how to get them automatically
Most owners have more data than they use: the till, accounting, booking system, CRM and ads all produce numbers. What is missing is one page that shows the few figures that matter, every week, without anyone copying them together by hand.
Few numbers, clear questions
A useful dashboard answers four questions: are we selling enough, do we have enough money, are customers coming back, and are we working efficiently? Five to ten numbers are enough. Every number needs an owner and a target, otherwise nobody acts on it.
Examples by industry
The right numbers depend on the business:
- Restaurant: covers per day, average bill, food cost ratio, labour cost ratio, share of online reservations.
- Hotel: occupancy, average daily rate, revenue per available room, share of direct bookings.
- Service business: new enquiries, conversion rate, average order value, utilisation of the team.
- Online shop: sessions, conversion rate, average basket, returns rate, contribution margin per order.
Leading and lagging indicators
Revenue and profit show what has already happened. Enquiries, reservations for next week or the order pipeline show what is coming. A good dashboard combines both, so you can act before the month is lost.
Automate the data
Manual reports stop after a few weeks. Connect the sources directly: the till system, accounting, booking engine, CRM and ad accounts deliver data via interfaces into a dashboard or a shared spreadsheet. Updates run daily or weekly, and an alert reports unusual values.
Costs and next steps
A simple dashboard with three to five data sources is usually a project of a few days. The effort depends on whether your systems offer interfaces. We connect the sources, define the numbers with you and hand over a dashboard your team actually uses; tell us your systems, and you will receive a fixed price.
Frequently asked questions
- Which tool should we use for the dashboard?
- For small businesses, Google Looker Studio, Power BI or a well-built spreadsheet are often enough. More important than the tool is a reliable automatic data feed.
- How often should we look at the numbers?
- Operational numbers weekly, financial numbers monthly. Daily only for things you can influence daily, such as reservations.
- What if our systems have no interfaces?
- Exports by email or file can often be processed automatically. We check this before quoting.
Tell us which systems you use and which questions you want answered every week. We will propose the numbers and connect the sources.
Request a dashboard