![Page 1: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/1.jpg)
South West NHS and Health Care
Analysts Needs Assessment
2016/17: Report
Anna ColtmanProject Manager, SW AHSN
February 2017
![Page 2: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/2.jpg)
Background
Context:– Few training opportunities – longstanding issue.– STPs – requirement for high quality ‘system’ analysis and
interpretation
Ambition:– increase capacity, knowledge and skills– responsive workforce delivering insightful findings– informed decision making
Survey acknowledgements: SW AHSN with AphA and PenCHORD/PenCLAHRC, worked in collaboration to design and develop this needs assessment to explore the training needs of health and care data analysts.
@sw_ahsn @apha_analysts #futureNHS
![Page 3: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/3.jpg)
Summary
• Survey opened 29th November 2016
• Sent to approx. 138 direct contacts:– APHA distribution list (South West only)– SWINPHO distribution (via Public Health England)– Circulated by working group members
• 114 responses in total (as at 28 February 2017)
• Question 1: What is your job title/role? Responses from a range of job roles:– Information Analysts/Specialists/Managers– Public Health Analysts– Performance Analysts
@sw_ahsn @apha_analysts #futureNHS
![Page 4: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/4.jpg)
Next Steps• Drafting a training offer
– Focus on core skills and key datasets– Local expertise – use and share the knowledge we already have within our
community– Gather and disseminate information on existing training/courses– Strive to keep costs to an absolute minimum– Utilise forums already available for knowledge sharing such as APHA
website
• Gaining support from organisations– Release analysts to train/learn– Small amount of funding may be needed
• First event in April
• Further work to shape and expand the offer during 2017 with the aim to design a sustainable programme for future years
@sw_ahsn @apha_analysts #futureNHS
![Page 5: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/5.jpg)
Question 2: Indicate job level/pay band.
Indicate job level/pay band
Answer OptionsResponse Percent
Response Count
Head of Service 2.6% 3
Manager 8.7% 10
Analyst 28.7% 33
Band 1-6 59.1% 68
Band 7-9 30.4% 35
Other (please specify) 0.9% 1
0.0%
10.0%
20.0%
30.0%
40.0%
50.0%
60.0%
70.0%
Head ofService
Manager Analyst Band 1-6 Band 7-9 Other(pleasespecify)
Indicate job level/pay band
@sw_ahsn @apha_analysts #futureNHS
![Page 6: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/6.jpg)
Question 3: Indicate how long you have worked in your current role.
Answer Options Response Percent Response Count
0-6 months 16.7% 19
6 months - 1 year 8.8% 10
1-3 years 31.6% 36
3 years + 43.0% 49
Indicate how long you have worked in your current role
0-6 months
6 months - 1 year
1-3 years
3 years +
@sw_ahsn @apha_analysts #futureNHS
![Page 7: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/7.jpg)
Question 4: What is your employer name and site?
Responses by location
Organisation
Foundation Trust (Ambulance) 2
NHS Foundation Trust (Community) 1
Public Health 3
Local Authority 3
National Institute for Health Research
(NIHR) 1
NIHR CRN SWP 1
Mental Health Partnership 5
NHS Improvement 3
NHS Trust (Community) 8
Acute Trust 55
CCG 27
CSU 5
@sw_ahsn @apha_analysts #futureNHS
Location Count
Bath, Somerset 1
Dorchester, Dorset 1
Trowbridge 2
Plymouth 14
Poole 9
Taunton, Somerset 1
Gloucestershire 12
Barnstaple 7
Yeovil 4
Treliske 11
Exeter 23
Torquay 12
Bristol 6
![Page 8: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/8.jpg)
Question 5: Please indicate your current level of expertise in the following areas.
0
20
40
60
80
100
120
140
Please indicate your current level of expertise in the following areas.
Expert
Intermediate
Basic
Never used
@sw_ahsn @apha_analysts #futureNHS
![Page 9: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/9.jpg)
Question 6: Which areas of training would you most benefit from?
0
20
40
60
80
100
120
140
Which areas of training would you most benefit from?
Very useful
Somewhat useful
Neutral
Not useful at all
@sw_ahsn @apha_analysts #futureNHS
![Page 10: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/10.jpg)
Question 7: Would you like to receive training on the following data sources?
Other suggested training:
• HES• Advanced Excel• EPACT/Other prescribing
datasets• Dr Foster or other
benchmarking• QlikView• Project Management• NHS Data Dictionary• Snowmed• Mental Health Datasets
0
20
40
60
80
100
120
140
NHS Data Directory Healthcare ResourcesGroups (HRGs) andPayment by Results
(PbR)
Secondary UsesService (SUS)
Would you like to receive training on the following data sources?
Yes
No
Not Sure
@sw_ahsn @apha_analysts #futureNHS
![Page 11: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/11.jpg)
Question 8: Have you completed any training that was relevant to your role in the past 12 months.
No I have not completed any training 40.2%
Yes I have completed training 62.6%
• Nothing available/offered• New to the role• No courses within budget• Operational pressures• Not aware of what is available• No availability or time to train
• Health Education England course inc, Introduction to economic evaluation, introduction to STATA, Introduction to R, GIS for Public Health, Introduction to SQL and HES for analysts, Querying SQL databases using T-SQL
• Community Development short course and Public Health analyst network events
• Agile, Tableau, SAS, Alteryx• Advanced Excel• Business Objectives• ‘Leading the Plymouth Way’• MSSQL• IG, Capacity & Demand, IR, PbR
• SQL various courses/levels• NHS Leadership Academy• Capacity and demand planning (Surrey
University)• New healthcare system and data
warehouse• PenCHORD (modules 1-3),
data/geographic modelling• Public Health Masters• Attending related events• SSRS • Excel• IG mandatory training• MapInfo• HES• R• SPC
• Lack of opportunity• No real gap• No training budget• Not in personal development plan
• Ash, sollis, SSRS• Oracle BI• Simul8, SAS Enterprise• Learning from
colleagues, in house training
• HFMA Introduction to NHS Finance
• Power BI, internal webinars, Mental PbR Clustering
• Qlikview (Open Data Platform - ODP)
![Page 12: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/12.jpg)
Question 9: Are there any training courses for data analysts NOT currently available (within or outside the NHS) you would like to see?
No 47% Yes 53%
• Calculating and using confidence intervals • Advanced training on Business Objects (the
trusts data warehouse).• PbR. Entry level particularly.• Risk stratification analysis• Demand modelling. • Technical sessions on GIS software. • Web tool development.• LKIS Basic and courses for new PH Analysts• R with SQL• Data visualisation, GIS for health intelligence,
open data• Statistical analysis
• Predictive and Forecasting techniques• Modelling clinical pathways • HRG grouper / Triggers that affect the
grouper.• Propensity matching• Service evaluation techniques• Indicator design and use of official
statistics• PBR, HRGs, CQUINs, NHS national bodies• Embedding R in stored procedures
(PostgreSQL or MS SQL Server) or open source reporting using BIRT
• IG and understanding section 251• Advanced SQL for analytics
Suggestions for training courses for NHS data analysts:
@sw_ahsn @apha_analysts #futureNHS
![Page 13: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/13.jpg)
Question 10: How would you prefer to receive training? (multiple choice)
0.0%
10.0%
20.0%
30.0%
40.0%
50.0%
60.0%
70.0%
80.0%
90.0%
Seminar Workshop Internet (e.g. Skype,WebEx)
1:1
How would you prefer to receive training?
Answer Options Response Percent Response Count
Seminar 45.6% 52
Workshop 85.1% 97
Internet (e.g. Skype, WebEx) 50.9% 58
1:1 25.4% 29
@sw_ahsn @apha_analysts #futureNHS
![Page 14: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/14.jpg)
Question 11: Would your organisation be willing to contribute a fee to send employees on training?
Would your organisation be willing to contribute a fee to send employees on training?
Yes
No
Don't Know
@sw_ahsn @apha_analysts #futureNHS
![Page 15: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/15.jpg)
Question 12: Which of the following would influence you to register for a training programme? (multiple choice)
0.0%
20.0%
40.0%
60.0%
80.0%
100.0%
120.0%
Which of the following would influence you to register for a training programme?
@sw_ahsn @apha_analysts #futureNHS
![Page 16: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/16.jpg)
Question 13: Would you be willing to contribute to a training programme by leading a session such as a seminar, workshop, WebEx or other format.
Would you be willing to contribute to a training programme by leading a session such as a seminar, workshop, WebEx or other format.
Yes (Please provide contactdetails below)
No.
No but I know an expert who canlead a training session (Pleaseprovide contact details below)
@sw_ahsn @apha_analysts #futureNHS
![Page 17: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/17.jpg)
Question 14: What would be your preferred location for training?
Location Response %
Exeter/SW AHSN office 38.8
Cornwall 16.4
Somerset 17.2
Devon 28.4
At my place of work 50.9
I don’t have a preference 23.3
@sw_ahsn @apha_analysts #futureNHS
![Page 18: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/18.jpg)
Question 15: Would you like to see a network or forum set up for analysts in the South West to share knowledge and ideas?
Would you like to see a network or forum set up for analysts in the South West to share knowledge and ideas?
Yes
No
Not sure
@sw_ahsn @apha_analysts #futureNHS
![Page 19: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/19.jpg)
Question 16: Provide additional information or special requirements you might have to help us understand your training needs.
If the network itself provides expertise then costs should be
minimal
I don’t want to see a separate network
but more development focus
A structured training programme
tailored to different grades
Training based on techniques which
have made tangible improvements and
efficiencies
Support analytics engagement with
operational teams; report narratives and
the correct mechanism for presenting it.
A decent web resource with links to training, or specific training videos and
other useful information
@sw_ahsn @apha_analysts #futureNHS
![Page 20: South West NHS and Health Care Analysts Needs Assessment ...€¦ · (NIHR) 1 NIHR CRN SWP 1 Mental Health Partnership 5 NHS Improvement 3 NHS Trust (Community) 8 Acute Trust 55 CCG](https://reader033.vdocuments.us/reader033/viewer/2022042915/5f53c4bd31c25d10ff48376b/html5/thumbnails/20.jpg)
www.aphanalysts.org
@apha_analysts
Thank you for completing the analysts needs
assessment.