Each page here is a working KPI dashboard for one team, drawn on the page from example data. Every figure comes with its formula, and every page ends with notes on building the same dashboard in the tool you already use.
KPI dashboards in the library
Each figure is the finding from that page's worked example.
Revenue finished November 4.2% under budget
Example data
£412Kin November, against a £430K budget
BudgetRevenue4.2% under
DecNov
Finance dashboardfinance dashboardThe monthly pack a finance lead takes to the board, with the formula behind cash runway, debtor days and every other line on it.
What every page gives you
What you can check on each dashboard page.
The exampleA dashboard built from a small data file and drawn on the page. Every figure on it is labelled as example data.
The KPI tableEach KPI with its formula in words, what a good reading looks like, and the mistake people commonly make with it.
The build notesData sources, grain and refresh cadence, then the modelling decisions to settle before anyone draws a chart.
The tool notesWhat Power BI, Data Studio (formerly Looker Studio), Excel and Google Sheets each handle well for that dashboard, and where each one struggles.
Write the formula down, or two people quoting “debtor days” will bring different numbers to the same meeting.
If you'd like one of these built on your own data, that's what our dashboards and BI service does. We agree the definitions with you first, in writing, then build the dashboard in the tool your team already opens.
Want this on your own numbers?
Tell us which figures your team argues about, and we'll start with their definitions.