Building Data Science capability across Government – Data Analytics Apprenticeship

1. Building Data Science capability across Government – Data Analytics Apprenticeship 12th July 2017 Alexis Fernquest and Gareth Jones

2. Data Analytics Apprenticeship • The first of it’s kind in the U.K. • Over 130 applicants for 8 positions. • 8 in the Data Science Campus from December 2016. • 6 across Government departments in Wales • 6 to start in September 2017 in the Data Science Campus. “Apprenticeships are essential to creating the workforce of the future” John Manzoni

3. The structure of the apprenticeship 01 EXTERNAL COURSES ON THE JOB TRAINING 02 03 TRAINING PROVIDER ASSESSMENTS

4. External Training 40 days of external training, including; • Building professionalism and development • Programming in R and Python • Information governance and data management • Statistical analysis and data analysis • Data science methods • Advanced data representations and manipulation for IT

5. On the job training • R and Python application • Regression modelling • GitHub • Data Ethics • Overview of and work across ONS business areas • Project participation across ONS and in collaboration with other government departments

6. Sustainable Development Goal Project • Completed from January to March 2017 • Group One – Goal 7 - sustainable energy sources – energy demand and impacts. • Group Two – Goal 3 - non communicable diseases – lung cancer & mortality rates.

7. Group one – Goal 7 Clean Energy • Forecast in energy using the ARIMA model. • Trend in energy reduction. Source: "G.B. National Grid Status" - gridwatch.templar.co.uk

8. Group one – Goal 7 Clean Energy • Smart meter installations increasing. • Energy demand decreasing. Sources: the Department for Business, Energy & Industrial Strategy and GridWatch

9. Group Two – Goal 3 Good Health and WellbeingBy 2030, reduce by one third premature mortality from non-communicable diseases through prevention and treatment and promote mental health and well-being. The average women are about 3.9% more likely to survive NUMBER OF DEATHS PER AGE AND GENDER Women have a higher rate of survival at every stage The biggest variance in survival rates comes in stage 4, where women out survive men by 4.7%. SURVIVAL RATE FOR EACH STAGE OF DIAGNOSIS PER GENDER Source: Cancer Research Website Female death steadily increase throughout the age bands Increases slow down from ages 60 onwards. There are more men dying in every age bracket Especially between the age of 60 and 80 where men are much higher Source: Cancer Research Website

10. Group Two – Goal 3 Good Health and Wellbeing Completed an augmented Dickey-Fuller Test to see if the data is stationary ACF suggested ARIMA(1,0,1)(2,0,0)[12] should be used Decomposition completed to find trend and seasonality Seasonality taken out of the data to complete forecast ARIMA forecast used to calculate next 24 months

11. Group Two – Goal 3 Good Health and Wellbeing

12. Personas in collaboration with the Cabinet Office WHAT IS THE PROJECT? Project undertaken by the Data Science Campus for the Policy Lab within The Cabinet Office AIM To see if personas can be developed from survey data. SOLUTION? Cluster analysis on the Labour Force Survey; forming clusters that can be translated into personas.

13. Personas in collaboration with the Cabinet Office • 14 variables used from the Labour Force Survey • R Package PCAmix used for the combination of categorical and numerical values. • Variable influence plotted across 5 dimensions • Kmeans algorithm used to form 4 clusters • Dimension influence to each cluster

14. Personas in collaboration with the Cabinet Office

15. Question Bank WHAT IS THE PROJECT? Capture all business survey questions in a machine readable format including survey, form type, question number, wording, response type and related guidance. AIM To have all the question types digitally represented in one place. SOLUTION? Capture business surveys into a format which can be used to perform text analytics.

16. Question Bank NEXTSTEPS THE BENEFITS HARMONISATION RESOURCE • To import data into python from JSON files • Start data cleaning on imports • Start data manipulation and match duplicate questions • Visualise the results Enable departments to harmonise questions within their surveys. Offer a resource to the wider ONS. INPUT TO I.T SYSTEM ADMIN DATA Enable the use of admin data to supplement survey. I.T development input. Offer input to DMP (Data Management Platform) / KMS (Knowledge Management System) / Authoring Tool.

17. Skills We Have Learnt

18. Other initiatives we are involved in Career talks and Data Science awareness days with local schools Local STEM ambassadors Blogs posts

19. Other initiatives we are involved in The Data Science Campus Launch Intruder testing on surveys Charitable endeavours

20. Learning pathways and other opportunities • There are many other pathways in the Learning Academy, if you would like more information, please contact: • Learning.Academy@ons.gov.uk

21. Any Questions? Do get in touch! datasciencecampus@ons.gov.uk