Internal Dashboards: What UK businesses Actually Need

There are two types of UK Business when it comes to dashboards. The first type has no dashboard at all — the director checks the bank balance, asks team leads how things are going, and makes decisions based on gut feeling and experience. The second type has a dashboard covered in charts that nobody looks at because it does not show anything useful.

Both are solvable problems. But solving them requires starting with the right question: what decisions does this dashboard need to support?

Why Most Dashboards Fail

The standard approach to building a business dashboard is backwards. Someone decides they need a dashboard, subscribes to a tool, connects some data sources, and ends up with a screen full of charts showing website traffic, social media followers, email open rates, and other metrics that look impressive but do not drive business decisions.

A dashboard that shows you things you cannot act on is decoration. A dashboard that shows you things you need to know — and alerts you when something needs attention — is infrastructure.

The difference is starting with decisions rather than data.

What UK businesses Should Actually Track

After working with businesses across Yorkshire, we have found that most need visibility on four things. Everything else is either secondary or vanity.

1. Revenue and Cash Position

Not just revenue — cash. A profitable business can fail if cash flow is wrong, and most small business owners in the UK know this from experience.

What to show:

• Current bank balance (pulled from your accounting software)
• Revenue this month versus target and versus the same month last year
• Outstanding invoices and their age
• Recurring revenue versus one-off revenue
• Cash flow forecast for the next 30, 60, and 90 days

Why it matters: You should never have to log into Xero or QuickBooks to know whether you can afford to hire, invest, or take on a project. This should be visible at a glance, every morning.

2. Pipeline and Work in Progress

Whether you sell products, services, or projects, you need to see what is coming in, what is in progress, and what is about to complete.

What to show:

• Number and value of active quotes or proposals
• Conversion rate from quote to job
• Work in progress — how many jobs are active, what stage are they at
• Upcoming deadlines and milestones
• Any jobs that are overdue or at risk

Why it matters: This is the early warning system. If your pipeline is empty, you know to increase marketing or sales activity now, not in three months when revenue drops. If jobs are consistently overrunning, you can investigate before it becomes a crisis.

3. Team Utilisation and Capacity

For service businesses — and most UK businesses are service businesses — your team is your capacity. If you do not know how much capacity you have, you cannot make good decisions about taking on new work.

What to show:

• Current workload per team member or team
• Availability for the next two to four weeks
• Overtime and underutilisation trends
• Skills or roles that are consistently at capacity

Why it matters: Saying yes to a new client when your team is already at 110% leads to quality problems, missed deadlines, and staff burnout. Saying no when you actually have capacity means lost revenue. Visibility solves both problems.

4. Customer Satisfaction Signals

This does not mean NPS scores or survey results, although those can be useful. It means the leading indicators that tell you whether customers are happy before they tell you they are not.

What to show:

• Support tickets or complaints — volume and resolution time
• Review scores across platforms
• Client churn or contract renewals
• Repeat business rate
• Response time to enquiries

Why it matters: Losing a customer is expensive. Spotting the warning signs early — increasing support requests, slower responses, longer resolution times — lets you intervene before the relationship deteriorates.

Off-the-Shelf Options: When They Work

Let us be fair to the existing tools. For many businesses, an off-the-shelf dashboard product is perfectly adequate.

Power BI

Microsoft's business intelligence tool. Strong data visualisation, good integration with Microsoft 365, and a decent free tier. Works well when your data is in structured sources like SQL databases, Excel files, or Microsoft-connected services.

Best for: Monthly or weekly reporting, financial analysis, businesses already in the Microsoft ecosystem.

Limitations: Requires someone with Power BI skills to build and maintain dashboards. Not great for real-time operational views. Can become expensive at scale.

Looker (Google)

Part of Google Cloud. Powerful for businesses with data in Google-connected systems (Google Analytics, BigQuery, Google Sheets).

Best for: Data-heavy businesses, companies using Google Cloud, marketing analytics.

Limitations: Steep learning curve, expensive, over-engineered for most SME needs.

Databox, Geckoboard, Klipfolio

Purpose-built dashboard tools that connect to common business platforms. Easier to set up than Power BI, with pre-built templates for common metrics.

Best for: Quick wins, marketing dashboards, businesses that use common SaaS tools.

Limitations: Limited customisation, may not connect to all your data sources, recurring subscription costs that add up.

When a Custom Dashboard Makes Sense

A custom dashboard is worth building when:

Your data lives in systems that off-the-shelf tools cannot reach. If you use industry-specific software, legacy systems, or custom databases, pre-built connectors may not exist. A custom dashboard can pull from any system with an API — and for systems without APIs, we can build middleware that bridges the gap.

You need real-time operational data, not just reports. Off-the-shelf tools are designed for periodic reporting. If your business needs to see what is happening right now — jobs in progress, team locations, stock levels — a custom dashboard built for that purpose is fundamentally different.

Different roles need different views. The director needs a strategic overview. The operations manager needs job-level detail. The sales team needs pipeline metrics. A custom dashboard serves each role with exactly the information they need.

You want it to trigger actions, not just display data. A custom dashboard can include alerts, notifications, and action buttons. When a metric crosses a threshold — overdue invoices exceed a certain amount, a job falls behind schedule — the dashboard can notify the right person automatically.

For more on how custom software fits into business operations, see our guide on how custom software improves operational efficiency.

Building a Dashboard That Gets Used

The most important test of a dashboard is whether people actually look at it. Here is what we have learned about building dashboards that get used daily rather than forgotten after a week:

Put it on a screen. A dashboard that requires logging into a website and navigating to a page will not get used. Put it on a TV in the office, make it the default browser tab, or build it as a mobile app that staff check over morning coffee.

Show fewer things. Every metric you add dilutes the others. Start with four to six key metrics. Add more only when someone specifically requests them — and ask why they need them.

Make it obvious. Red means bad. Green means good. A number going up with an arrow is better than a chart that requires interpretation. The best dashboards can be understood in under five seconds.

Keep it current. A dashboard showing yesterday's data is useful. A dashboard showing last week's data is a report. A dashboard showing last month's data is a history lesson. Aim for real-time or same-day data wherever possible.

Connect it to action. Every metric on the dashboard should have a clear "so what." If revenue is below target, what do you do? If a job is overdue, who is responsible? If the answer is "nothing" or "nobody," the metric does not belong on the dashboard.

Getting Started

If you currently have no dashboard, start simple. A single-page view pulling data from your accounting software and CRM — showing revenue, pipeline, and outstanding invoices — will give you more operational visibility than most UK businesses have.

If you have a dashboard that nobody uses, the problem is almost certainly that it shows the wrong things. Strip it back to the four metrics that matter and rebuild from there.

Either way, the goal is the same: a tool that gives you the information you need to make better decisions, faster, without asking anyone or opening a spreadsheet.

If you want to explore what a custom dashboard could look like for your business, get in touch. We will start by understanding what decisions you need to make and work backwards from there to design something genuinely useful.