ICAEW.com works better with JavaScript enabled.

Leading data-led decision-making in local government

Author: ICAEW Insights

Published: 05 Dec 2024

Iain Murray, Director of Public Financial Management, CIPFA

Iain Murray, Director of Public Financial Management, CIPFA

Finance professionals are pivotal in ensuring local authority decisions on service delivery are grounded in robust data analysis. CIPFA’s Iain Murray outlines the role of finance teams in ensuring data-led decision-making and the skills required for success.

The nature of services provided by local authorities make it particularly important that decisions are based on detailed evidence, as well as an understanding of human impact.

“Understanding what is happening in their communities and the needs they are trying to meet for their citizens, means that finance professionals can do the best possible job with the finite resources they have available,” explains Iain Murray, Director of Public Financial Management at CIPFA.

Rikin Tailor, Director of Finance at Westminster City Council, agrees: “It is important to remember that financial pressures are a consequence of underlying trends within different service areas. Reducing overspend in a service area is not simply a case of bringing that pound figure down, it's about understanding what needs to be done to reduce the underlying numbers. That’s where data is really powerful and important. It tells you what is happening behind the financials, in the community.”

Tailor cites the example of rising costs in temporary accommodation over the past year in Westminster. “Going forward, we need to understand how the number of people needing these services will change and the key reasons underpinning these trends. In turn, that will help us understand what we can do to manage the financial pressures,” he says.

“We therefore need detailed data, not just the number of people needing temporary accommodation, but how many are staying in overnight accommodation? How many are in private sector leased properties? What is the split between families and single people? Better understanding of that more detailed data enables us to devise a strategy for reducing demand.” 

Identifying the right data 

Identifying the right data to use can be challenging. “The starting point is narrowing it down to the questions you are trying to answer and understanding the outcome that you want to achieve,” notes Murray. “Public sector bodies are sat on huge amounts of data, not all of which is going to be relevant, so having that focus is really important.” 

“Often you won't have the perfect answer or exactly the data you need,” he adds. “However, painting a picture by pulling three or four different bits of information together to get as close as you can to that evidence is a key skill for finance teams to employ. For example, a number of local authorities have been seeking to understand where the pockets of deprivation are in their boroughs. While there is publicly available data, such as ONS and census data, they have identified other information at their fingertips, such as those in receipt of council tax support, in rent arrears, or council tax arrears, that can also give them some good indications.” 

Working in partnership

For effective data and evidence-led decision-making in local authorities, Murray notes that “it's got to be a multi-disciplinary, ‘whole organisation’ effort; making sure that finance teams aren’t operating in a bubble, but are creating genuine partnerships with people in different service areas.”

Rikin Tailor, Director of Finance at Westminster City Council

Rikin Tailor, Director of Finance at Westminster City Council

Tailor underlines the challenges created by the variations that can exist across teams. “Finance teams can be dealing with different individuals using different systems that each have different levels of interaction with a council’s corporate systems. You’ve almost got to take a case-by-case approach to understand how to get the data, how it flows through information systems, and then how that data can be used to make informed decisions,” he says.

“Finance professionals are very good at putting systems, structures and processes around collecting information,” adds Murray. “Therefore, one of the key roles that finance teams can play is applying their professional skills and disciplines to the data gathering process, helping non-finance professionals understand how to put the same rigorous processes and control around their data and information gathering.” 

Clear communication and messaging

Finance professionals also play a key role in driving understanding and engagement among decision makers who have varying levels of financial knowledge.

“In a local authority setting, with elected members who have varied professional or personal backgrounds, it needs to be as easy as possible for people to join the dots between performance and spend,” says Murray. “For example, if a local authority is spending a lot of money, but not delivering the expected outcomes, that's really important to understand. Yet quite often, the two are reported separately. Instead, reporting should enable people to see finance and activity together.”

Technology is important in presenting a compelling narrative, as well as enabling a more integrated approach between finance and the different service areas. 

“Local government is still on a journey in terms of understanding the available tools and the best ones to use,” says Tailor. “However, it is important to remember that it's not just about creating fancy graphs, it's about presenting data in a way that clearly delivers your key messages so that people can understand, scrutinise and act on it.”

Finance professionals, therefore, need to be adept at negotiation, persuasion, and storytelling to ensure their insights are heard and understood. Building strong relationships with elected officials and other stakeholders is a crucial part of their role.

“Local authority finance professionals have to be able to deliver uncomfortable messages, particularly given the political dimension and the tensions that can exist between councillor manifestos and public finances,” explains Tailor.

Murray agrees: “One of the big challenges for our members is that quite often they have to speak truth to power. They have to help the organisation deal with what can be difficult and unpalatable decisions, particularly given the current state of public finances.”

AI and ML potential

Looking to the future, advances in technology, such as artificial intelligence (AI) and machine learning (ML) have the potential to transform data analysis and improve decision-making. “We see a huge opportunity for ML and AI to tackle the complicated modelling behind demand forecasting. It can also help with the difficult task of making the case for prevention. With the Health Foundation, for example, we are currently using powerful tools and analytics to examine the case for more upfront investment in certain areas of public service provision, such as leisure, education, and housing - predeterminants of healthy populations – to reduce future demand in acute care settings,” says Murray.

However, these technology advances also place an additional emphasis on the changing skill set required for practitioners. “We want finance professionals to see themselves as leaders,” concludes Murray. “They should feel empowered and proud about what the profession has to offer, and how they can help public sector organisations achieve their objectives and meet the needs of their communities.”

Action points

  • Identify and consider the needs of key stakeholder groups regarding financial information.
  • Incorporate an introduction to local government finances into induction programmes. 
  • Implement ongoing training to meet any skills gaps identified and educate stakeholders. 
  • Harness technology to aid decision-making and improve financial reporting. 
  • Investigate using data visualisation tools to bring data to life.
     
Local government finance: skills for the future

Improving financial skills is critical in balancing the books and delivering value for citizens. This content forms part of a series of ICAEW resources examining how local authorities can rethink their approach to financial management.

Transforming data with Power BI

Watch our joint webinar with CIPFA, to discover the benefits of using Power BI to transform public sector data into compelling insights to support decision making.

Middle-aged white man studying laptop screen and taking notes

Further support

ICAEW Community
Public Sector polaroid
Public Sector Community

The go-to place for guidance on issues affecting finance professionals working in and with the public sector. With a range of dynamic services, ICAEW provides valuable tools, resources and support tailored to the public sector.

Event
Public sector conference
Public Sector Conference

Join your peers to explore the future skills needed for the central and local government finance profession at ICAEW's annual virtual conference.

Find out more Register now
ICAEW support
A group of people in a meeting room with their laptops, woman at the whiteboard with sticky notes
Training and events

Browse upcoming and on-demand ICAEW events and webinars offering support on technical areas, such as assurance, reporting and tax, as well as personal development.

Events and webinars A-Z of CPD courses
Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250