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 Week: Breaking the Paradox

October 10-13, 2023

Register now

 

 

 

Global Dashboard that Meets Local Needs
August 2, 2022

By Petr Galik, Head of Data, Reporting & Analytics at Takeda Business Solutions

FP&A Tags
FP&A Dashboards
Data Visualisation

Data is becoming a key asset of today’s world. Most valuable companies claim to be data-driven, decisions are data-based, and our business strategy needs a corresponding data strategy to enable success.

What is meant by data in this context is, however, not the raw material but rather the information or insights that can be derived from them. Unlike oil, where the transformation from the raw material to the final product is straightforward and relatively standardised, data as a raw material can be transformed into an extremely useful or completely useless product.

Don’t worry. The following text will not discuss sky castles full of Artificial Intelligence, Machine Learning, or data science.

 

FP&A Reporting in a global company

Let’s solve once and for all the question of how to design management finance reporting for a global company that operates in many local markets and wants to automate the revenue, P&L, expenses and other key management reports.

We want to deliver one version of the truth reports that are shared across the world and free up time spent in local business organisations for business partnering and more valuable activities. At the same time, we need this automated reporting to be relevant for all the countries, regions and functions. Only then will local teams not be required to produce reports themselves, and full benefit will be achieved.

The vision is simple, and it is surprising how many organisations still struggle to achieve it. Why is that? Let’s illustrate the challenge with a few classic examples:

  • One country has 80% of its business in areas outside of the global growth focus, making them reported as “other” from a corporate perspective;
  • Another country decided to structure business units in a different way which better fits them but is again not compatible with the corporate view;
  • Although corporations typically operate in around 100 markets, it often is just a few that executives are interested to understand in detail;
  • Yet even a tiny market has its specifics and needs accountability and budgets assigned to be efficient, as well as to ensure proper governance and controlling.

 

Both Global and Local FP&A teams have a role to play

So, on one side, we have a desire in a global board room to see every country in the same way, digital tools that ask for harmonisation and on the other side, local business units that need their local operating model reflected for the reporting to make it useful for them.

As in life, there is no one size fits all. Everybody is different, and it is only when we embrace diversity that we as a society (and a company) thrive. Pushing a country to comment on their revenue performance based on a report that consistently presents 80% of their portfolio as “other” does not make sense. It also makes little sense to ask a global executive to dwell on specifics of a country that accounts for less than a rounding error.

The key to solving this puzzle is to understand which capabilities are best managed centrally and which should stay in the hands of local teams.

Master data management, core data model management, and data quality management are capabilities that all lead to one version of the truth data sets. Using the analogy of raw materials from the beginning, this is the oil refinery that is always needed in the process. Interestingly also the data visualisation can be efficiently delivered centrally, similarly to consumer product branding.

It does not make sense to have every finance team developing management reporting end-to-end, where local finance teams add value is mastering local business specifics and delivering insights to support business objectives.

 

Capability-based definition of roles and responsibilities

This suggested the split of responsibilities ensures focus on everyone’s strengths:

Figure 1

From an architecture perspective, we must clearly draw the line between core transformation (e.g. accountability unit = business unit/function, management accounting and other standards, exchange rates, planning scenarios) and customisable transformation (product structures, department structures below accountability unit level, etc.).

This will allow meaningful customisation and enable powerful reporting visualisation, whether delivered centrally or locally via self-service dashboarding tools.

 

Summary

From an investment perspective, I suggest focusing on a rock-solid data foundation with an efficient data model. This is not easy, neither cheap nor fast. But if done well, we can finally turn the page on F&A management reporting and fully focus on the new chapter of data science and Artificial Intelligence, which by the way, both need this data foundation as a necessary enabler.
 

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

Related articles

Notation Rules for Effective Dashboard Implementation. CFOs Don't Like it Colorful
Notation Rules for Effective Dashboard Implementation. CFOs Don't Like it Colorful
June 1, 2022

