Portfolio / Case study 01
One dashboard for payroll, budgets, expenses and cash flow across a team of 50+ people, so managers stopped waiting for month-end spreadsheets.

Project walkthrough

$ start project "Multi-department KPI dashboard"
✓ Brief agreed with Big Bear Vans
✓ Mapped every data source and agreed one set of KPI definitions
✓ Built a shared model for payroll, budgets, expenses and cash
✓ Designed the dashboard around the questions managers actually asked
→ Review with the client…
● Delivered and handed over
The project
Each department tracked its numbers in its own sheet. Payroll, purchasing and project costs lived in different places, so nobody saw the full picture until the month was already closed.
Managers could check spend against budget during the month instead of after it, and payroll cost by department was visible in one place.
Before opening Power BI, I spent the first stage of the project on definitions rather than charts. A dashboard is only as useful as the numbers behind it, and in a company where payroll, purchasing and project costs are kept by different people, the same word can mean three different things. I sat with each department lead, wrote down what spend, budget used and headcount cost meant to them, and agreed one definition that everyone would report against.
Once the definitions were settled, I built one shared model in Excel that fed Power BI. Each department kept updating the sheet it already knew, but the figures flowed into one place with the same categories and the same month-end cut-off. Managers did not have to change how they worked for the dashboard to be accurate, which is a big reason it was actually used.
I designed every page around a question a manager really asks, not around what was easy to chart. If a number did not help someone make a decision, it was left off.
The approach works at almost any size. Agree the definitions first, choose one source of truth for each type of number, and only then build the report. Keep the monthly update simple enough that the person responsible can finish it without help, and name that person so nothing depends on memory.
If your team is also working from separate spreadsheets and waiting for month-end to see where the money went, the same steps apply. I am happy to talk through what this would look like with your own numbers.
Gallery and links
Figures are anonymised. Click an image to enlarge it.



Services used
Let's connect
Book a free 30-minute call on Google Meet, or reach me directly.
We use cookies to improve your experience on our site. By using our site, you consent to cookies.
Manage your cookie preferences below:
Essential cookies enable basic functions and are necessary for the proper function of the website.
You can find more information in our Privacy Policy and .