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
FP&A Data Management Under the Lens
April 15, 2025

By Dr Irina Steenbeek, Founder of Data Crossroads

FP&A Tags
Data-Driven FP&A
FP&A Scenario Planning

Does data management for FP&A differ from data management for other business functions? Or does data management equally serve the needs of every business function within a company?

Data management is a business capability that safeguards data assets in order to get value from them. FP&A professionals are some of an organisation’s most important data and information users. The most challenging and essential they perform is performing scenario planning and analysis. It assists in analysing the influence of various internal and external factors or drivers on a company’s financial statements and key performance indicators (KPIs). The scenario planning outcomes then help managers of multiple business units and various organisational levels make business decisions. The quality of these decisions depends on the quality of the delivered information. Scenario planning and analysis is one of the results of the “data-driven company” concept. Is this business concept easy to implement? No, it is not. The cliché “becoming data-driven” has been flying around for many years. However, its realisation requires a lot of effort and resources.

In this article, we will:

  • Demonstrate the dependencies between the requirements of scenario planning and analysis and data management tasks.
  • Describe the role of FP&A professionals in performing data management tasks related to scenario planning.

 

Data Requirements for Scenario Planning & Analysis

Scenario planning and analysis, in its fullest sense, requires knowledge of the following:

  • Decisions are to be made by managers of various business lines and at different organisational levels using integrated financial statements and KPIs.
  • Relationships between external and internal factors and financial statements and KPIs.

Let’s consider these requirements in detail.

Every organisation has common business capabilities and corresponding business units. Figure 1 demonstrates the well-known business value chain concept.

Figure 1: Business and data value chains

 

The organisation creates business value by implementing a business value chain. Suppliers deliver the input required for creating value. The business produces products and services that represent the value proposition to the company’s customers. Data chains support business value chains by transforming raw data into meaningful information.

Along the business value and data chains, a company bears investments, costs, and expenses and receives revenue and gains. Integrated financial statements and key performance indicators assist in decision-making across all business capabilities and at different organisational levels: strategic, tactical and operational.

Scenario planning and analysis intends to discover the dependencies between internal and external factors and, based on them, to predict various business outcomes using financial statements at different organisational levels.

Scenario planning and analysis demand a lot of various data from internal and external sources.

 

Data Management Viewpoint on Scenario Planning & Analysis

From a data management viewpoint, external and internal factors and financial statements are sets of data elements that reside in various IT assets like applications, databases, integration tools, and so on. Data chains are sets of IT assets that gather, transform and deliver data. Figure 2 demonstrates a simplified example of calculating one strategic KPI, “Net profit,” along one data chain. In reality, a company may use multiple data chains and dozens and hundreds of IT assets to deliver financial statements and KPIs.

Figure 2: A simplified example of calculating a KPI along a data chain

 

To deliver multiple integrated data sets and discover and demonstrate the links between data elements, a company must have a very advanced level of IT technology and data management. The larger the company, the more technically complex this task is. Various vendors offer advanced solutions to implement Extended Planning and Analysis (xP&A) and scenario planning and analysis as a part of it.  

Data management can assist in several ways to build complex solutions to implement complex scenario planning and analysis solutions.

 

Data Management Support for Implementing a Scenario Planning and Analysis Eco-System

Data management must deliver all information required for scenario planning. Data chains perform multiple processes, as shown in Figure 3. We call these processes a “data lifecycle.” Designing and implementing a data lifecycle in multiple data chains is the key task of data management

Figure 3: The key processes of a data lifecycle

 

1. Gathering information and data requirements

Scenario planning requires data from various sources. Adding new data sources and adjusting data chains to consume new data is time and resource-consuming. FP&A professionals very often play the role of data users. Therefore, they must provide their information requirements. For example, for scenario planning, FP&A professionals must indicate the complete list of KPIs for various business units that are to be included in scenario planning. They can also indicate business drivers to be taken into account. Data management professionals must translate information requirements into data requirements. It means that they must find the applications in which this information and data resign.

