Public Sector Focus

25.04.17

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.

FOR MORE INFORMATION

www.camden.gov.uk

Comments

There are no comments. Why not be the first?

Add your comment

 

public sector executive tv

more videos >

latest public sector news

Greening promises to close DfE’s 5.3% gender pay gap

28/06/2017Greening promises to close DfE’s 5.3% gender pay gap

The Department for Education (DfE) has become the first government department to publish its gender pay gap, revealing a 5.3% difference between ... more >
Unions back Labour amendment to end public sector pay cap

28/06/2017Unions back Labour amendment to end public sector pay cap

Two of the largest public sector unions have given their backing to an amendment tabled by Labour which calls for more funding for the emergency ... more >
Sheffield LEP: Politicians must stay focused on next step of stalled devo deal

27/06/2017Sheffield LEP: Politicians must stay focused on next step of stalled devo deal

Private sector board members in the Sheffield Local Enterprise Partnership (LEP) have signalled their continued support for the region’s de... more >

editor's comment

15/06/2017Challenges remain

As PSE went to press, we were days away from finding out which political party or parties would be leading the country following Theresa May’s decision to call a snap general election for 8 June.  Whoever enters the door at No.10, irrelevant of their political colour, is faced with serious challenges, from social care to the NH... read more >

last word

National policies won’t fix local problems

National policies won’t fix local problems

Andrew Carter, the recently-appointed chief executive of Centre for Cities, argues that the new government will only succeed if it focuses on implementing policies that are adaptable to place-bas... more > more last word articles >
149x260 PSE Subscribe button

the raven's daily blog

Councillors celebrated in Queen’s Birthday Honours list 2017

19/06/2017Councillors celebrated in Queen’s Birthday Honours list 2017

A number of local government leaders and figures have been named in the Queen’s 2017 Birthday Honours list. The list recognises the achievements of people across a number of different sectors by handing out awards for services to their respective fields. All in all, 1,109 people received an award this year, as 554 (50%) of peop... more >
read more blog posts from 'the raven' >

comment

Innovation in commissioning services

26/06/2017Innovation in commissioning services

Malcolm Harbour CBE, who wrote Parliament’s first report on innovation in public procurement in 2008 and now chairs the LGA expert group on... more >
Engaging the voluntary sector: how to make devolution a success

26/06/2017Engaging the voluntary sector: how to make devolution a success

Paul Winyard, senior policy officer at the National Council for Voluntary Organisations (NCVO), explains why it’s fundamental that the thir... more >
The impact of the cyber security strategy on the public sector

26/06/2017The impact of the cyber security strategy on the public sector

Six months on from the announcement of the government’s National Cyber Security Strategy, Talal Rajab, head of programme – cyber and ... more >
Police governance and service delivery in the 21st century

23/06/2017Police governance and service delivery in the 21st century

Barry Loveday, reader in criminal justice administration at the University of Portsmouth, considers the role that the new metro mayors will have ... more >

interviews

HSCN: The enabler for a more joined-up public sector

26/06/2017HSCN: The enabler for a more joined-up public sector

Mark Hall, Chief Assurance Officer at Redcentric, discusses NHS Digital’s project, the new Health and Social Care Network (HSCN) and what b... more >
Maintaining the momentum for further devolution

25/04/2017Maintaining the momentum for further devolution

Ahead of this year’s mayoral elections, Lord Kerslake, the former head of the Civil Service, tells PSE’s David Stevenson why the argu... more >
New social care funding misses the point

13/04/2017New social care funding misses the point

Clive Betts MP, chair of the Communities and Local Government (CLG) Committee, reflects on the social care funding released in this year’s ... more >
Leading transformational change through procurement

01/03/2017Leading transformational change through procurement

Liz Welton, chair of the Society of Procurement Officers in Local Government (SOPO), tells PSE’s David Stevenson why there are lots of oppo... more >