What was the problem? The Public Health Intelligent Team (PHIT) have experience working with data across databases (SQL Server Management Studio, Azure Data Studio), its analysis, and the utilisation of database querying languages such as SQL. The data is presently housed in the Devon County Council (DCC) on-premises servers. With cloud-based storage beginning to supersede […]
The Smarter Devon programme have invested in User Experience upskilling for the workforce so we can ensure we are creating data that is clear to understand for every skill. We put the end-user at the front of every design decision we make. We look at how a user feels when using a product, system or […]
What was The Problem? The Public Health Intelligence Team had to create an interactive Lifestyle Behaviours dashboard by combining several datasets efficiently. The primary goal of the first iteration of the dashboard was to visualise the data in a way that would help understand three behavioural risk factors (smoking, obesity, and physical activity) across Devon. […]
Data The term “data” refers to raw facts, events, experiences, and observations. Data can be thought of as signals we receive through our senses. Data is defined by what it is not: lacking meaning or value, unorganised and unprocessed. Examples of data include the number of people supported by a service, the time taken to […]
Introduction Devon County Council (DCC) is a top tier local authority which follows a strategic plan[1] focused on working together to improve life across Devon for everyone. It wants to create a place that people enjoy living in, as well as a place where it is enjoyable to work. Devon has a population of over […]
What was the problem? The Trading Standards department required some guidance in upgrading their reporting system. The existing process was quite arduous – it required Trading Standards employees to do a lot of manual work. A lot of the work required was very repetitive, and so employees needed to dedicate a lot of time to […]
What was the problem? Children’s Services department have been working with Power Bi to do reporting. The main problem that this department was facing was the large amount of time it takes to report on key metrics. Due to the complexity of the reporting and data requirements, a lot of time is spent processing and […]
What was The Problem? Absence from school has a negative link to a child’s attainment. Devon County Council’s (DCC) Education department is responsible for monitoring absence and truancy2 to ensure more pupils regularly attend school and leave with the qualifications they need to succeed. Collecting attendance data is a complex undertaking. Interventions to support pupils […]
A child’s attendance at school impacts the outcomes they have in later life. Monitoring attendance is always important, but during the Covid 19 pandemic it became critical. When the COVID-19 crisis struck, and schools closed to all except vulnerable children and those of key workers, the existing reporting needed to be enhanced to make sure […]
Covid-19 Coroner planning for excess deaths What was the problem? At the start of the Covid 19 pandemic we had very little information and a potential disaster looming. Our Emergency Planning team were there to guide us, but this was a completely new situation and there were still some key questions: What did we do? […]