Skip to content

Pipelines


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

Diagram showing how intelligence is produced from Hospital Episode data, more description is provided in the caption below.
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.

 

Diagram showing datasets being used by a piece of software to create a map, more description is provided in the caption below.
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.

 

Diagram showing how intelligence is created about problem alcohol use, more description is provided in the caption below.
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

Diagram showing the complexity of managing and reporting waste data, more description is provided in the caption below.
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.

Beta