← Selected work

Decision system · Flagship case

Profitability & Workforce Efficiency

A finance-led analytics system that connects time, revenue, cost and utilization into one operating view.

  • Power BI
  • Python
  • PostgreSQL
  • Excel
  • Azure
  • Railway
2026

Inside the reports

Ten pages, each answering one management question

Pick a page

Workforce efficiency · Utilization & revenueDemo dataPower BI overview page with utilization KPIs, revenue by month and a realization curve

Mechanics

The behaviour behind every page

  • Dual lens

    Every page switches between the client and the employee dimension without duplicating a single measure.

  • Period presets

    MTD, QTD, YTD, last 3 / 6 / 12 months or a free range — one click, and every visual follows.

  • Drill-down in place

    Practice → client → performer expands inside the same table, so context is never lost.

  • Formatting that reads

    Profit and margin are coloured against zero, so loss-making work is seen before it is read.

  • Trend inside the row

    Sparklines carry twelve months of profit history in a single line of the table.

  • Navigates like an app

    Bookmarks, tab strips and page buttons — not a stack of report pages to scroll through.

What it changed

The same month, with and without the system

Nothing about the business changed. What changed is how long it takes to see it, and how much of it you can trust.

The reporting month, without the system and with it
What changesWithout itSpreadsheets assembled by handWith the systemOne model, refreshed on demand
Monthly reporting cycleWithout it10 person-hours of manual assembly across 2–3 people, pulled off client workWith the system10 minutes and one owner — 120 hours a year back to billable work
Client profitabilityWithout itEstimated after the invoices are out, if anyone gets to itWith the systemCost, revenue and margin for every client, ranked before the next quote
Where the team’s time goesWithout itHours are recorded; how many of them turned into revenue is notWith the systemSold, unsold and non-billable hours per person, month by month
One question deeperWithout itAnother export, another file, another eveningWith the systemPractice → client → performer opens inside the same table
Agreeing on the numbersWithout itFinance and delivery arrive at the meeting with different figuresWith the systemUtilization and profitability read the same measures — one version of the truth
Next monthWithout itThe whole assembly starts again from zeroWith the systemRefresh, and the report is already built
If “without it” sounds like your month, let’s talk.