Blog

Field notes from the housing data layer.

Practical writing on NEC Housing, DRS, Power BI and the craft of reporting that housing teams actually trust. No vendor spin, just what we have learned building it.

Power BI

Row-level security that survives a reorg

Most RLS breaks the first time the org chart changes. A pattern that bends with the structure instead of hard-coding it.

4 Jun 2026·6 min read
DRS

What appointment data tells you that the KPI doesn't

First-time-fix is a lagging summary. The booking and reschedule trail underneath it is where the operational story actually sits.

28 May 2026·7 min read
Practice

The reporting nobody trusts, and how to earn it back

Trust in a dashboard is lost in one wrong number and rebuilt slowly. A short field guide to closing the credibility gap.

19 May 2026·5 min read
NEC Schema

Reference values, decoded: FIRST_REF_VALUES in plain English

The lookup table behind half of NEC reporting, why its codes are not unique across domains, and how that quietly drops rows.

9 May 2026·8 min read
Strategy

One source of truth is a habit, not a warehouse

You do not buy a single source of truth. You maintain one. Why governance beats tooling every time it is tested.

30 Apr 2026·6 min read
Power BI

DAX measures that read like sentences

Measures are read far more often than they are written. Naming and structure that let the next analyst follow the logic.

22 Apr 2026·5 min read
NEC Schema

Voids, repairs and the joins between them

Where the void lifecycle meets the works-order spine, the column that states the link, and why inferring it from dates makes the numbers drift.

14 Apr 2026·7 min read
DRS

Joining DRS appointments back to the work that triggered them

Scheduling data is only useful joined to its cause. The bridge between DRS and NEC, and the keys that make it hold.

3 Apr 2026·6 min read
Get in touch

Let's make your housing data make sense.

Tell us where your reporting hurts. We'll tell you, plainly, whether we can help and how we'd approach it.