Lorenzo Reale

Power BI consultant · UK and EU

Work

Demonstration project

Site Inspection Performance

A monthly briefing that tells an operations team whether its inspection programme is on track, and where to act next.

  • Client Meridian Facilities Group (fictional)
  • Audience Head of operations and six regional managers
  • Sources Monthly exports from an inspection app, an actions list, a site register
  • Built with Power BI · Power Query · DAX · row-level security
Overview page: compliance, inspections, actions closed on time and sites past the visit rule, compliance by month and by region, overdue actions and sites past the rule
The briefing for October 2026: compliance against target and last year, the regions, the oldest overdue actions and the sites past the visit rule.

Synthetic data · fictional client · model, DAX and data generator on GitHub.

01

The problem

Meridian inspects 42 sites in six UK regions against a 24-question safety checklist. Every month the inspection app produced a new export, and the operations review spent its first hour putting the figures together, which left little time to decide what to do about them. Each regional manager also needed to see their own region, and only their own.

02

What it showed

With data to 30 October 2026, the first page gives the review three answers, and each page behind it holds the evidence for one of them.

  • Compliance is above target, but not everywhere90.1% so far this year against 86.8% over the same months of 2025, and above 90% every month since April. Still, 18 of the 42 sites are below target, South West is the weakest region at 84.7% and Signage the weakest section at 85.9%, so next quarter's visits and briefings go there.
  • Follow-up is slipping66.8% of corrective actions were closed by their due date, against 84% a year earlier. Eleven are overdue and two of them have no owner, which the review can fix on the day.
  • The visit gaps come from schedulingInspectors make 52 visits a month where the 60-day rule needs 22, yet three sites are past the rule, Neath Yard at 94 days. Kingsway Depot has had 21 visits this year, four times what the rule needs. A fairer schedule closes the gaps without adding inspectors.
Actions page: on-time closure by month against the year before, open actions by region, and the register of open actions
On-time closure by month against the year before, and every open action, earliest due date first.
Visits page: sites past the visit rule, the most visited sites, and inspections against plan by region
Where visits are missing and where they go: the longest gaps, the most visited sites and the plan by region. The visit rule can be tested from 15 to 90 days.
03

How it's built

Monthly exportsReference listsPower QuerySemantic modelReport
  • The exports are read as the app writes themOne file a month, one column per question. Power Query combines the folder, turns the checklist into rows and keeps the latest version of any inspection edited after it was submitted, so a new month needs no change.
  • One compliance measure everywhereQuestions passed over questions applicable, the same from the whole estate down to a single inspection, so the pages always agree.
  • Security by region, with the plan to matchRegional managers see only their region, and their inspections are measured against their region's plan.
  • Real problems, handled in the openThe files carry the problems real exports do: inspections exported twice after an edit, a change of date format in August 2026, site names typed differently in the actions list, actions with no owner and one pointing at an inspection that does not exist. The Data quality page counts each one.

Every figure on this page was recalculated from the source files outside Power BI, and matches the report.

04

The source

The semantic model, the DAX and Power Query, the report pages and the script that writes the data are on GitHub, all readable as plain text. The report itself, with its data, is a .pbix file in the project's release, with a PDF of every page.

All data in this project is synthetic. Meridian Facilities Group is a fictional client created to demonstrate the work, and no real client data appears anywhere in it.

Next project Month-End Management Pack

Get in touch

Reporting your operation could rely on?

If your teams collect operational data that never quite becomes a dependable monthly answer, this is exactly the kind of report I build.

Discuss a project