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
London FP&A Board: Moving FP&A toward Advanced Analytics
December 11, 2014
FP&A Tags
FP&A Analytics

Published first on http://www.gtnews.com and  http://www.afponline.org in February 2015

Nearly every financial planning and analysis professional understands the need to embrace big data and analytics. But how can firms move beyond basics to advanced analytics?

That challenge was on every attendee’s mind at the recent FP&A Board meeting in London. There, FP&A and business intelligence professionals gathered to discuss the state of business intelligence (BI) and FP&A analytics with Nigel Geary, BI specialist at power utility British Gas.

Key takeaways from the meeting:

  • Cloud providers and Microsoft Power Pivot provide FP&A professionals more advanced capabilities to analyse data. It is important that the FP&A function trains itself to use these tools so that they can be self-sufficient and own the function and the models.
  • To be more effective, FP&A professionals need greater insight and more flexible data and models. While there’s plenty of data these days, it is often difficult to process. New computer languages like Hadoop are emerging to make handling large data sets faster and more efficient.
  • Analytics, and the technology that supports it, typically is still driven by IT and not finance, which creates a knowledge gap.
  • There is a new era coming where users need to take back that capability in order to track, analyse and predict business performance.

“I want to understand what’s considered advanced analytics and what’s considered basic,” one attendee said. “I’m trying to understand what good organizations are doing with regard to applying best practices. To me, it feels that it’s in its infancy.”

Geary concurred. “What I see is very basic. Nobody has even thought about predictive forecasting,” he said. “That’s what the trend tells us – how a new product will affect sales and [research and development]; the next step is to take this together.”

For many companies, the first step into advanced analytics is constructing multidimensional decision support tools, commonly called “cubes”. In the past these had to be created on mainframe computers; now they can be created in the cloud, making them more affordable.

“[Cubes] allowed FP&A to build budgeting systems in their departments,” Geary said. “They also minimised the amount of IT support needed to run the models.”

Next Analytic Step: the Hypercube

The next step in analytics, according to Geary, is the hypercube. Usually with budgeting, he said, FP&A pulls down  data from the general ledger and creates with multidimensional data sets each month, refreshing the information and performing variance analysis.

The hypercube breaks down this process to show users the profitability of different activities within the business. It ties all the ledgers together to calculate profitability by day, department and other factors to provide drill-down capability by numbers and transactions, and makes it possible to see any errors.

“You can’t do that if you have sales data in one cube and cost data in another cube,” Geary said. “The idea is to roll all of that up into a single cube bring it all into one place.”

To deal with the tidal wave of Big Data, data scientists have come up with a new data storage and language called Hadoop. Using Hadoop, companies can pull data out of new multidimensional databases that are not structured in the old columns and rows, providing greater flexibility.

The Practical Impact

Intriguing as the new advanced analytics solutions may be, attendees noted that they often don’t have time to implement them. “In FP&A we talk about trends,” one participant said. “We discuss scenario planning – what would be our response in various cases. That’s a form of analytics.”

How advanced companies can be in implementing these emerging tools really depends on their current state of technological advancement. “If the planning is not great, they should be looking at the tools that perform scenario modelling and all basic tools today can give you that,” Geary said.

Companies can start by looking at historical patterns and the drivers of customers’ behaviour to identify business drivers. Users should be able to look at reports in Excel and slice and dice the data to understand the business better. In the future, Geary predicted, companies will run more predictive models relying on bigger sets of data using new language like Hadoop.

One of the areas where advanced analytics plays a growing role is in integrated driver-base planning. Larysa Melnychuk, managing director of the FP&A Club for the Association for Financial Professionals (AFP), provided an example from her past work at a bank.

“We used a ‘survival analysis’ technique for the forecasting behaviour of a complex portfolio of personal loans and credit cards,” she said. “This non-standard analysis – not typical for finance – helped generate business insights that significantly changed strategy on some of the products. It also helped us to improve the profitability of the portfolio.”

+

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

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 Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Transforming FP&A Together: Human & AI Synergy

May 15, 2025

The Face-to-Face Milan FP&A Board
The Face-to-Face Milan FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)

May 20, 2025

The Face-to-Face Frankfurt FP&A Board
The Face-to-Face Frankfurt FP&A Board Five Critical Roles for Building a World-Class FP&A Team

May 22, 2025

BPAI
The FP&A Trends Webinar FP&A Business Partnering and AI: A New Era

May 28, 2025

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

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