Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
08-16-2017 08:14 AM - last edited 08-18-2017 03:39 AM
Local government is always looking for ways to target its resources more effectively. Lancashire County Council's business intelligence team recently began exploring Power BI as a powerful platform to visualise Lancashire's latest data for health and its wider determinants at neighbourhood level.
We call this Neighbourhood Intelligence.
Our solution uses a large sample of Lancashire's public data, interacting with over 90 different datasets at smaller geographies. The report combines thirteen dashboards, from adult social care to community safety, to deliver statistical profiles of neighbourhoods in Lancashire.
Themes include adult social care, children and young people, community safety, demographics, deprivation, economic, health and wellbeing, housing, lifestyle, mortality, geo-demographic profiling and transport and environment.
The tool forms part of Lancashire County Council's JSNA (joint strategic needs assessment). The JSNA supports evidence-based, collaborative working with our health partners. It considers the present and future health needs of Lancashire's population to target health interventions.
This data story demonstrates how UK local government can use Power BI to easily consolidate and present masses of information, to identify inequalities in health and potential future public sector decision-making initiatives.
Lancashire Insight: http://www.lancashire.gov.uk/lancashire-insight.aspx
Lancashire area profiles: http://www.lancashire.gov.uk/lancashire-insight/area-profiles.aspx
eyJrIjoiYzIxMTM3YjMtNjBhMy00MDg4LTk4NmEtMzgzYzhkMjM2YmFiIiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9