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
How Can You Upskill in Data Analytics to Transform Your FP&A Department?
December 21, 2021

By Christian Martinez, Finance Transformation Senior Manager at Kraft Heinz

FP&A Tags
FP&A Analytics
FP&A Transformation
Financial Planning and Analysis

FP&A works on a jigsaw puzzle of major core financial statements and structure systems of the company. They need to be able to look around five years back and five years forward to identify abnormalities and trends, do balance sheet analytics, and conduct a cost analysis to answer complex questions around how and where the company is making a profit, how the firm behaves, who should be hired and where they should be placed as related to cost profiles, etc.

Of course, legacy FP&A Departments have multiple Excel files in place to do all of this and this has worked for many years, but there are some major flows like the fact that data analysis is limited to 10 million rows of data or that some files live only in one computer.

FP&A must drive profitable business decisions. As companies increase investments in advanced analytics, CFOs and their FP&A leaders are well-positioned to provide precise forecasts and actionable insights to support quick and accurate decision making.

However, dispersed organisational data and outdated, non-standardised reporting processes mean financial planning and analysis teams often fail to provide clear, decision-ready insights that businesses need to drive growth. Additionally, analysis by Gartner shows only 3% of companies have strategic, operational and financial planning processes that are fully aligned and integrated.

So how to be more strategic and integrated? There are three tools that can transform your FP&A Department and we will talk about them below:

  1. Python

  2. SQL

  3. Tableau

1. Python

Python is the fastest-growing programming language in Finance and it can be used for many tasks in finance like data analysis and visualisation, Machine Learning and automation!

Python is a high-level programming language. This means that is closer to human language as opposed to machine language. Programming languages like C++ or Java which were taught years ago in finance universities are on the other side of the spectrum. They are closer to binary code of 0s and 1s than English.

This is one of the reasons that Python is so simple and easy to learn. For example, if you want to print the words “hello world” using Python the code is just: print(“hello world”). In Java, things get super complicated very quickly as you can see in the image below.

Python is simple and easy to learn, yet Python is also powerful and has a large ecosystem. There is multiple ways you can learn Python, from YouTube videos, books, online forums, workshops, online courses, at university, from peers or even Apps! But in this article, we are going to talk about my journey in learning Python.

Some great Libraries:

  • NumPy (quick, vectorised array operations)

  • SciPy (scientific classes & functions)

  • Pandas (times series and tabular data analysis)

  • Scikit-learn (Machine Learning algorithms)

  • DX Analytics (Multi-risk derivatives and portfolios)

  • Pyfolio (portfolio management, performance analysis)

If you want to learn more about #Python I recommend: From Finance and Accounting to Data Science: Learn Python Programming

fp&a

Figure 1

2. SQL

Structured Query Language or “SQL” for short is a programming language used to query and manipulate data stored in relational databases. The language is becoming increasingly popular in Finance and Accounting as we find more and more ways to use data.

SQL is not longer an “IT skill” or something that “tech people” know what to do. SQL is really accessible and easy to use so people in finance and accounting can now retrieve their own data by learning a little bit of SQL.

By adding more technical skills to your finance and accounting knowledge, you can be more independent from the IT department. It’s all about self-serviced analytics which is a form of business intelligence (BI) in which line-of-business professionals are enabled and encouraged to perform queries and generate reports on their own, with nominal IT support.

By learning technical skills such as SQL, now you can more easily communicate your problems to other departments such as IT when you do need help. Having both business and technical knowledge can be very valuable to the company you work for (or to clients if you have your own business).

3. Tableau

As Forbes mentioned in 2016, Data Storytelling is the Essential Data Skill Everyone Needs!

Once your business has started collecting and combining all kinds of data, the next elusive step is to extract value from it. Your data may hold tremendous amounts of potential value, but not an ounce of value can be created unless insights are uncovered and translated into actions or business outcomes.

Tableau is a visual analytics platform that empowers people and companies to take data, to be able to understand it, to process it, to extract value from it, to visualise it, to communicate their insights to others effectively; essentially, telling the story of the numbers.

 

 
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
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
Using Analytics to Enhance Decision Making
April 30, 2019

The crux of the analytics movement is making better decisions and more organizations are moving towards...

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
+

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