Detailed project case study
Resource Desk Utilisation Analytics
Utilisation analytics built from five grouped Exchange calendars to give operations and finance evidence for headcount planning.
Extracted and modelled consultant calendar data, giving operational teams better utilisation visibility and finance a data-backed case for new headcount.
Context
Consultant activity was distributed across grouped calendars, making utilisation hard to measure and new headcount difficult to justify with evidence.
My mandate
Extracted and modelled consultant calendar data, giving operational teams better utilisation visibility and finance a data-backed case for new headcount.
Scope
- Departmental / finance-linked
- Data & BI
- Softcat
Selected technologies
Key decisions
- Extracted activity from five grouped Exchange calendars using PowerShell.
What the team delivered
- Cleaned and modelled the data with Power Query and DAX.
- Built Power BI reporting around demand, capacity and utilisation.
Outcome
- Created a dependable view of consultant utilisation.
- Improved operational planning for the resource desk.
- Helped Commercial Finance justify additional headcount.
Evidence
Public details are limited to the operational record and outcomes that can be discussed safely. Supporting evidence is available in interview where appropriate.
What this demonstrates
A relatively focused technical solution created a direct bridge between messy operational data, workforce planning and a commercial finance decision.