Scope of the possible with Power BI

Session materials

pdf slides

Previous attendees have said…

• 17 previous attendees have left feedback
• 100% would recommend this session to a colleague
• 88% said that this session was pitched correctly

Three random comments from previous attendees

• Was interested in whether Power BI might be a useful way to provide access to our ‘siloed’ data to management. The answer is yes, if only NHS restrictions would allow us to use Power BI 😂
• Love how the sessions focus on the practical ways in which to show data in a meaningful way to colleagues.
• Very well delivered session from knowledgeable enthusiastic host. It’s a personal preference of mine that questions are asked for at planed intervals, rather than inviting interruptions or stopping to answer questions in the chat. Helps with flow of the session and less jarring for viewers.

Session outline

• this session is a non-technical overview designed for service leads
• Why Power BI, and why this session?
• Power BI demo - build a simple dashboard
• Strengths and weaknesses
  • obvious
  • less obvious
• Alternatives
• Skill development

Power BI?

• newish (c.2015)
• based on Microsoft’s SQL reporting products
  • proprietary, closed-source, paid-for
• integrates functions from several other Microsoft data products (bits of Excel, PowerPivot, PowerQuery…)
• produces interactive dashboards

Why this session?

• there is a lot of fluff talked about Power BI
  • e.g. elaborate visualisations, fancy real-time data products…
• Power BI in general is promoted as a no-code tool
  • that’s just not true, as we’ll see
• Power BI has a sales-y focus
  • that conceals some of its most useful properties
• so Power BI, as a platform, requires some translation to the complicated reality of health and social care data
  • and Power BI offers real strengths in managing and exploiting our data, even when the pain-points are taken into account

Power BI demo

• using tidied of the GP practice size dataset from April 2024
  • GP practice size data
  • Demographic data

Note this data is cleaned

Name	PracticeListSize	Postcode	HBName	GPCluster	Code
High Mill Medical Practice	7385	ML8 4BA	NHS Lanarkshire	Clydesdale	62219
The Terrace Medical Practice	7774	G61 3RD	NHS Greater Glasgow and Clyde	Bearsden/Milngavie	40027
Eastwoodmains Medical Practice	4962	G76 7HN	NHS Greater Glasgow and Clyde	Eastwood 1	49445

Load some data

Lots of different data loading options

Preview

Friendly tools for previewing data

Add to a map

Clever use of commercial postcode data

Add interactions

Visualisations are interactive

Publish

Add more visuals

30-odd built in, hundreds of free additional visuals, thousands of (often dodgy) commercial add-ins

Add more data

• we could add the health board names, to make our visual more useful
• we could also get GP practice demographics

Add more data

Totally different data, but harmonised process for loading

Re-shape that data

Neatly-integrated PowerQuery, gives loads of scope for tidying and fixing data

Data modelling tools

Full suite of relational tools for the more ambitious projects

Pre-packed visuals

Microsoft’s Tornado chart

Demographics

These can be cross filtered to give national/board/practice level insights

Strengths

• by far the easiest way of producing interactive data products
• great tools for tidying data
• good for iterative projects
• data hubbing / self-service data
• scaling
• potential to manage complex and sensitive data on existing infrastructure

Weaknesses

• really needs clean and tidy data
• publication can be complicated and expensive
• steepening pain curve. Easy to start projects, but more involved analysis is messy
• complex IG landscape
• messy skills development journey