In the first instalment of case studies from Wirral Council, we focused on how Local Insight was saving the Wirral Intelligence Service time and resources by allowing them to respond to data requests in a much more efficient manner.
However, Local Insight isn’t confined to just the Wirral Intelligence Service. Staff from across the organisation and beyond have been using Local Insight to support evidence-based decision making.
Local Insight covers unlimited users across your organisation and strategic partnership. It has been designed to be accessible by all; so that you don’t need to be a statistician to gain useful insights. And with the public facing versions of the tool – anybody can access the data, without needing any login details.
When looking for a data and reporting tool, the ease of use and flexibility were of utmost importance to the team – because they wanted to open access to the wider team and council. With more than 70 users trained in using the system, Local Insight has become a useful way to share and communicate data across teams.
In a fast-paced environment with overflowing inboxes – reading reports can quickly end up at a bottom of a ‘to-do’ pile. Before using Local Insight, the team at Wirral lacked a way to be able to share the data and information they were producing in an accessible way, that people would pay attention to.
Robbie says “it used to be a case of creating loads of reports, run it all through SQL, put into a GIS system, create long reports that would sit on somebody’s desk forever. Or it might get sent out in an email. And maybe 4 or 5 people would look at it and find it interesting. But with Local Insight, we can make people more aware of it. People can quickly go on and see what it looks like.”
For Wirral, this has been one of the biggest benefits of using the system, Robbie continues “it is really interactive, in terms of being able to get others to use it. There isn’t any other software we have got where we can load in geographic data so quickly and have that ready to show somebody in our organisation or who is off site immediately. Being able to use it wherever you are is a really big bonus.”
Alongside all of the open data within the system, the team at Wirral have added in their own data too; by uploading the locations of key services and adding their own datasets to the map.
This provides a centralised place in which to store datasets that are provided by disparate teams for reuse and to avoid duplicating work.
Robbie explains how this works in practice; “We receive a cut of Hospital Episode Statistics in Wirral for the last 10 years from NHS Digital – which is a huge dataset. We are now looking to pull out some indicators, for example, emergency admissions or cancer admissions. We’ll probably make about 10 – 12 indicators from that dataset and upload it to Local Insight; which can then be used by Contract Managers or Clinical Commissioning Groups.”
The Licensing Team has also shared some of their data, on location of local assets – which has cross-cutting implications for the Wirral Intelligence Service.
Using the data provided by the Licensing Team, some of the Wirral Intelligence Service ran a study on a couple of areas. The idea was that there are certain types of premises that are deemed ‘unhealthy assets’; for example bookmakers, pubs and payday loan shops. The team ran a study on where these were and came up with 5 niche areas that span a couple of streets, where there is a high concentration of these types of premises.
Local Insight was then used as a very quick and simple way of visualising these areas on a map, overlaid with the assets data, which could be used as accompanying visuals in reports and publications.
Furthermore, once the Healthy High Streets had been set up in Local Insight, the team could generate an area profile report in minutes, to dig into the underlying data about those areas.
We will publish the final case study with Wirral in the coming weeks – and it is one for anybody that is involved with place-based commissioning in their local areas.
In the meantime, to see Local Insight for yourself; sign up for a free trial.