Get IMD/IDACI data on the fly in PowerBI

[elJukes]

Hi,

 

Not sure this is the right forum anymore, apologies if not! A few years back I wrote a PowerQuery function to pull IMD data from postcodes. Sadly shortly after sharing it with everyone the OS data service shutdown causing it to stop working - but I have written a new version!

 

The script is a PowerQuery function that can pull the score, rank or decile of any of the 2019 (latest) IMD domains - including IDACI. All you need to use it is a column in one of your data tables which contains postcodes. When added to PowerBI report the function will run every time the report data is refreshed, meaning as more postcode data is added to your data tables, the function will collect the corresponding IMD information you asked for - saving you doing it by hand. It pulls the data directly from ONS and DLUHC services so you don't need to host a huge lookup table yourself.

 

The script, along with instructions for using it can be found here: https://github.com/olicatschools/IMD-Lookup-Script/tree/main

 

I hope it's of some help!