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
2022 global CPM trend report

2022 global CPM trend report

Click here to view details and register

 

The Role of Technical Skills in FP&A
New
May 5, 2022

By Mohammed Hussain, Finance Analyst at Amazon

FP&A Tags
FP&A Skills
FP&A Technology

The top 7 trends shaping FP&A today can be grouped into 3 key building blocks: Process, Technology, and People.

The building blocks are a 3-part recipe to create the perfect cake. Each part will help to curate a strong finance professional and a successful cross-functional FP&A team.

All 3 blocks are vital to run a successful FP&A operation – a consensus the entire group aligns with. There are times when one block takes precedence over the others. In this article, we explore the trends within each building block, and how they all interact, as discussed in a recent FP&A Trends Webinar.

The event panel consisted of: Larysa Melnychuk – Founder and CEO of FP&A Trends Group & International FP&A Board. Michael Weiss – VP Global Head of Business Value and Strategy at Anaplan. Michael Coveney – Analytics Thought Leader, Author and Head of Research at FP&A Trends Group. 

The Building Block Trends

The 3 building blocks to a strong FP&A organisation are Process, Technology, and People. These 3 blocks consist of 7 "top trends". 

fp&a

Figure 1

Process

In a poll, 75% of voters agreed that the entire process of managing alternate scenarios is too long. Only 18% of voters can run simulations in a day or less. The consensus is that even "a day or less" is too long for scenario management. Where has this increased demand for instant answers come from? 

How can leaders achieve “real-time” scenario management? Through clear harmonisation of the strategic plan, financial plan, and operational plan. Harmonisation is best achieved in lean and matrix-style org structures. These structures create less room for bureaucracy to delay key decision-making. This paves the way to harness “real-time” scenario management.

If companies focus efforts on developing a strong workforce then this will help to curate well-defined processes. Hire well, and trust your people to execute. A “real-time” planning process benefits from this type of trust.

Technology

Data. Big data. “So much data” as Michael Covey, Analytics Thought Leader, Author and Head of Research at FP&A Trends Group, puts it. It is difficult to achieve a “real-time” planning process without quality data. Once we have quality data, we must invest in quality infrastructure to store and access it. Companies often use technologies provided by Amazon Web Services (AWS) to achieve this at scale, for example.

The above is the ideal situation. the reality involves messy data. This messy data goes into good tools and produces bad outputs. Who end up being at fault? the tools. 

What do we do with “The Messy Middle” as Michael calls it? How can FP&A teams create better forecasts if the data is garbage? 

Machine Learning (ML) models can often produce higher forecast accuracy than traditional modelling, saving teams time and resources. 

Michael describes ML as “a branch of AI that uses algorithms to build predictive functions that learn from the data being analysed”. There are 2 methods of ML: supervised learning and unsupervised learning.

fp&a

Figure 2

Supervised Learning: Provide a model with sample data about flower species and their respective characteristics. The model can take this data to predict the species of a flower from a different, "unseen" dataset. it makes this prediction by "learning" how comparable the new flower is to its sample data.

Unsupervised Learning: The ML model will create its own output not based on any given prediction. We can illustrate this using 2 AI “Boxers”. Provide the boxers some details of what it means to be a “boxer”. The boxer will then identify patterns over millions of “generations” before finally learning how to fight. Imagine how a toddler first learns to crawl and then walk.

In both cases, the models require inputs. Imagine the inputs as “drivers”, and customer profitability as the output we want to find. First, identify the key drivers of profitability to generate a solid driver-based planning model. Second, execute a proof-of-concept in Excel. Third, invest in ML technology to generate predictions. 

ML is exciting but does this mean Excel is dead? – No. Technology is just an enabler. No one technology has all the answers. Invest in understanding the problem and deploying the right technology to solve it. 

Let's illustrate a simple example of deploying technology based on the problem

1. Excel - Use historical data to identify a few drivers. Run basic correlation plots to rank them in order of strength

2. Python/R - Import datasets and use ML algorithms to produce a sales forecast prediction. This can be for n-years into the future

