ONS Local & City Observatory Workshop: LG Inform Plug and Play Power Query

ONS Local has been established by the Office for National Statistics (ONS) to promote evidence-based decision-making at the local level. We aim to host insightful workshops which will provide practical, technical support to help users make the most of ONS and cross government data. Birmingham City Council have developed and run the Birmingham City Observatory, a public, open data platform on a wide range of characteristics of the city. Danny O’Neill, its creator, is an expert on building Power BI dashboards.

This session shows you how ridiculously easy life gets when you mix the LG Inform API builder with a bit of Power Query magic. All you need is a metric ID and you are off, pulling fresh data straight into your workbook without any wrestling. We walk through the API builder, show you how to shape the request and hand you a ready-made Power Query script you can drop straight into Power BI or Excel. Ideal for analysts, performance leads and anyone who wants quick, fuss free access to LG Inform data. Delivered with a smile and a shortcut or two by Danny O'Neill from the Birmingham City Observatory.

If you have any questions, please contact ons.local@ons.gov.uk.

All information submitted via Eventbrite will be held in line with the Office for National Statistics privacy policy.