Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • FP&A Trends Digest
    • FP&A Trends Research
    • FP&A Trends Insight Paper
    • FP&A Trends Survey
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI/ML Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Tools
    • FP&A Trends Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
image
London FP&A Board: FP&A Analytics Maturity Model
December 20, 2017

By Larysa Melnychuk, CEO and Founder at FP&A Trends Group and International FP&A Board

FP&A Tags
FP&A Board Meetings Insights

Introduction

The future is unpredictable, the current business environment is harsh, competition is fierce. In these times of change, modern FP&A is both exciting and challenging. It is exciting because it utilises better and more sophisticated tools than previously, can embrace automation and the incredible power of online collaboration. However it is difficult because old finance management practices are still alive: they are inadequate for the modern world, but FP&A professionals continue to live from a deadline to a deadline and have no time to stop, change, re-write, and reconsider.

Analytical transformation reduces finance departments’ costs. e.g. robotics and automation, shared services, centers of excellence have already processes of many finance departments. But what about FP&A? In many cases, it still lives in the 20th century. It is a well-known fact that Excel continues to be the prevalent analytical tool used by finance professionals. The quality of data for FP&A analytics remains poor and the FP&A time wasted on the data reconciliations and cleansing. The financial analysis task thus takes on the form of “firefighting”, leaving no time to re-think and re-design the existing non-value adding processes.

Obviously, changes in the FP&A framework are driven by transformations of analytical procedures in general. For its 10th meeting, held in mid-March 2016, the London FP&A Board embarked on developing the FP&A Analytics Transformation Model.

The meeting was sponsored  by Metapraxis, the consultancy, analytics for financial professionals and software provider and, by Michael Page, the specialist recruitment firm, which now provides its offices as the venue for Board  meetings in central London and abroad.

20 senior finance practitioners from the UK, USA, Denmark, Switzerland, Ukraine, Germany, and Netherlands came together to brainstorm on the following questions:

  • What is advanced analytics for FP&A?
  • What are the stages of FP&A analytical transformation?
  • How should the FP&A Analytics Maturity Model look?

What is advanced analytics for FP&A?

There are a lot of professional debates about the role and purpose of finance analytics; the marketplace is flooded with alternative definitions of different analytics types. Many advanced analytics definitions come from the IT profession, however these need to be adjusted in order to better address the finance world.

The Gartner model, shown below, presents an overview of different kinds of analytics.

It was agreed at the London FP&A Board meeting that FP&A advanced analytics start from the Insight stage and utilise predictive and prescriptive types of analytics. In other words, FP&A advanced analytics is Proactive  and Forward-looking Analytics.

Traditional budgeting and planning analytical processes are still centered around Descriptive and Diagnostic Analytics: the most backward-looking and reactive processes. A good example is the traditional Variance Analysis.

 FP&A advanced analytics is based on a driver-based planning and forecasting process. It is important to identify a number of key business drivers: not more than 10 or 20. If effective, the process can describe 80% of the outcomes by only focusing on 20% of the total drivers. The simplification helps to  speed up the analytics based decision-making process and to increases its flexibility and agility.

How about the optimization stage of the analytics? Are FP&A departments ready for prescriptive analytics? The London FP&A Board agreed that the foresight stage of FP&A analytics is not generally present in the FP&A departments yet. Some of the board members think that it is not possible to automate complex and strategic analytical FP&A decisions: these complex analytical scenarios should be run by human beings, not machines.

However, there are some routine and repetitive  tasks that could be automated in order to release valuable time for the advanced  analytics.

FP&A Analytics Maturity Model

The FP&A Analytics Maturity Model, shown below, presents an overview of the three states and 5 stages of the organisational analytical transformation.

There are 3 states of FP&A Analytics Maturity: Basic, Intermediate and Leading. The stages of the maturity could be described as following:

  1. Basic
  2. Developing
  3. Defined
  4. Advanced
  5. Leading

Let us look at each stage in more details.

1. Basic Stage of Maturity

It is described by the following characteristics:

  • No formal analytical processes
  • No established analytical matrixes and business drivers. The financial model is in the basic or non-existent state
  • No BI tool and  dedicated planning system
  • No business collaboration

An example of organization at this stage would be a business startup, where the processes, models, systems and measures are not yet defined.

It can also happen within a mature organization, when it decides to spin off one of its operations.

2. Developing Stage of Maturity

Characterized by the following

  • Inconsistent planning and forecasting processes
  • Basic analytical matrixes and drivers.
  • Basic planning model and tools (most likely excel-based)
  • Basic BI tool
  • Minimal and inadequate planning collaboration
  • Analytics is mostly descriptive and backward-looking

 All organizations will pass this stage in the process of developing their FP&A framework. This is necessary step of development. The desired outcome is for an organisation to progress into the defined and advanced stages of the development process.

