Trafford pilot

Final review of OpenGovIntelligence project, Research Executive Agency, Brussels. 25 February 2019.

Transcript

1. 25 February 2019, Brussels 2nd OpenGovIntelligence Review 1 Henry Partridge, Trafford Data Lab Trafford pilot
2. 25 February 2019, Brussels 2nd OpenGovIntelligence Review 2 To support Jobcentre Plus teams deliver services by co-developing a web application that visualises linked open statistical data on worklessness Service requirements • Target users are Jobcentre Plus work coaches and Local Authority leads for worklessness • Allow exploration of (geospatial) data to identify where service needs are greatest and where assets and groups that might support service delivery are located • Dashboard for decision-makers to get up- to-date information about worklessness Objective
3. 25 February 2019, Brussels 2nd OpenGovIntelligence Review 3 • The Department for Work and Pensions are reviewing the location of Jobcentre Plus offices • Jobcentre Plus offices provide resources that help people of working age find employment, offer advice on CV writing, interview techniques etc and administer claims for benefits • There are 637 job centre offices in Great Britain and 26 in Greater Manchester Initial problem
4. 25 February 2019, Brussels 2nd OpenGovIntelligence Review 4 Co-creation workshop and subsequent user testing (October - December 2017) User requirements • Interactive maps and charts • Benchmarking • Data download • Additional datasets • Option to render map by local authority Further requirement for signposting app for Preston Service Centre OGI co-creation
5. 25 February 2019, Brussels 2nd OpenGovIntelligence Review 5 OGI tools Validate GM DataStore Gather API Tidy R Convert table2qb Visualise D3 Leaflet Shiny Query CubiQL
6. 25 February 2019, Brussels 2nd OpenGovIntelligence Review 6 Data used Name Source Period Licence Claimant count Office for National Statistics Latest month OGL 3.0 Claimant rate Office for National Statistics Latest 36 months OGL 3.0 Households with lone parent not in employment Census 2011 2011-03-27 OGL 3.0 Social rented households Census 2011 2011-03-27 OGL 3.0 Working age adults with no qualifications Census 2011 2011-03-27 OGL 3.0 Employees by broad industry group Business Register and Employment Survey 2017 OGL 3.0 Working age population Office for National Statistics 2017 OGL 3.0
7. 25 February 2019, Brussels 2nd OpenGovIntelligence Review 7 • Work coaches and council worklessness leads are able to benchmark claimant rates across different geographical areas • The identification of hot and cold spots of worklessness can help determine the appropriateness of Jobcentre Plus office locations • Link workers are able to direct vulnerable clients to their nearest services • Tools and applications are scalable to other DWP areas Benefits