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.
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.
Most RLS breaks the first time the org chart changes. A pattern that bends with the structure instead of hard-coding it.
First-time-fix is a lagging summary. The booking and reschedule trail underneath it is where the operational story actually sits.
Trust in a dashboard is lost in one wrong number and rebuilt slowly. A short field guide to closing the credibility gap.
The lookup table behind half of NEC reporting, why its codes are not unique across domains, and how that quietly drops rows.
You do not buy a single source of truth. You maintain one. Why governance beats tooling every time it is tested.
Measures are read far more often than they are written. Naming and structure that let the next analyst follow the logic.
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.
Scheduling data is only useful joined to its cause. The bridge between DRS and NEC, and the keys that make it hold.
Tell us where your reporting hurts. We'll tell you, plainly, whether we can help and how we'd approach it.