2. Modelling and describing data

To implement data requirements, the data must be described using data models. To integrate data from multiple sources, a common data model for scenario planning must be built. This means that sourcing data must include data related to the identified business drivers that influence financial statements.

Data modeling is one of the data management capabilities. However, business professionals like FP&A must assist in developing these models by providing business definitions and data and explaining the relationships between different terms.

3. Data sourcing

Required data is not always available within the company. For example, FP&A professionals may need information from external agencies like Dun & Bradstreet. They must provide their requirements regarding the potential data source, content, historical periods and delivery conditions.

4. Data transformation

Data undergoes transformations on its way from a source to the scenario planning solution, including mapping, integration, calculation, aggregation, etc. As Figure 2 shows, to derive the value of the “Net Revenue” element, data about customer information, orders, invoices and others must be integrated. FP&A professionals must provide business rules to be applied to data integration.

5. Data validation

Data must meet the quality requirements to make the scenario planning results trustworthy. Only complete or correct data will lead to accurate models and the right business decisions. FP&A professionals must first provide their requirements for the quality of delivered data. In the case discussed above, FP&A professionals must define their requirements for the quality of the “Net Revenue” information element. For example, what are the expected delivery terms, the range of its allowed consistent with the previous period values, and so on? They also must participate in data validation to prove the correspondence of delivered data to the original requirements.

6. Data delivery

For scenario planning purposes, data must be delivered in near or real-time. Enabling data delivery in near or real-time could require severe changes in IT technology. FP&A professionals must be realistic in their requirements and define critical data for optimising data delivery.

7. Data analysis

Complex scenario planning solutions demand comprehensive data analytics, including various data science technologies. FP&A professionals must learn to collaborate with data science professionals in order to understand the data patrons and translate them into recommendations for decision-making.

The above-discussed tasks are just examples of the complex data management capabilities that require the participation of various business professionals, including FP&A.

 

Conclusion

In order to successfully implement scenario planning and analysis in the company’s practices, FP&A executives must do the following:

  1. Sponsor a data management-related initiative to set up a formal data management function.
  2. Clearly articulate their data-related requirements from a data user perspective.
  3. Motivate and train internal FP&A staff to understand and perform all data management-related tasks assigned to business subject matter experts.

 

This article was first published on the SAP Blog.

Discover expert insights on data strategy, governance, and implementation at Data Crossroads and Data Crossroads
Academy.

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

Related articles

Irina-Steenbeek-Data-Strategy
Why Does Your FP&A Team Need a Data Strategy?
March 25, 2025

A strong data strategy is crucial for FP&A teams to ensure accurate, timely and meaningful insights...

Read more
Harsh-Amarasuriya-Data-Driven-FPA-Main
Data Provides the ‘Eyes’ into the Organisation
January 21, 2025

The article explores how data-driven FP&A transforms organisations by integrating financial and non-financial metrics to drive...

Read more
Benn-Wann-Integrated-FPA-Data-Management
Integrated FP&A: Why Data Management Is Important
March 11, 2025

Integrated FP&A thrives on effective data management — ensuring accuracy, consistency and automation to drive better...

Read more
Milind-Karnik-Practical-Guide-to-Scenario-Planning
A Practical Guide to Scenario Planning: The ‘When’, the ‘Why’ and the ‘How’
February 18, 2025

A practical guide to Scenario Planning — understanding the ‘when’, ‘why’ and ‘how’ to make strategic...

Read more
Mastering Data in FP&A: How to Build Analytical Capabilities for Strategic Growth and Informed Decisions
FP&A Trends Insights Paper 2024. Mastering Data in FP&A: How to Build Analytical Capabilities for Strategic Growth and Informed Decisions
October 18, 2024

Many organisations still struggle with data quality and timeliness, with 35% citing these issues as the...

Read more
Scenario Planning and Modern FP&A
March 4, 2019

Following on from the success of the 21st London FP&A Board, we had the pleasure...

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