Economic migration and international trade analysis (slides 1-6)
National census data revealed an increase in international migration to Buckinghamshire, prompting political interest in the origins of new arrivals and the impact of Brexit. The analysis also investigated business exports by region and country. Utilising DWP and ONS open data, I created a comprehensive insight pack to support policy development, map migrant workers to skills shortages, and aid support initiatives for diverse communities. This work had a significant impact and was showcased nationally at a Local Government Association forum.
Poster for an international conference (slide 7)
The Open University promotes analytics, data science, and predictive modelling to foster cultural change among staff with the development and rollout of dashboards and insights (a strategy I was involved with). I created a poster for a showcase event at an international conference, highlighting the OU’s global analytics strategy and leadership in data science for large-cohort universities.
Key performance indicator visualisation (slide 8)
Concise data visualisation I created to highlight the overuse of KPIs across a local authority’s business units. Using thorough analysis and compelling visuals for a senior leader audience, I initiated a project to enhance and streamline the overall KPI reporting landscape.
Household Recycling Centres user profiles (slides 9&10)
An impactful visualisation showcased user profiles from a local survey of Household Recycling Centres. Presented to a non-technical steering group, it made the data more relatable and sparked meaningful discussions on inclusivity. The project resulted in the development of an online booking system, improved signage, and enhanced support options for individuals with disabilities. These changes helped transform the processes at recycling centres and improve user experiences.
Highway traffic insight pack (slides 11-13)
Visuals formed part of a highway traffic insight pack that analysed usage, pressures, and travel dynamics. Deep-dive analysis revealed unknown factors, highlighting for example rising light goods vehicle traffic and HGV traffic. Evidence supported strategic planning, contract tendering, and informed policy decisions on major infrastructure projects such as bypasses, link roads, and diversion routes.
2021 Census insight analysis pack (slide 14)
This analysis pack was created to offer a comprehensive examination of the 2021 national census results for a specific local authority area. It was essential to present the insights clearly and engagingly, emphasising the significant changes in the county’s demographic makeup and residents’ work and living arrangements over the last decade.
Data science deep dive into support provision for vulnerable people (slide 15)
An extensive insight, research, and predictive analytical modelling piece of work to fully understand vulnerable support provision for a ‘Helping Hand’ Charitable Service. The work was multifaceted; it provided quantitative statistics on the volume and types of support requests and provisions, the demographic profile of people using the service, and text analysis of case notes to identify support journeys (what had led people to seek support or multiple support provisions). I also developed two predictive models (Logistic Regression/Decision Trees) to predict increases or decreases in service usage based on prevailing economic conditions, and to highlight the likely demand placed on other public services (social care, GP Surgeries, housing services) should funding for the helping hand service be reduced.
Analytical deep dive into organisational support groups (slide 16)
A request from a corporate management team and human resources director in a large organisation (5,000+ employees) to glean insight and understanding around the number of statutory and non-statutory employee support groups and roles, including research into membership, remit, meeting cadence, and alignment with corporate strategies (or not). The work involved extensive information gathering, talking to people, creating and updating new records, and creating a synthesised final slide deck and presentation to outline the findings. The work highlighted challenges around having multiple support groups and some evidence that staff requesting support were being bounced around several different support groups when they should really have been using the corporately agreed employee support provider.
Analysis of departmental performance-related pay (slide 17)
Forensic analysis looking at data over several years to determine if departments within a large organisation were equitably using the performance-related pay framework. The brief for the work was to look holistically at departmental performance, staff sickness and turnover, number of complaints, health and safety incidents and employee performance ratings. The work demonstrated that bonuses were not in fact consistently applied across the organisation, leading to a new corporate appraisal process that implemented analytical checks and balances to ensure pay-related bonuses were awarded for genuinely good performance.
GDPR Comms exercise (slides 18-20)
Visualisations created for a slide deck as part of an engagement / communications exercise to raise awareness of GDPR data protection rules.
David Cook 