Bringing it all together!

Bringing it all together!
Presentation to the Local Area Research and Intelligence Association (Laria) Annual Conference, 14 May 2019

Transcript

1. Bringing it all together! Si Chun Lam Insight Development Manager Coventry City Council
2. Housing and homelessness ℹ️ Compliments, comments and complaints Culture ☺️ Health and wellbeing Geographical information systems “Questioning, influencing and providing understanding to make life better in Coventry”
3. Aims Inform Share
4. Making use of information Low High Making use of what we know High Data collected about individuals Privacy controls and democratic accountability
5. From individual projects... Platforms Projects
6. Performance hub ...to building platforms... Engagement platform Data platform (citywide intelligence hub)
7. ...to free up time for advanced insight What is happening Descriptive analytics Why is it happening Diagnostic analytics What is likely to happen Predictive analytics What should we do Prescriptive analytics Hindsight Insight Foresight Static reports and data books Static spreadsheets Static maps Government statistical returns Performance dashboards and Power BI reports Interactive spreadsheets and open data Spatial data Data automation
8. Data platform Survey data Internal systems e.g. social care, education, finance, HR Community intelligence Partner data External data e.g. Fingertips, LGInformPlus EXTERNAL INTERNAL
9. Citywide intelligence hub “single source of truth” Health and wellbeing JSNA DPH Annual Report Cultural profiles City of Culture Trust Council Plan performance report & performance reporting Housing and homelessness Headline statistics Social care e.g. market position statement
10. Data exploration Health and wellbeing (JSNA) collection plan Data collection plan Import Themes Identify all the indicators we want to collect – and where they’re coming from (data sources) Culture collection plan Housing and homelessness collection plan Assign themes and sub-categories to each data item Set up import routines to import the data into the data warehouse
11. Data model Data sources csv files Power BI ! A data model that allows us to store indicator data over any bespoke space and time: as long as an indicator has a geographical and time dimension, it will fit in this data model. Values Indicators (Metrics) Periods Geographies (Areas) Data warehouse Themes look-up table Shapes look-up table Extract Transform Load (ETL) routine to change data to correct format Import routine with refresh period
12. Themes Citywide Locality Citywide intelligence hub data profiler tool Demographics Prospects Environment Health and wellbeing JSNA analytical profiles setting out... Engagement Data Coventryjoint strategic needs assessment (JSNA) JSNA analytical profiles setting out... Engagement Data Demographics Prospects Environment Health and wellbeing Citywide Locality Citywide intelligence hub data profiler tool
13. Coventry Dudley 25-29 year olds 18-24 year olds 65+ year olds ⏫ Increase in working aged residents – not just students! Only 14% of the population BUT the growth of elderly population will accelerate and will be growing faster than the rest of the population within 10 - 15 years – need to prepare for this shift Demographics and community Sustained high population growth rates in the past decade; 7th highest in 2016-17. ...rising to 49% in schools One in three Coventry residents are black or minority ethnic (BME)... ...highest growth particularly amongst 18- 29 year olds Asian Indians make the largest minority ethnic group in the city. Fastest growing minority ethnic groups (overall and amongst school children) are: Black Africans Asian Other White Other 38% of school children were from BME backgrounds in 2011 vs 49% in 2019, up 11% As the city becomes more diverse, community cohesion in the city remains positive. However this has decreased 6%. Migrants also report less safe following the Brexit referendum. High levels of cohesion isn’t mirrored by community engagement: 61% do not feel they have any influence on decision-making, not even their in the local area. 95% chat to their neighbours 88% say people get on well together Partnership to empower and build capacity/skills within local and newly arriving communities with the view to promote community cohesion. Network of 30 local organisations to leverage external funding to create opportunities for young people. There are barriers around communication and awareness of assets in the city, but there is an appetite to work in more joined up ways. Sustained high population growth rates in the past decade; 7th highest in 2016-17...highest growth amongst 18-29 year olds One in three Coventry residents are black or minority ethnic (BME)... rising to 49% in schools. 95% chat to their neighbours 88% say people get on well together There are barriers around communication and awareness of assets in the city, but there is an appetite to work in more joined up ways. Examples include...
14. Prospects 19% of Coventry neighbourhoods are amongst the 10% most deprived in England 95% of primary and 74% of secondary students in good/outstanding schools 35% of the working aged population (80,800 people) are qualified to NVQ Level 4... however nearly 10% (22,600) have no qualifications. 5.4% of young people aged 16-17 not in education, employment, or training: lower than average 60% of Key Stage 4 pupils achieve grades 9 to 4 in GCSE including English and Maths... ...however amongst those from deprived backgrounds, only 44% do. Both figures are comparable to the regional and national averages. The city’s Family Hubs is a place where children, young people and their families can go when in need of help and support. Health visitors, midwives, neighbourhood police and social care work together to identify and provide early intervention to vulnerable families. A Universal Credit working group and a Welfare Reform working together group brings together advice agencies working to support the most vulnerable across the city to share updates, learning and collaborate on best practice. The Time Union gives an opportunity for adults in the city to share their time and skills with one another. Lots of examples... however growing greater capacity for greater social action requires greater connectivity. There are opportunities to: make social action more visible; shift to an enabling leadership style; do more to improve connectivity; pool engagement resources e.g. out of hospital work and Council’s social care. Have we really invested enough resources to enable our communities to do more? 19% of Coventry neighbourhoods are amongst the 10% most deprived in England 95% of primary and 74% of secondary students in good/outstanding schools 35% of the working aged population (80,800 people) are qualified to NVQ Level 4... however nearly 10% (22,600) have no qualifications. 5.4% of young people aged 16-17 not in education, employment, or training: lower than average Family Hubs provide multi-agency and early intervention for vulnerable families. Advice agencies are working together to support the most vulnerable. The Time Union promotes time and skill sharing. Growing greater capacity for greater social action requires greater connectivity. There are opportunities to: make social action more visible; shift to an enabling leadership style; do more to improve connectivity; pool engagement resources e.g. out of hospital work and Council’s social care.
15. Environment 84% satisfied with their local area as a place to live However people feel increasingly unsafe – particularly young people Majority of residents live within a 20-minute walk of shops, public transport, parks, pubs, GP, place of worship House prices in the city are lower than the regional average... but rent is slightly higher. At 74%, fewer adults feel safe in the city. And amongst young people, only 17% feel safe in the city. This may reflect the national and local surge in recorded violent crime – as well as the effects of social media coverage. Volunteers from a local church clean up the local park and host activities for local people. The local library improved perceptions of a local park: bringing books, maintaining a local presence and keeping out gangs. To address County Lines, substance misuse, knife crime and criminal exploitation, the city needs to provide more opportunities for people to shape services (e.g. young people, people with lived experiences). The city is developing a public health approach to tackling knife crime. It also needs to make better use of social media to engage young people as well as young families. 84% satisfied with their local area as a place to live However people feel increasingly unsafe – particularly young people Volunteers organise park clean-ups. By maintaining a presence in the park, libraries can drive away gangs. The city can work to provide more opportunities for people to shape services (e.g. young people, people with lived experiences) The city is developing a public health approach to tackling knife crime. It should also make better use of social media.
16. Health and wellbeing Life expectancy in Coventry remain consistenly below England but healthy life expectancy is similar to England. Health outcomes are worse in the most deprived areas, where people not only live shorter lives, but spend a bigger portion of their years in poor health, and are more likely to die of preventable causes. A&E attendance rates are not out of the ordinary BUT vulnerable groups appear to be relatively heavy users of emergency admitted care services Coventry falls behind national levels in screening and vaccinations: this is important to shift focus onto prevention. National data suggests that between 2012-2014 and 2015- 2017, life expectancy between the rich and poor further increased. In particular, there was a decrease in life expectancy for females in poorer areas – resulting in a widening of inequality in life expectancy gap amongst females (7.4 years), although the gap for males (9.4 years) remain larger. Early mortality (<75 years) Worse than national Cardiovascular x x Cancer x x Liver disease x Respiratory disease x x Communicable diseases x x Vulnerable groups living in Coventry (i.e. young people, older people, people with mental health / behavioural risk issues) appear to be relatively heavy users of emergency admitted care services when compared both nationally and regionally. Population vaccination coverage for a significant number of vaccinations are lower in Coventry than regionally/nationally. Cancer screening, HIV testing, genital herpes diagnosis and STI diagnosis/testing also appear to trail regionally/nationally. It is important to consider the whole social gradient – continue looking at the most deprived areas, but also engaging less deprived areas. Building a network to help them stay in touch and help residents access them. A lot of community initiatives and activities are happening. Life expectancy in Coventry remain consistenly below the England average. However, health outcomes are worse in the most deprived areas. A&E attendance rates are not out of the ordinary BUT vulnerable groups appear to be relatively heavy users of emergency admitted care services Screening and vaccination rates are below national averages In line with Marmot, we need to consider the whole social gradient. Building a network to help them stay in touch and help residents access them. A lot of community initiatives and activities are happening.
17. Recommendations DEMOGRAPHICS ANDCOMMUNITY PROSPECTS ENVIRONMENT • The city must be prepared for agrowing, changing and increasingly diverse population. • With the anticipated growth in older people, there is a need to focus on preventative health amongst the working agepopulation. • As population growth is concentrated in certain parts of the city, access to services should bereviewed. • The city’s rich community assets can help address specific needs related to newly arrived communities. • Increasing participation and involvement will help maintain cohesion and reduce radicalisation andextremism. t i t city s c t y i s is t ss s i s s t s isi s i ti s st sc c i t t i i s i ssi s t s i t city s s ’s i t i ss cti ity i s ci ty i c y t i y y s c ti i st t i t y i ti ic ti i t ti is c itic Young ’s aspirations may be raised by improving their awareness of the significant and growing opportunities in highly paid jobs available in the city, which require people with the right skills and qualifications. Organisations working together can help to address poverty and its impacts, and to ensure inclusive growth for t city’s most vulnerableresidents. • t i st i c s s t t c s i s t ss c ts iss tis cti it c i s iss s s c s cc ss i ity si c i ity • c ti s s ty s ss t t s i c • t s i t city s tt s s ci i ic is i c si i i s y t i c s s i ti • A joined-up approach is essential for t c i t city’s ss ss and rough sleeping problem, recognising the intersection of severe and multiple disadvantages faced bypeople. • Partners should look to provide more opportunities for people to shape services, including involving people with lived experiences. • The city should champion the emerging public health approach to tackling knife crime. Connected, safe and sustainablecommunities. Harnessing the city’s growth anddiversity Helping people to access opportunities andthrive APPROACH • As life expectancy is below average and health outcomes are worse in more deprived areas, a targeted approach of appropriate support to each group is essential to improve health and wellbeing for all groups. • Further investigation at a locality level as to whether avoidable differences in health are widening and the reasons for it will help identifylocalpriorities. • In line with the shift to focus onto prevention, a community-informed and culturally competent approach is essential to increasing screening and vaccination rates. • The city’s rates to emergency admitted care services appear high especially for some vulnerable groups, and further investigation will help determine how much of this is down to admissionthresholds. • Further work is required at a local level, through the place-based profiles, to st t city’s avoidable differences in health outcomes, particularly around issues such as alcohol use, obesity/ physical activity, Tuberculosis, sexual health (including HIV) and the consequential impacts on the demand for health and care services. Health is determined by ’ social circumstances such as their communities, prospects and environment; and similarly, this approach to addressing and improving these circumstances must also be rooted in local people and communities. Growing this capacity in the communities require improving connectivity. This can be doneby: • distributing leadership valuing the community leaders that are already working in this space as they have the trust, networks, understanding and legitimacy, and getting behind existing partnerships; • joining forces getting the public sector to work together by pooling resources to build capacity and connections, investing resources to enable communities to maximise social action; • grassroots activities making social action activities across the different sectors more visible; and • forging links building links and generating connectivity by helping partners and communities share what they do, and helping them learn from, and build partnerships, with eachother. Healthy and independent forlonger i t t i c s it c iti s
18. Data profiler tool
19. Data profiler tool: line chart
20. Data profiler tool: LSOAmap
21. Data correlation tool
22. Data correlation tool: England map
23. Data correlation tool: LSOAmap
24. Find out more... Si Chun Lam Insight Development Manager (Place and Public Sector Transformation) Coventry City Council www.coventry.gov.uk/infoandstats/ www.coventry.gov.uk/jsna/ SiChun.Lam@coventry.gov.uk