Volume 10 Issue 6 February 2017 Welcome to Knowledge Matters One of my personal heroes is Douglas Adams, who once said “I love deadlines. I love the whooshing noise they make as they go by.” - Bearing that in mind welcome to the February edition of Knowledge Matters! It’s all change here at QO Towers—Simon has headed off to pastures new (see page 14), and we have a plethora (a plethora can be three, can’t it?) of new team members to introduce (see page 15). Reassuringly Knowledge Matters is still the same old mixture of idiosyncratic articles on how to do tech stuff, interesting things going on in the world of NHS analysis, what the QO have been up to lately, and dodgy poetry. This issue we see the welcome return of Samantha Riley, this time in her new role in NHS Improvement, championing the role of quality analysis in improvement services, this time she’s looking at the difference between measurement for improvement and measurement for judgement. There’s a couple of articles focussed on cancer; one is a case study about analysing data for the Cancer Vanguard, and the other from South East Coast Clinical Network about the Fourth Biennial Early Diagnosis Research Conference. We’re also looking at population analytics in terms of STP footprints with the exciting new CareMap tool. Becki and Dani have been on voyages of discovery down the murky tributaries of Excel and have come back eager to share their knowledge on Power Pivots and dependant dropdown menus. That’s probably about enough for now—see you next time!
Inside This Issue : Measurement for improvement vs measurement for judgement
2
Skills Builder—Power Pivot
8
News
13
CareMap Population Analytics
4
Ask An Analyst—C reating Dependent Drop
10
Team News
14
Cancer Vanguard Project – automating charts to highlight outliers Part 1
6
Fourth Biennial Early Diagnosis Research Conference
13
The Back Page
15
twitter.com/SECSHAQO issuu.com/SECQO http://www.networks.nhs.uk/nhs-networks/sec-qo www.QualityObservatory.nhs.uk