Portfolio / Case study 01

DashboardsPayrollBudgeting

Multi-department KPI dashboard

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

ClientBig Bear Vans
IndustryVan conversion and manufacturing
My roleProject Accountant and Business Operations Manager
ToolsPower BI, Excel, ClickUp
Multi-department KPI dashboard for Big Bear Vans

Project walkthrough

See how the work was put together

Multi-department KPI dashboard for Big Bear Vans, project walkthrough
Multi-department KPI dashboardClick to play
finzain · project log

$ 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

Problem, approach and result

01

The challenge

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.

02

What I did

  • 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
03

The result

Managers could check spend against budget during the month instead of after it, and payroll cost by department was visible in one place.

How I approached the dashboard

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.

The questions the dashboard had to answer

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.

  • Are we on track against this month’s budget, department by department?
  • Which cost lines are moving faster than planned?
  • What does payroll cost for each department, and how is that changing?
  • How much cash is committed to purchases that have not been paid yet?
  • Which projects are using more than their allocated cost?

What a similar business can reuse

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

Screens from the project

Figures are anonymised. Click an image to enlarge it.

Multi-department KPI dashboard main screen
Main view
Multi-department KPI dashboard detail screen
Detail
Multi-department KPI dashboard report screen
Report

Let's connect

Want something like this for your business?

Book a free 30-minute call on Google Meet, or reach me directly.