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
    • Contributors
    • FP&A Trends Digest
    • FP&A Talks Series
    • FP&A Trends Research
  • FP&A Board
    • Amsterdam
    • Boston
    • Brisbane
    • Brussels
    • Chicago
    • Copenhagen
    • Dubai
    • Frankfurt
    • Geneva
    • Hong Kong
    • Houston
    • Kuala Lumpur
    • London Board
    • London Circle
    • Melbourne
    • New York
    • Paris
    • Perth
    • San Francisco
    • Seattle
    • Shanghai
    • Singapore
    • Stockholm
    • Sydney
    • Tokyo
    • Toronto
    • Washington D.C.
    • Zurich
  • AI/ML Committee
    • Introduction
    • Meetings
    • Members
    • Resources
  • Video Content
    • Digital FP&A Boards
    • FP&A Webinars
    • Short Videos
  • Contact Us
  • About Us
    • Ambassadors
    • Privacy Policy
    • Company Policy
    • Editorial Guidelines
    • Our Sponsors & Partners
The four plays Supply Chain leaders need to know

The four plays Supply Chain leaders need to know

Click here to view details and register

 

Components of an Intelligent FP&A Solution
New
December 9, 2021

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

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, 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, 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

The Latest Trends and Developments in Financial Planning & Analysis: 2022 Global Survey Results

The Latest Trends and Developments in Financial Planning & Analysis: 2022 Global Survey Results

Click here to view details and register

Pagination

  • ‹‹ Previous
  • July 2022
  • Next ››
Su Mo Tu We Th Fr Sa
26
27
28
29
30
1
2
 
 
 
 
 
3
4
5
6
7
8
9
10
11
12
13
14
15
16
The Latest Trends and Developments in Financial Planning & Analysis: 2022 Global Survey Results
 
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
 
 
 
 
 
 
All events for the year

Future Meetings

The Latest Trends and Developments in Financial Planning & Analysis: 2021 Global Survey Results
The FP&A Trends Webinar The Latest Trends and Developments in Financial Planning & Analysis: 2022 Global Survey Results
July 12, 2022
The FP&A Trends Webinar
The FP&A Trends Webinar FP&A Board Maturity Model: Achieving Intelligent Transformation
September 15, 2022
scenario management
The FP&A Trends Webinar Navigating Uncertainty with FP&A Scenario Management
September 21, 2022
Agile FP&AAI/ML FP&ABeyond BudgetingBusiness Intelligence (BI)Capital PlanningCash PlanningCollaborative FP&ACorporate Performance Management (CPM)Cost PlanningData-Driven FP&AData VisualisationDigital FP&ADriver Based PlanningExtended Planning & Analysis (xP&A)Financial Planning and AnalysisForecasting QualityFP&A AnalyticsFP&A Business EnvironmentFP&A Business PartneringFP&A Case StudiesFP&A DashboardsFP&A KPIFP&A Maturity ModelsFP&A PeopleFP&A Predictive AnalyticsFP&A RPAFP&A Scenario PlanningFP&A SkillsFP&A StorytellingFP&A Strategic PlanningFP&A Team BuildingFP&A TechnologyFP&A TransformationFP&A Trends ResearchIntegrated FP&AModelling and ForecastingPlanning and BudgetingProfitability AnalysisRisk-Adjusted PlanningRolling ForecastWhat is FP&AZero-Based Budgeting (ZBB)

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
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London(Circle)
  • Melbourne
  • New-York
  • Paris
  • Perth
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

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

0