Birmingham UK Area and Ward Profiles - Local Government

danny_oneill — Thu, 02 Nov 2023 11:01:53 GMT

We have launched our new Area and Ward profiles, an evolution of the previous Ward profiles.

Using Power BI our users can now select multiple wards within Birmingham UK to get a comprehensive overview of their selected geography.

The report itself is powered by open data sources from the Office for National Statistics, Nomis, LG Inform, Fingertips as well as internal data in the form of static spreadsheets and Dataflows on Microsoft Fabric.

It includes a number of cool features including a postcode lookup tool, fully interactive tutorial built right within Power BI, dynamic narrative text which uses DAX measures to pick out the exact elements and an automatic refresh to pull in all the latest unemployment data and update the visuals powered by the Dataflows.

Parameters are used to make the entire model portable to other Local Authorities if we wish. Change a few variables and you can use your own API key, point to a new geography or change the reported period.

Popups are achieved using Bookmarks. A bookmark will indicate what visuals are available and the selection pane allows us to specify the order of those layers. This was used to great effect to create the interactive tutorial page to guide the user on how to get the most from the interactive report.

eyJrIjoiZTkxMjVlMjMtODhhNi00NTM5LTgzOGUtOThkNDEwMTAwY2FmIiwidCI6IjY5OWFjZTY3LWQyZTQtNGJjZC1iMzAzLWQyYmJlMmI5YmJmMSJ9

Re: Birmingham UK Area and Ward Profiles - Local Government

momo_man — Tue, 07 Nov 2023 20:51:08 GMT

Very impressive. Well done. Is it possible to get the pbix sent to me?

Re: Birmingham UK Area and Ward Profiles - Local Government

danny_oneill — Tue, 07 Nov 2023 21:07:50 GMT

I do not have permission to share the source but if you are from another local authority in the UK you can reach out to the email on the support page to start a dialogue.

Re: Birmingham UK Area and Ward Profiles - Local Government

momo_man — Fri, 10 Nov 2023 18:12:45 GMT

Ok, thank you.

Re: Birmingham UK Area and Ward Profiles - Local Government

giammariam — Tue, 21 Nov 2023 17:51:46 GMT

This is fantastic. Thanks for sharing.

topic Re: Birmingham UK Area and Ward Profiles - Local Government in Data Stories Gallery

Birmingham UK Area and Ward Profiles - Local Government

Re: Birmingham UK Area and Ward Profiles - Local Government

Re: Birmingham UK Area and Ward Profiles - Local Government

Re: Birmingham UK Area and Ward Profiles - Local Government

Re: Birmingham UK Area and Ward Profiles - Local Government