Here are some of the data and intelligence pipelines we have been creating. They show the journey of data from it’s creation, as a result of people doing work or receiving a service, to the decisions and impact we make from that intelligence and information.
Whilst they’re all slightly different in the level of detail and approach, it’s been really interesting to work with analysts and understand what they are tasked with doing.
If you want to learn more, or want to map your intelligence pipeline please get in touch. Public Health
Anonymised and cleaned ‘Hospital Episode Statistics’ data is collected from the NHS, and we use it to get an understanding for Devon. Several data sources are combined to create information that can be used for lots of different pieces of work, including the Joint Strategic Needs Assessment. Elements of this process are automated where possible, especially important because there is a high volume of data.
This is a more straightforward example of how data is combined to become useful information and intelligence, in this case to show incidents of Domestic Abuse and Sexual Violence. One piece of software combines multiple geo-spatial datasets with the incident dataset, producing several maps that were used to inform where we should target resources.
This is an example of how the Public Health team create information from external data sources that can be used to target work about safe consumption and use of alcohol. Several datasets are combined with a single SQL query, where the information is combined by Excel that is done automatically by a pre-built template. Waste Management
Managing waste and data about waste is a joint effort between Waste Disposal Authorities, such as Devon County Council, and Waste Collection Authorities, such as Devon’s District Councils. This data flow is primarily focussed on data DCC needs and uses, but also shows where we interact with the District Councils to provide information for statutory purposes. The number of agencies and expectations of national and European reporting make this quite complex, especially because Devon County Council have to report on some of the District Council activity. Because several agencies are involved, copying and pasting the same information between systems is required. Is there anything wrong with this page?