Portfolio / Case study 01
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.
Project walkthrough
See how the work was put together
$ 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
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.
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
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.
Gallery and links
Screens from the project
Figures are anonymised. Click an image to enlarge it.
Services used
The services behind this project
Let's connect
Want something like this for your business?
Book a free 30-minute call on Google Meet, or reach me directly.