Dashboards can be an incredibly useful tool for organisations, but only if they are presented effectively...

Read more
fp&a
Express Course of FP&A Data Storytelling
November 25, 2021

Data Storytelling is a discipline at the intersection of data analytics, psychology, and design. It allows...

Read more
fp&a
Why Dashboards are a Powerful Tool in FP&A
July 8, 2021

The KPIs you choose to measure the performance of your business, the KPIs you use in...

Read more
The Top Three Recommendations for Mastering FP&A Dashboards
May 29, 2018

Dashboards have become a powerful tool for FP&A to share insight and gain respect.  In this...

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

The FP&A Trends Webinar: Navigating Intelligent Transformation with FP&A Trends Maturity Model

Click here to view details and register

 

 

 

 

Pagination

  • ‹‹ Previous
  • September 2023
  • Next ››
Su Mo Tu We Th Fr Sa
27
28
29
30
31
1
2
 
 
 
 
 
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
24
25
26
27
28
29
30
Creating Your Transformation Map with the FP&A Trends Maturity Model
 
Using AI to Enhance Your Predictive Planning and Forecasting
 
All events for the year
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

Future Meetings

The Face-to-Face London FP&A Board
The Face-to-Face London FP&A Board Creating Your Transformation Map with the FP&A Trends Maturity Model
September 27, 2023
The FP&A Trends Webinar
The FP&A Trends Webinar Using AI to Enhance Your Predictive Planning and Forecasting
September 28, 2023
The Power of AI and Human Intelligence in FP&A
The FP&A Trends Webinar Empowered Decision-making: Human-Led, AI-Backed Intelligence in FP&A
October 4, 2023
The Face-to-Face Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Five Critical Roles for Building a World-Class FP&A Team
October 5, 2023
ZBB
The FP&A Trends Webinar A New Age of Zero-Based Budgeting
October 10, 2023
The FP&A Trends Webinar
The FP&A Trends Webinar Navigating Intelligent Transformation with FP&A Trends Maturity Model
October 11, 2023
The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board FP&A Storytelling in a Data-Driven World
October 12, 2023
The Face-to-Face Toronto FP&A Board
The Face-to-Face Toronto FP&A Board FP&A Storytelling in a Data-Driven World
October 17, 2023
Value Adding FP&A
The FP&A Trends Webinar Mastering the Art and Science of Value Adding FP&A
October 18, 2023
FP&A Storytelling in a Data-Driven World
The Face-to-Face San Francisco FP&A Board FP&A Storytelling in a Data-Driven World
October 19, 2023
The Face-to-Face Seattle FP&A Board: FP&A Storytelling in a Data-Driven World
The Face-to-Face Seattle FP&A Board FP&A Storytelling in a Data-Driven World
October 24, 2023
The Face-to-Face Boston FP&A Board
The Face-to-Face Boston FP&A Board Creating Your Transformation Map with the FP&A Board Maturity Model
October 26, 2023
Geneva FP&A Board
The Face-to-Face Geneva FP&A Board FP&A Storytelling in a Data-Driven World
November 7, 2023
Continuous Planning
The FP&A Trends Webinar Real-Time and Continuous Planning: What Does It Involve
November 8, 2023
Zurich FP&A Board
The Face-to-Face Zurich FP&A Board FP&A Storytelling in a Data-Driven World
November 9, 2023
The Face-to-Face Munich FP&A Board
The Face-to-Face Munich FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
November 14, 2023
Helsinki
The Launch of the Face-to-Face Helsinki FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
November 16, 2023
From Insights to Impact: Unveiling the Potential of FP&A Scenario Management
The FP&A Trends Webinar From Insights to Impact: Unveiling the Potential of FP&A Scenario Management
November 22, 2023
The Launch of the Face-to-Face Riyadh FP&A Board
The Launch of the Face-to-Face Riyadh FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
November 27, 2023

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
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London(Circle)
  • Melbourne
  • Miami
  • Munich
  • New-York
  • Paris
  • Perth
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

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

0