NEC Housing tools

The tools we built to survive NEC Housing, free for yours.

NEC Housing runs to well over a thousand tables, joins that were never declared as foreign keys, and reference codes that mean different things in different domains. Explore public neighbourhood deprivation data alongside the tools we use every day: a schema wiki and join-path finder, a 3D explorer, curated guides, an Academy, and a Business Objects extractor. The deprivation explorer is open to everyone. NEC tools and learning use a free sign-in.

Deprivation explorer

Understand neighbourhood deprivation in its national context.

Explore the complete native measures for England 2025, Wales 2025 and Scotland 2020v2. Search official areas, inspect country definitions and download complete national CSV, Excel and GeoJSON packages. The map is prepared for publication; verified data and downloads are available.

42,648 official neighbourhoods across Great Britain.
Country-specific ranks, scores, indicators and missing-value explanations.
Public access with sources, methods and complete national downloads.

Open the deprivation explorer

EnglandWalesScotland42,648

Official neighbourhoods.
Native national definitions.

Schema Wiki & join-path finder

Find the join NEC never shows you.

NEC Housing has well over a thousand tables, and the joins you actually report on are rarely declared foreign keys. Search every HOU and FSC table, read the real relationships including the inferred ones, then point at any two tables and get the SQL for the route between them. The verbatim NEC column descriptions sit next to each field, so you stop guessing what a column holds.

Search 1,577 live NEC Housing tables, with system and empty tables already stripped out.
See declared and trusted joins, including the ones with no foreign key behind them.
Generate the shortest SQL join path between any two tables, with waypoints when you need them.

Open the Wiki

3D Explorer

The whole schema, as one map you can move through.

A table list tells you what exists. It does not tell you how the schema hangs together. The Explorer renders the entire NEC join graph in 3D: grab and drag nodes, search for a table and fly to it, click one to light up its neighbourhood, then route from one table to another and read the SQL inline.

The full NEC join graph as an interactive 3D force-graph.
Search, focus and drag to see how the spine tables cluster.
Route from one table to another and see the path lit in 3D, with the SQL alongside.

Open the Explorer

Guides

The knowledge that usually walks out the door.

The person who knows how your housing data really fits together is one resignation away from taking it with them. Our guides write that knowledge down: how repairs, voids, tenancies and properties actually flow through NEC, the gotchas that quietly drop rows, and the joins that hold up to audit. Curated, authoritative, and kept in the building.

Plain-English walkthroughs of the work orders, tenancies and properties spines.
The status codes, reference values and join gotchas that skew the numbers.
Written by practitioners who report on this schema, not a vendor manual.

Open the Guides

Academy

Learn AI from scratch, for nothing.

Everyone says get your people up to speed on AI. Almost nobody says how, or what it costs. The Academy is an eight-week course built entirely from free resources: Microsoft 365 and Excel, AI fundamentals and prompt craft, Power Automate, data protection, and responsible AI. Work through it at your own pace, quiz yourself, and keep the evidence in one place.

Eight weeks, 26 hand-picked free courses, no cost and no upsell.
Six practice quizzes that mark themselves, so you find the gaps before your work does.
Progress, notes, test results and certificates saved to your account, private to you.

Open the Academy

Business Objects extractor

Get your reporting logic out of Business Objects.

Years of refined report logic sit locked inside SAP BusinessObjects .rep and .wid files. Migrating off the platform should not mean rebuilding it from memory. Drop a file in and the extractor pulls the SQL and query objects straight out, in your browser, so nothing leaves your machine. Optional Claude clean-up turns the raw output into readable, portable SQL.

Reads .rep and .wid files entirely in the browser: no upload, nothing stored.
Pulls out the SQL and query objects behind each report.
Optional AI clean-up for SQL you can take straight into Power BI.

Open the extractor

Members area

Sign up free and put the tools to work.

Create your account with Google or Microsoft and you are in straight away: no waiting and no approval step, and no charge, now or later. Prefer to talk first? Book a conversation.