SAMPLE AND DEMONSTRATION ONLY. Illustrative analysis of publicly available information, prepared by BI Consulting Services. Not affiliated with, endorsed by or produced for any company shown.
Demonstration · Illustrative data · BI Consulting Services
Professional & financial services × BI Consulting Services
Industry sample board · Partner ledger
Single-page Power BI concept · no client data

The partner ledger: where the hours go, where the cash gets stuck, and who carries the client.

Prepared for Managing partners and CFOs | September 2026 | Utilisation · realisation · lock-up · pipeline · ageing · concentration
①

Billable hours vs plan, last 24 months

Hours
Billable hours, selected periodBillable hours, outside periodPlan
②

What this board answers

Three questions
⑩

Lock-up river: work in progress → debtors → cash

Days · width = billings per day
Work in progress (unbilled)Debtors (billed, uncollected)Selection average lock-upWrite-down at the billing weir
④

Utilisation & realisation by practice

vs plan
UtilisationPlanned utilisation
Util.Real.
③

Partner × client allocation grid

Billable hours in period
⑤

Revenue & margin by client

Fees · margin
Client · sectorFeesMargin
⑥

Pipeline by stage

Opened in period
⑦

Invoice ageing

Period end
⑧

Client concentration

Share of fees
⑨

Ask the data

AI layer · answers grounded in this board
YouWhich practice's lock-up got worse this period, and how much cash would bringing it back to the firm average release?

Other questions partners ask this board

Which clients are below 15% margin? Who bills the most hours to a single client? How many months of revenue does the pipeline cover? Where did write-downs increase this quarter? Which office is furthest under plan?
⑪
1 Benchmark: SPI Research, 2026 Professional Services Maturity Benchmark (19th annual), reports average billable utilisation of 66.4% across surveyed professional-services organisations for 2025 — the lowest in the survey's history and below the 75% target (spiresearch.com; figures as summarised by Deltek). This board's utilisation KPI is compared against that published figure. Every other number on this page is illustrative sample data generated for demonstration, internally consistent (subtotals reconcile, percentages match the values shown) and does not describe any real firm or client. Practice cost rates include fee-earner salary and on-costs only; margin is before overhead and partner distributions.
Also from BI Consulting Services

Private AI on your own server

The "ask the data" panel above is built to run on a GPU server inside your own network: an open-weight model over your own documents, with every answer citing the file it came from. No per-seat licence, works offline, and nothing leaves the building.

How it sits in your environment

YOUR NETWORK · NOTHING LEAVES THE BUILDING Your files policies · SOPs · contracts reports · ERP exports indexed locally GPU One server, in your building open-weight model · your data only in seconds Cited answers every reply links to the source file and page no cloud AI · no third-party processor
One appliance-class server on your rack or in a secured closet. Your files are indexed where they already live; the model runs locally; answers come back with the source page attached.

What that means in practice

  1. 1
    Your data only, on your hardwareAn open model over your own documents and exports. No third-party AI processor, no data-transfer agreement to review.
  2. 2
    Every answer cites its sourceReplies point to the file and page they were drawn from, so people check the answer instead of trusting it blind.
  3. 3
    No per-seat licenceThe whole team can ask questions. Cost is the server and our build, not a monthly number that grows with headcount.
  4. 4
    Works offlineIf the internet connection goes down, the answers still come. Nothing depends on a vendor's uptime or pricing changes.

The short deck

14 slides on how a private AI server is scoped, secured and rolled out. Click through, or take the PDF.

Download the PDF
Private AI on your own server — slide 1 of 14 Private AI on your own server — slide 2 of 14 Private AI on your own server — slide 3 of 14 Private AI on your own server — slide 4 of 14 Private AI on your own server — slide 5 of 14 Private AI on your own server — slide 6 of 14 Private AI on your own server — slide 7 of 14 Private AI on your own server — slide 8 of 14 Private AI on your own server — slide 9 of 14 Private AI on your own server — slide 10 of 14 Private AI on your own server — slide 11 of 14 Private AI on your own server — slide 12 of 14 Private AI on your own server — slide 13 of 14 Private AI on your own server — slide 14 of 14
1 / 14Tap or click a slide to advance · arrow keys work too

Worth a conversation? Book 30 minutes with NicholeBI Consulting Services · powerbiconsultingservices.com