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

Construction, property & trades × BI Consulting Services Project Portfolio Control Board · BICS industry sample for regional general & specialty contractors and property groups

Prepared for Owners and project executives
September 2026

One board for the questions that decide a contractor's year: which jobs are fading against estimate, where the WIP schedule is under-billed, how change orders and labour productivity are moving margin, and whether safety is tracking the industry line. Safety is benchmarked against the BLS construction rate of 2.3 recordable cases per 100 full-time workers1; every other figure is illustrative.

Portfolio headline Contract backlog, margin, WIP position, labour, schedule and safety for the selected jobs and period

①
①

Portfolio Gantt-map with cost-to-complete rings Bars: contract schedule Jan 2025 – Jun 2027, filled to earned progress at period end · Ring: cost to date as a share of forecast cost at completion, coloured by fade vs estimate

②
Earned progressRemaining scheduleCost-to-complete ringWithin estimateFade 0–3%Fade >3%
②

What this board answers Three questions owners ask on Monday morning

③
③

Earned revenue vs job cost by month Bars: revenue earned (cost-to-cost) and job cost incurred · Line: monthly gross margin %

④
Earned revenueJob costGross margin %
④

Job cost vs estimate by phase Original estimate vs forecast at completion, summed across selected jobs

⑤
⑤

WIP schedule — over / (under) billings Earned = contract × % complete (cost-to-cost) · positive = billed ahead of earned

⑥
⑥

Change orders by driver Approved vs pending value, change orders logged in the selected period

⑦
⑦

Labour productivity & schedule Earned hours ÷ actual hours (1.00 = estimate) · days ahead / (behind) baseline

⑧
⑧

Safety — TRIR & near-misses Recordables × 200,000 ÷ hours worked, by region, vs BLS construction 2.31

⑨
⑨

Bid hit-rate by sector Bids submitted in the period · won ÷ submitted by count

⑩
⑩

Equipment utilisation by class Engine hours ÷ available hours for units assigned to the selected jobs · target 75%

⑪
⑪

Ask the data AI layer over the same model — natural-language question, governed answer, chart reference

⑫
›Which jobs are fading most against estimate, and what is it costing us?
Why is Route 9 under-billed?Show pending change orders older than 30 daysWhich crews are below 0.90 productivity?Idle cranes next month?
⑫
Demonstration · Illustrative data · BI Consulting Services
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