Public Sector Focus


Using data to enhance public services

Source: PSE Apr/May 17

Shane Green, programme manager for business intelligence & open data, and Sudip Trivedi, head of data & analytics and connectivity — Business Partner for Place at Camden Council, discuss the importance of using data analytics to improve service delivery.

Over the last few years, Camden Council has been on a significant digital transformation journey as it moves towards a more outcomes-based approach to service delivery. A keystone of this work has been how it has developed its consistent use of data and analytics. 

In 2014, the local authority implemented a Qlikview business intelligence platform and now council staff, of all levels of seniority, are using 70 dashboards to help analyse data and improve services. 

Shane Green, programme manager for business intelligence & open data at Camden Council, told PSE that the move to business intelligence is supporting evidence-based decision-making and, in effect, providing ‘one version of the truth’, while increasing accountability and transparency within the operational teams. 

“As part of the work we have been looking to get organisational coverage of dashboards across all the different major operational areas of the council,” he said, with the dashboards replacing a previously paper heavy system of managing performance. 

“In doing that, it has enabled people to actually know what it is important for them to measure to understand success for their specific area of the business. Unfortunately, as is the nature of the times we live in, when you have to make cuts you can evidence what change that is having on your business and whether you are able to do more with less.

“But as soon as you bring the data out of the operational systems and break the vendor lock-in that can be tied into these things, you actually start to build an environment where you can do quite a lot of cross-cutting. 

“For example, the finance system holds lots of finance data. We have a finance dashboard that allows you to search through millions of transactions, but the beauty of having the business intelligence programme is you can take the data from that finance system and then when you do an operational dashboard for, say, adult social care, you can plug the data back into that dashboard and start doing reconciliation between the two.” 

Camden was one of the first local authorities to embark on a council-wide business intelligence programme, and Sudip Trivedi, head of data & analytics and connectivity — Business Partner for Place, stated that the success “depends on the commitment that you can get from leadership”. 

“Where Camden is now,” he said, “is we are looking to do even more. The appetite is there to create a roadmap for the future and sharing more effectively with partners, for example, in health.” 

In terms of the programme of work, the officers told us that Camden has been focused on providing the business areas with tools to help them measure success. 

“We are getting to a position where the organisation is starting to think about cross-cutting and where we can bring data together from other systems and better improve outcomes,” said Green. 

However, they added that over the last few years a number of challenges have had to be overcome in three particular areas: data quality, culture and the underlying technology.

“Getting people to understand what you were trying to achieve has been one of the key challenges,” explained Green. “You also have the classic issue of data quality. But if you have people undertaking processes thousands of times, there is, inevitably, going to be errors in data. One of the brilliant things about business intelligence is that it exposes problems with the data and makes it easy for them to be rectified in the operational systems themselves.” 

One of the interesting challenges faced in a local government setting like Camden, PSE was told, is that some of the local authority’s systems “have been about since the dawn of time, as far as IT is concerned, because they don’t all run neatly on Oracle and other databases”. 

“There will always be issues with data quality, but how that data is then fixed is important,” said Green. “People are always going to make mistakes, but having tools that focus on the most granular levels of data and calculating statistics on that mean that if you have an anomaly in the dataset it is normally apparent.” 

While there have been issues to overcome during the development work, both Green and Trivedi argued that the move to dashboards has delivered both tangible and intangible benefits, from enabling self-service reporting and reducing time spent on manual processes to shining a light on data quality.



There are no comments. Why not be the first?

Add your comment


public sector executive tv

more videos >

latest public sector news

Government must encourage council scrutiny ‘culture change’

15/12/2017Government must encourage council scrutiny ‘culture change’

The government has to encourage a culture change within local councils in order to improve the quality of overview and scrutiny plans. The C... more >
London council to cut sick pay in cash-saving bid

15/12/2017London council to cut sick pay in cash-saving bid

A London council has proposed to stop paying sick pay for the first three days in a bid to save money. The GMB has called Hillingdon Council&rsq... more >
Burnham announces major 2018 GMCA transport overhaul

14/12/2017Burnham announces major 2018 GMCA transport overhaul

The mayor of Greater Manchester, Andy Burnham, has announced a major overhaul of the region’s transport network. Burnham said problems... more >

editor's comment

25/10/2017Take a moment to celebrate

Devolution, restructuring and widespread service reform: from a journalist’s perspective, it’s never been a more exciting time to report on the public sector. That’s why I could not be more thrilled to be taking over the reins at PSE at this key juncture. There could not be a feature that more perfectly encapsulates this... read more >

last word

The importance of openness after Grenfell

The importance of openness after Grenfell

Following the recent Grenfell Tower tragedy, Lord Porter, chairman of the LGA, argues that if the public are going to have faith in the safety testing process then everything must be out in the o... more > more last word articles >
149x260 PSE Subscribe button

the raven's daily blog

Whole of government must act together to fulfil the ambition of the Industrial Strategy

11/12/2017Whole of government must act together to fulfil the ambition of the Industrial Strategy

Jen Rae, head of innovation policy at Nesta, says the aims in the government’s new Industrial Strategy are ambitious, but will require a shift in policymaking in order to be realised in full. Last Monday saw the long-awaited launch of the UK’s new Industrial Strategy, the government’s plan for prosperity and growth in a ... more >
read more blog posts from 'the raven' >


Introducing the Facilities Management Marketplace

14/12/2017Introducing the Facilities Management Marketplace

The new Facilities Management (FM) Marketplace will be an opportunity to streamline the process of buying key services whilst propping up new ent... more >
Meet Pepper, the social care robot

14/12/2017Meet Pepper, the social care robot

Southend-on-Sea Borough Council has become the country’s first local authority to fully exploit the benefits of robotics in social care by ... more >
Quality, not quantity, is what matters

14/12/2017Quality, not quantity, is what matters

Luke Sibieta, research fellow at the Institute for Fiscal Studies and the Education Policy Institute, takes a look at the impact of the apprentic... more >
NCSC: A new and adventurous agenda

11/12/2017NCSC: A new and adventurous agenda

Ciaran Martin, chief executive of the National Cyber Security Centre (NCSC), reflects on the lessons learned during the first year of the governm... more >


Are we taking a risk on education?

14/12/2017Are we taking a risk on education?

Adrian Prandle, director of economic strategy and negotiations at the National Education Union (NEU), questions the stark lack of announcements a... more >
A fantastic opportunity awaits you

11/12/2017A fantastic opportunity awaits you

Eight months on from the government’s announcement of major training reforms, Anne Milton, minister for apprenticeships and skills at the D... more >
This is Manchester, we do things differently here

10/12/2017This is Manchester, we do things differently here

Joanne Roney OBE, chief executive of Manchester City Council, speaks to PSE’s Luana Salles about the region’s pioneering plans f... more >
Andy Burnham: the crisis unfolding in front of our eyes

10/12/2017Andy Burnham: the crisis unfolding in front of our eyes

With homelessness on the rise across the country, politicians in central and local government are desperately looking for new solutions. Andy Bur... more >