Sometimes, an organization can stack at this “developing” state. It happens for reasons of poor management, dysfunctional business culture and inadequate investment in analytics. Such a stall can prevent an organization from unlocking its full potential and competing in the modern world.

3. Defined Stage of Maturity

Currently, many global organisations  reside at the beginning of this stage. It is characterized by the following :

  • Defined Planning processes
  • Defined analytical matrixes and drivers
  • Defined planning model and system
  • Defined, but disconnected from planning BI-type solution
  • Some elements of collaborative planning is present
  • There is heavy reliance on IT support
  • The analytics types are descriptive (What?) and Diagnostic (Why?)

 This Intermediate state of analytical transformation is characterized by relative stability: companies are able to stay in this stage for many years. The processes are stable, but not “best in class”, they are adequate for the traditional budgeting, planning and forecasting process. However, they are arguably highly inadequate for “new world” planning.

 4. Advanced Stage of Maturity

Best in class modern planning processes reside at this space:

  • Enterprise-Wide planning processes
  • Multidimensional analytical matrixes, leading KPI’s and business drivers
  • Driver based planning process and flexible planning system
  • Advanced BI solution: it is partly connected with the planning process
  • Collaborative planning process
  • Self-service planning system and process, low reliance on IT
  • Predictive analytics (What will happen?)

 5. Leading Stage of Maturity

This is the ultimate goal for which organisations should aim.

  • Integrated Planning Process (IPP)
  • Leading Analytical matrixes and drivers.
  • Integrated driver based planning process (both horizontal and vertical)
  • Planning system is fully integrated with BI
  • Real-time collaborative planning process
  • Advanced (Proactive) analytics

Conclusions

Analytical transformation is an ongoing process. We will see more transformation in the future: system implementations, restructuring of processes, re-defining and simplifications of the models, automation of the routine tasks and applying proactive advanced analytics.

Currently, the majority of organizations are stuck at the defined stage with some turning to the advanced for the best in class companies. At the leading stage, all planning processes will be fully integrated, allowing for multidimensional advanced analytical process. This is where FP&A will be able to use big data analytics and fully transform organizational corporate performance management and decision making process.

The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

image

Event Calendar

Pagination

  • Previous
  • May 2025
  • Next
Su Mo Tu We Th Fr Sa
27
28
29
30
1
2
3
 
 
 
 
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Transforming FP&A Together: Human & AI Synergy
 
18
19
20
21
22
23
24
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
Five Critical Roles for Building a World-Class FP&A Team
 
25
26
27
28
29
30
31
FP&A Business Partnering and AI: A New Era
 
All events for the year

Future Meetings

The Face-to-Face Milan FP&A Board
The Face-to-Face Milan FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)

May 20, 2025

The Face-to-Face Frankfurt FP&A Board
The Face-to-Face Frankfurt FP&A Board Five Critical Roles for Building a World-Class FP&A Team

May 22, 2025

BPAI
The FP&A Trends Webinar FP&A Business Partnering and AI: A New Era

May 28, 2025

The Face-to-Face London FP&A Board: Data Management & Analytics: Unlocking FP&A Value
The Face-to-Face London FP&A Board Mastering Data in FP&A: Smarter Analytics, Better Decisions

June 5, 2025

FP&A Trends Webinar The Evolving Role of FP&A: From Number Cruncher to Strategic Advisor
The FP&A Trends Webinar Making FP&A Teams Fit for the Future

June 11, 2025

The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board From Insight to Impact: FP&A Business Partnering in Action

June 17, 2025

FP&A Trends Webinar Practical Steps for FP&A Analytical Transformation.
The FP&A Trends Webinar Unlocking FP&A Analytical Transformation

June 18, 2025

The FP&A Trends Webinar How AI is shaping the future of Financial Planning & Analysis (FP&A)
The FP&A Trends Webinar Transforming FP&A with AI: Maturity, Impact, and Future Roles

June 25, 2025

The Face-to-Face Sydney FP&A Board
The Face-to-Face Sydney FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

June 26, 2025

The Face-to-Face Singapore FP&A Board: Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
The Face-to-Face Singapore FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

July 8, 2025

AI/ML FP&A
AI/ML FP&A
Data and Analytics
Data & Analytics
FP&A Case Studies
FP&A Case Studies
FP&A Research
FP&A Research
General
General
Integrated FP&A
Integrated FP&A
People and Culture
People and Culture
Process
Process
Technology
Technology

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • FP&A Videos

Footer countries

  • Amsterdam
  • Austin
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Helsinki
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London (Circle)
  • Melbourne
  • Miami
  • Milan
  • Munich
  • New York
  • Paris
  • Perth
  • Riyadh
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2025 fpa-trends.com. All rights reserved.

0