Demonstration · Illustrative data · BI Consulting Services
Jacobs × BI Consulting Services
Prepared for Jonathan · Facilities & Maintenance reporting team
September 2026 · Power BI Jump-Start concept

Maintenance Operations Board — Maintenance Connection work orders, PM compliance and technician capacity, in one governed Power BI model

An illustration of what a single governed dataset fed from the Maintenance Connection CMMS API (15 tables) could put in front of the O&M team: backlog and aging by site, PM compliance, MTTR, asset criticality and crew utilisation — sliced by region, work-order type and fiscal period.

Model refreshed ·

Work orders opened vs closed, with month-end backlog

Monthly volumes for the selected scope. Backlog line = open work orders at month end.

OpenedClosedMonth-end backlog

Facility portfolio map — buildings sized by asset count, coloured by open work orders per 100 assets

Twelve illustrative managed facilities across three regions. Lime ring = site above the 15-per-100 backlog threshold.

Backlog aging by site

Open work orders at period end, split by age bucket. Sorted by total open.

0–7 d8–30 d31–90 d90+ d

Asset criticality × backlog age

Open work orders by asset criticality class (from the Maintenance Connection asset table) and days open.

Technician utilisation by trade

Labour hours booked to work orders ÷ available hours. Amber line = 90% ceiling.

Ask the data

Natural-language layer on the same governed model — a typed question, an answer with the numbers, and the visual it came from.

Which sites have emergency work orders open for more than a week, and is our response time getting better or worse?
Emergency MTTR · hours

Governance strip — the Jump-Start layer

Workspace, dataset and refresh health for the scope selected; the part of the engagement that keeps the numbers above trustworthy.

Also from BI Consulting Services

Private AI on your own server

The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.

Private AI Servers — slide 1 of 14
Private AI Servers — slide 2 of 14
Private AI Servers — slide 3 of 14
Private AI Servers — slide 4 of 14
Private AI Servers — slide 5 of 14
Private AI Servers — slide 6 of 14
Private AI Servers — slide 7 of 14
Private AI Servers — slide 8 of 14
Private AI Servers — slide 9 of 14
Private AI Servers — slide 10 of 14
Private AI Servers — slide 11 of 14
Private AI Servers — slide 12 of 14
Private AI Servers — slide 13 of 14
Private AI Servers — slide 14 of 14

Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min