122,000 data matched households
Days saved
Single view created

The Challenge

An English council needed to combine mismatched same theme data from legacy systems to produce a single coherent dataset in Azure.

The Solution

It used FME to map, transform, and load thousands of records into a central data warehouse.

Each legacy council captured, processed, and stored their data differently.

The Council used Unique Property Reference Numbers (UPRNs) as a key data point to match records to.

The Benefits

Data was matched to 122,000 households saving the council days of manual processing.

Want to know how to build this workspace?

We get it – time is tight, and while you know there’s a whole lot more you could do with FME, having the space to explore that capability is tough.

That’s why we’re hosting a series of hands-on in-person events across the UK designed to quickly ramp up what you can do, connect you with other local FME experts, and give you this workspace ready-to-use.

Learn more about Knowledge Sharing Hubs