Marginal gains: An incremental approach to transformation

Written by Richard Whomes on 26 May 2017 in Opinion
Opinion

Budget constraints and practicalities might prevent councils from making large-scale changes to their IT systems. But, says Richard Whomes, even the smallest steps to modernisation can make a big impact.

Virtualisation and business intelligence software being used to great effect Credit: Press Association Images

The current economic climate is putting the public sector under severe pressure, with many local governments stretched to breaking point by continued funding cuts and the need to care for an ageing population.

The computer systems used in local government have often been in place for decades, and have not necessarily been designed to cope with modern demands for information.

But the pressure on local government to cut costs means that councils can’t afford to simply rip out or rebuild these old systems.

Instead, they have to modernise their existing infrastructure so it’s better able to manage data and deliver real benefits in terms of both efficiency and cost reduction.

To do this, two technologies in particular - virtualisation and business intelligence software - are being used to great effect across the country to tackle specific problems – like these real-life examples listed below. Some of these may seem small, but in a climate like this, every saving counts.

Speeding up spreadsheets

In many councils, managers still rely heavily on spreadsheets for reporting and performance management, which makes it difficult to aggregate and analyse the data centrally. Instead, the use of different spreadsheets means that each manager ends up collecting, collating and reporting data separately, which is time-consuming and inefficient.

The performance managers at one council were tasked with reporting on four council groups: people, communities, resources and fire. The organisation’s performance management system was approaching the end of its licensing agreement, and didn’t cover all the relevant departments.

So the council decided to create a management dashboard that could translate large volumes of raw data into meaningful information, with easy to read reports and graphics.

This has made it possible to track, manage and communicate strategies and initiatives across all four groups, improving operational effectiveness.

Spotting subletting

One problem that frequently affects local councils is social housing tenancy fraud, where tenants sublet their social housing for a profit. In theory, the council holds all the necessary information to identify these fraudsters, but in practice things are not always straightforward.

Because of the siloed nature of many councils’ IT systems – which often remain separated by department – the data relating to one part of the council is held in a completely isolated database, without any connections to associated functions. This makes it almost impossible to trace the activities of an individual across the council’s various databases.

To tackle this, one council has used an advanced business intelligence technology, which is based on the virtualisation of data. Business intelligence software allows organisations to analyse large quantities of data quickly to identify trends and to understand patterns of behaviour. By taking data from a group of disparate systems and holding it virtually, the business intelligence analyses the council’s information in a centralised way.

When looking to address tenancy fraud, twelve different departments’ data sources were compared to identify those in social housing who had multiple addresses. From this, behavioural markers that might indicate tenancy fraud were cross-examined, leading to earlier alerts and increased efficiencies around social housing.

Tracking trolleys

Among the more mundane responsibilities of local councils are tasks such as bin collection, road maintenance and general clearing up. One city council found that it regularly had to deal with abandoned shopping trolleys on roads and pavements, using valuable employee time to return them to various supermarkets. Reports of these trolleys came from individuals, community officers and even the police, but no records were kept noting the location or the supermarket from which they came.

By simply putting this information into a centralised database, the council was able to identify that 69% of trolleys found in the area came from one supermarket. A call to the regional manager of this store led to the installation of coin operated systems, which resulted in a 90% reduction in reported cases.

By recording all instances of dumped trolleys, the council was able to identify any trends and take appropriate proactive actions to address the issue.

Small changes can mean the world

In the current economic climate, it’s important to bear in mind the small changes that councils can implement in order to improve their efficiency in the face of shrinking budgets.

Improving the use of data by bringing together and analysing records from different parts of the organisation is one of the most effective ways of doing more with less.

In an ideal world, all the various systems of a council – and between councils – will be linked.

In the meantime, modernising existing IT systems is a cost-effective way of boosting efficiency, keeping costs under control and providing the best possible service to local residents. 

Richard Whomes is director of sales engineering at Rocket Software

Share this page

Tags

CONTRIBUTIONS FROM READERS

Please login to post a comment or register for a free account.

Related Articles

MHCLG digital chief: ‘I want us to be proud plumbers’
24 May 2018

Paul Maltby claims councils must first renew ageing infrastructure before realising the benefits of machine learning and automation 

Interview: Surveillance Camera Commissioner discusses his mission to protect privacy and human rights
10 April 2018

As an ever-greater volume of increasingly sophisticated devices watch us all, PublicTechnology talks to regulator Tony Porter about his office’s role in ensuring surveillance is always...

Voice activation, service transformation, and deliberately delayed mortgages – six things we learned at Sprint 18
11 May 2018

The relaunched annual GDS event shone a light on the government’s key digital-transformation strategies and initiatives for the coming months and years. PublicTechnology went along to...

GDS will remain within Cabinet Office, minister pledges
11 May 2018

Oliver Dowden, whose ministerial brief contains responsibility for GDS, has claimed that the recent move of data policy to DCMS ‘should not be seen as a change of direction’

Related Sponsored Articles

Building trust in the digital age
15 May 2018

BT argues that the digital age requires a certain level of trust in technology. But how can we establish this and still make the most of digital transformation?

GDPR compliance as a detox exercise
8 May 2018

BT's Mike Pannell argues that organisations should get rid of data they no longer need