Operational Dashboards for SMEs
Glasgow Custom Software Development - Software Built Just for You
Real-time operational dashboards (not yet another BI report)
An operational dashboard is a single screen that shows what's happening in your business right now (orders being picked, tickets waiting on a reply, stock about to run out, deliveries in flight). Different from a BI dashboard, which looks at last quarter's patterns. UK SMEs use operational dashboards to stop chasing status updates and start running the day from one screen.
What an operational dashboard actually shows
The content depends on the role. We build the dashboard around the person looking at it (not a generic template):
- Operations manager: orders in progress by stage, late deliveries flagged red, capacity vs demand for the next 7 days.
- Sales director: deals at each pipeline stage, value closing this month, % to target, deals stalled over 14 days.
- Customer success lead: open tickets by SLA, first-response time today, CSAT trend last 7 days.
- Warehouse manager: stock across each site, pick queue length, dispatches due today, low-stock alerts.
- Production manager: throughput per line in the last hour, downtime reasons, scrap rate vs target.
- Founder / MD: cash in the bank today, revenue this week vs last week, top three OKRs (objectives and key results) with a traffic light each.
One screen. One glance. No "let me pull the report and get back to you" (which is what kills most decisions in growing businesses).
How operational dashboards differ from BI dashboards
They answer different questions, so they tend to need different builds.
Operational dashboards answer "what's happening right now and what needs my attention?" They update in near real-time (seconds to minutes). They alert you when a number goes the wrong way. They live on the warehouse wall, the support team's second monitor, the founder's phone. The metric matters today, sometimes this hour.
BI dashboards answer "what happened last quarter and what should we do next?" They update overnight. They surface patterns, trends, and predictions across months or years of history. They live in board packs and strategy reviews. The metric matters for the next big decision.
Most SMEs need both, viewed by different people. The warehouse manager doesn't need a 12-month trend chart. The MD doesn't need to refresh open-ticket counts every 30 seconds. If you want historical reporting and trend analysis, see our Business Intelligence page instead.
Key Benefits
Looking for analytics dashboards instead?
If you need historical reporting, trend analysis, or strategic insight rather than real-time visibility, you're on the wrong page. See Business Intelligence for historical reporting and predictive analytics, or Data Visualisation for chart-led storytelling and presentation-ready visuals.
How It Works
We don't sell a dashboard product. We build one for your business, on top of the systems you already use.
Step 1 — Pick the role and the decisions. We sit with the person who'll use it (warehouse manager, sales director, founder). What decisions do they make every day? What numbers would change those decisions? Anything else is noise.
Step 2 — Map the data sources. Most SMEs already have the data. It's just trapped in different tools (CRM, ERP, ecommerce, accounting, support desk, spreadsheets on a shared drive). We pull from Xero, Sage, HubSpot, Salesforce, Shopify, Zendesk, Microsoft 365, and most major UK SME stacks. Custom APIs (application programming interfaces) for anything bespoke.
Step 3 — Build, show, refine. Working dashboard at the end of week 2. You try it, tell us what's missing or what's clutter, and we iterate every fortnight until it earns its place on the screen.
Step 4 — Host it properly. AWS-hosted (ISO 27001 and GDPR compliant). Mobile-responsive so the warehouse manager checks stock from the floor and the sales director checks pipeline from the car park. Role-based access so the team only sees what's theirs.
Step 5 — Alerts that pull people back. A dashboard nobody opens is wasted money. We add alerts (email, Slack, Teams) for the numbers that matter, so the dashboard chases you when something needs attention.
Common Use Cases
Common Questions
Q: What does an operational dashboard cost? A: Typical range £12,000 to £35,000 depending on how many data sources we connect and how many user views you need. A single-role dashboard on top of one system starts around £8,000. Fixed price, quoted upfront.
Q: How long does it take? A: First working version in 2 weeks. Most projects go live in 6 to 10 weeks. We work in fortnightly sprints so you see real progress every two weeks, not a black box for three months.
Q: What systems can you pull data from? A: Xero, Sage, QuickBooks, HubSpot, Salesforce, Pipedrive, Shopify, WooCommerce, Zendesk, Microsoft 365, Google Workspace, Stripe, most major ERPs, and anything with an API (application programming interface). Even legacy systems — we've connected to Access databases and spreadsheets on shared drives.
Q: Will it work on mobile? A: Yes. Built mobile-first so warehouse managers check stock from the floor, sales directors check pipeline between meetings, and founders check cash from anywhere.
Q: Do I need a data warehouse first? A: No. For most SMEs a data warehouse is overkill. We connect to your live systems directly, or use a lightweight cache where the source is too slow to query in real time. If you outgrow that, we'll build the warehouse too — but only when you need it.
Q: Who can see it? A: You decide. Role-based access means the warehouse team sees stock and dispatch, the sales team sees pipeline, the senior team sees everything. Single sign-on (SSO) via Microsoft 365 or Google Workspace is standard.
Q: What if my dashboard needs change? A: They will. We build dashboards to be edited, not rebuilt. You can change thresholds and filters yourself. For bigger changes we handle it on a rolling basis — most clients keep us on a light retainer for exactly this.
Q: Can I export to Excel? A: Yes, every view exports to Excel or CSV. The dashboard is for live decisions; the export is there for when someone wants to slice the numbers their own way.
"We were managing orders, inventory, and production across 8 Excel files. Version control was a nightmare. Now it's one system, one screen, real-time. 15 hours per week back in our lives."