04 · Power BI · Power Apps
Workforce planning
The plan works on paper, not in the van.
Move a job and watch capacity and the SLA change.
Demo on fictional data — never customer data.
A job due this week on an overloaded technician counts as an SLA risk.
- Technicians
- 6
- SLA risk
- 3
Daan Bakker
elektra · sanitair · 46/40u · over capacity
Daan Visser
klimaat · beveiliging · 14/40u
Daan Smit
sanitair · laagspanning · 10/40u
Daan de Boer
elektra · elektra · 6/40u
Daan Mulder
beveiliging · klimaat · 8/40u
Daan de Vries
laagspanning · sanitair · 12/40u
| Job | Hours | Technician |
|---|---|---|
| Fault Zuidwerf | 18 | Daan Bakker |
| Hall B cabling | 16 | Daan Bakker |
| New distribution board | 12 | Daan Bakker |
| Climate unit 4 | 14 | Daan Visser |
| Floor plumbing | 10 | Daan Smit |
| Camera extension | 8 | Daan Mulder |
| Quay low voltage | 12 | Daan de Vries |
| Sensor follow-up | 6 | Daan de Boer |
3 jobs due this week sit with a technician above 40 hours.
SELECT technician_id,
SUM(hours) AS assigned
FROM job
GROUP BY technician_id
HAVING SUM(hours) > 40;