Dashboards and business intelligence
A business intelligence consultancy builds the KPI dashboards and management reports a business runs on, in the tool you already license. Every KPI's definition, formula, source and owner is agreed in writing first, so when a number is questioned the answer is already written down.
One KPI, two definitions, 422 customers apart
Active customersOctober 2026 (the 12 months to 31 October)
Sales definition
4,812
Customers with at least one order in the last 12 months.
The gap
422
Customers whose only orders in the window were fully refunded.Finance definition
4,390
Customers invoiced in the last 12 months, leaving out anyone whose orders were all fully refunded.
| Name | Definition | Formula | Source | Owner |
|---|---|---|---|---|
| Active customers | A customer with at least one invoiced order in the last 12 months that wasn't fully refunded. | Count of distinct customer IDs on invoices dated in the 12 months to the end of the reporting month, excluding invoices whose order was fully refunded. | finance.invoices, joined to finance.refunds on order ID | Financial controller |
NoteThe sales count stays on the dashboard, renamed “Ordering customers (12 months)”.
What this fixes
Four signs the reporting has stopped settling arguments.
What you get
The definitions log, model, dashboard and handover you keep.
A dashboard is finished when someone other than the person who built it can keep it running.
Dashboard development, stage by stage
From agreed definitions to a dashboard your team runs.
- 1
Scoping
Start from the decisions the dashboard serves and the KPIs they need, then agree each definition in the log. A disputed KPI, like the active customers count above, gets both versions written down and one chosen, with the other renamed.
- 2
Build
Each measure is written from its line in the definitions log and carries that line's name. Pages come last, in Power BI or Data Studio (formerly Looker Studio).
- 3
Handover
The person who'll maintain it changes a figure and republishes while the builder watches.
- 4
Afterwards
The definitions log, the model and the refresh account sit in your systems, under your logins. A definition changes only when its named owner approves it.
Where data visualisation goes wrong
Ownerless KPIs and silent refresh failures, and the guard for each.
Definitions get agreed before anything is built. A chart drawn on a number nobody agreed only moves the argument to a better-looking page.
MI reporting and board packs
The monthly pack, built on the dashboard's measures.
MI reporting uses the same measures as the dashboard, laid out for the monthly meeting: fewer figures, each set against budget and last year, with a line of commentary from the person who owns it. The finance dashboard in our KPI library shows that pack on example data, with the formula behind each line.
Power BI
Power BI has a page of its own, Power BI consultant, because star schema modelling, DAX measures and the choice between Pro, Premium Per User and Fabric capacity need more room than a paragraph.
KPI dashboards by industry
Where each sector's KPI arguments usually start.
Questions people ask
Choosing a BI tool, and working without a warehouse.
Do you build KPI dashboards for ecommerce?
Yes. The usual set covers net revenue after refunds, orders, average order value, repeat rate and active customers. Each one goes in the definitions log first, with a note of whether its count comes from the shop platform or the finance system.
Which BI tool should we use?
Usually the one you already license, provided someone on your team can maintain it. A tool nobody in-house knows turns every change into a request to whoever built the dashboard. We build in Power BI and Data Studio. If your data sits in a warehouse such as BigQuery, Data Studio connects to it directly.
Can you work with our existing data warehouse?
Yes. The dashboards read from your warehouse through an account you create, and any modelling happens in views or tables inside it that you can see and keep.
What if we don't have a data warehouse?
A small setup can model straight from the source systems' own connectors or from scheduled exports. Once several systems need joining, or history needs keeping that the sources overwrite, a warehouse comes first, and that's data infrastructure work.
Who maintains the dashboards afterwards?
Your team. Handover leaves an owner named against every definition and one person trained to change a figure, republish and check the refresh ran. In Power BI, the refresh failure email goes to that person.
Book a call about your reporting
Bring the KPI that causes the most argument. The first call works out what its definition should be and who should own it.