3. Either:

  • Excel - Import predictions into Excel and produce data tables to present to leadership
  • Python/R/PowerBI - Use data visualisation libraries to create data tables, and plot visuals that tell the story

Note: We can execute this same example all within PowerBI or R or Python too.

People

Tools include VBA, Python, R, PowerBI, MySQL, etc. Learn as many as you want. It will always still boil down to this basic question:

Are you able to use these tools to communicate key messages to stakeholders?  

This introduces large-scale competition for talent. Strong finance skills are not “enough” anymore. A well-rounded finance professional must be able to analyse complex and unstructured data. The professional must also understand how to leverage and communicate to leadership. The message is that, strong hard skills are meaningful only with the ability to engage leadership in strategic decision-making

fp&a

Figure 3

Conclusion

The webinar concluded with a polling question:

“How can FP&A organisations work toward achieving advanced skills maturity? How should they structure their teams?”

Take 1 hour with your team to discuss what “advanced skills” means to you and them. Then work backwards to what “basic skills” are pre-requisite to this. 

Before getting your hands dirty in new and exciting ways of analysing data, assess if the basics are secure. One way to classify "basics" is as follows:

  • Process - The ability for a team to manage "real-time" change in forecast scenarios
  • Technology - Excel and power query
  • People - Can your empower your leaders to make data-driven decisions?

 

We would like to thank our global sponsor Anaplan for their great support with this FP&A Trends Webinar. 

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

Related articles

2030
What Skills Should FP&A Develop by 2030
March 5, 2022

FP&A is getting more and more relevant in the organisations as a key role to support...

Read more
FP&A Teams and Skills Required in Uncertain Environments
FP&A Teams and Skills Required in Uncertain Environments
March 4, 2022

In a world in which increasingly little can ever be taken for granted, the core capabilities...

Read more
Digital Transformation
Digital Transformation Journey Guide
December 1, 2021

Being adaptive to changes in the surrounding world and changing yourself is the only way to...

Read more
How can FP&A professionals get ready for the transition?
How can FP&A professionals get ready for the transition?
November 5, 2021

With the pace of change currently relentless, it isn’t always easy to keep up.

So in...

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

Maximizing FP&A Value Through Automation

The FP&A Trends Webinar: Maximizing FP&A Value Through Automation

Click here to view details and register

Pagination

  • ‹‹ Previous
  • May 2022
  • Next ››
Su Mo Tu We Th Fr Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Reinventing FP&A: Key Lessons Learned from the Pandemic
 
Cash Flow Planning - Why the Traditional Profit-Driven Mindset Needs to Be Rethought
 
Reinventing FP&A: Key Lessons Learned from the Pandemic
 
From Traditional to Better and Beyond Budgeting
 
15
16
17
18
19
20
21
Digital FP&A in Practice: Dorrington Plc Case Study
 
22
23
24
25
26
27
28
Top Five FP&A Challenges and How to Address Them
 
Reinventing FP&A: Key Lessons Learned from the Pandemic
 
Maximising Value Creation with FP&A Business Partnering
 
Reinventing FP&A: Key Lessons Learned from the Pandemic
 
29
30
31
1
2
3
4
 
 
 
 
All events for the year

Future Meetings

houston
The Face-to-Face Houston FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 2, 2022
Maximising Value Creation with FP&A Business Partnering
The Digital Middle Eastern FP&A Circle Maximising Value Creation with FP&A Business Partnering
June 6, 2022
chicago-june
The Face-to-Face Chicago FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 7, 2022
Frankfurt
The Face-to-Face Frankfurt FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 9, 2022
Toronto
The Face-to-Face Toronto FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 9, 2022
dc
The Face-to-Face Washington D.C. FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 14, 2022
New York
The Face-to-Face New York FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 15, 2022
Reinventing FP&A: Key Lessons Learned from the Pandemic
The Face-to-Face Boston FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 21, 2022
The FP&A Trends Webinar
The FP&A Trends Webinar Maximizing FP&A Value Through Automation
June 22, 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