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
Components of an Intelligent FP&A Solution
December 9, 2021

By Michael Coveney, Head of Research at FP&A Trends Group

FP&A Tags
FP&A Analytics
FP&A Technology

partnering“IFP&A encompasses a dynamic, continuous approach to analytics that greatly increases the ‘Intelligence’ of an organisation and its ability to change fast.”  

Traditional FP&A systems are typically focused on one aspect of the management process.  For example, setting a budget, collecting a forecast, or delivering results in the form of a report pack.  Over the past 20 years, there have been concerted efforts to combine these processes into a single system – after all, what’s the point of a budget if you can’t report against it or collect a forecast to see if year-end goals are going to be achieved?   The trouble is that these systems often have a single view of the business, which is typically financially orientated and structured according to the organisational hierarchy.  While this does have some value, it typically does not include the ‘real-world’ view, which is far more complex. 

To get around this, ‘satellite’ systems are developed for analyses such as sales, market share and even the impact on social media.  These results are then bought together in the form or yet another system, such as a dashboard that is tentatively linked to the organisation’s adopted strategy methodology.  (Whatever happened to the Balanced Scorecard, Hoshin Planning, ...?).  If all else fails, then there is Excel which gives end-users free range for producing their own analyses but at a price that usually forsakes data integrity. 

For the record, this is not an integrated solution and one that IFP&A seeks to distance itself from. 

IFP&A System Components 

The following components are essential in any modern IFP&A system: 

1. Common platform:   IFP&A solutions recognise that there is no single ‘off the shelf' application.  Instead, they encompass a mixture of technologies that are built on a common platform that enables the sharing of data and metadata.   This is a key point. 

2. Model Builder: ‘Models’ are typically a collection of mathematically based variables/structures that reflect the way an organisation operates.  They can include ‘adding up’ models that you typically find in a budget solution, or ‘driver-based’ where entering a number into a variable (e.g. sales volume) then generates a range of associated variables (e.g. Revenue, Cost of Sales, Delivery, etc.) by the application of pre-set formulae.   To represent the complete organisation, multiple models will be required that will typically include: 

  • Past sales by product, customer, region, size, etc. 

  • Financial resource allocation and funding  

  • Long-range plan and associated targets 

  • Detailed Forecasts 

  • Strategic initiatives and projects  

These models are designed to answer specific questions and will have different content structures and are used by different people at different times.  They can include both structured and unstructured data, including text. 
 
3. Common Data and Metadata:  An IFP&A system will allow these models to be built from common metadata (e.g. business structures, variable definitions) and allow common data to be entered once and automatically shared between models.  Any changes to items that are common are automatically reflected wherever they are used. 

4. Data Acquisition tools.  All data within an IFP&A system is common, but these tools allow external data and metadata to be accessed, summarised and transformed into the established models.    

5. Data Analysis & Optimisation Tools:  These are tools that can be applied to any model/data set to find trends and correlations, and that can be used to generate data using these methods but without having to embed rules within the models. 

6. Collaboration and Workflow:  These capabilities control users as to what they need to do and by when.  It will typically include the ability to ask questions and make comments and automation facilities that can trigger activities based on events and exceptions. 

7. Reporting:  The ability to ‘grab’ data from any model and any time period and display it in any format, whether that be a traditional report, dashboard or email alert.  

8. End-user Analysis:  Users tools that allow unfettered access for analysis providing they have the right security clearance.  These analyses can be saved, shared and accessed by a variety of hardware devices. 

9. Cloud-enabled.  Today, more and more systems are cloud-based – this means that users can access them from any location and any device, security permitting.  This frees users from having to be at a certain location or ‘own’ specific devices. 

In many ways, there is nothing new in these capabilities individually, but what makes IFP&A different is that they are all tightly integrated without users having to know and learn different technologies. 
  
Together, these components greatly speed up the collection and analysis of data and pave the way to continuous planning driven by exceptions and alerts.  

 

The article was first published in the D!gitalist Magazine

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

Related articles

fp&a
In Search Of “Intelligent Drivers” In FP&A
October 14, 2021

It is unrealistic to link every activity. In some cases, you may only be able to...

Read more
fp&a
Emerging Technologies For Intelligent FP&A Solutions
October 1, 2021

There are many terms connected with FP&A, such as “unstructured analysis,” “predictive analytics,” and “machine learning". Often...

Read more
fp&a
Understanding “Intelligent FP&A”: A Dynamic New Approach For Finance
August 31, 2021

The volume of data is so large and complex that forecasts are often unpredictable: the world...

Read more
Data Analytics – an Opportunity or a Threat for FP&A?
April 2, 2020

The explosion in computing and data processing power has led to an exponential increase in data...

Read more
+

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 Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Transforming FP&A Together: Human & AI Synergy

May 15, 2025

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

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