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
From Data to Real Insight as the Analytics Business Partner
December 3, 2020

By Robert J. Zwerling and Jesper H. Sorensen, founders of the Finance Analytics Institute

The Authors

Robert J Zwerling and Jesper H Sorensen are the founders of the Finance Analytics Institute.

Mr. Zwerling is also Managing Director of Aurora Predictions, providing intuitive analytics with AI software for Finance and Operations.

Mr. Sorensen is also Senior Finance Director in a Fortune 100 technology company with a proven track record of advancing the analytics agenda.

To learn more about the Finance Analytics Institute please visit at www.fainstitute.com.

FP&A Tags
FP&A Business Partnering
Data-Driven FP&A
Financial Planning and Analysis

Business partneringMany Finance professionals have an incorrect perception of the word “insight”, but here is a simple way to validate if you provide insight or “just” data. Ask yourself, what decision a business can make based on the data you have provided? Insight is something valuable and not yet known by the business, but when known, the business uses it to make decisions that are data-driven.

The figure below describes how insight sits between Hindsight Information and Predictive Foresight. Also, it demonstrates how advancing analytics moves Finance from providing information on ”What Happened” and ”Where It Happened” to storytelling about “Why It Happened” with real insight. In this article, we will explore how to generate real insight for data-driven decisions. 

analytics​

It starts with Standard Reporting 

For example, Finance has noticed that global sales have dropped -1% in the past two quarters and is thereby able to tell “What Happened” as part of its high-level standard reporting. 

Also, Finance can drill down to find “Where It Happened”; i.e. global sales are down 1%, which mainly relates to the regions North America (NA) and Latin America (LA), which are down -3% to -5% year-over-year (YoY). In contrast, all other regions are up 2% to 4% YoY. Is this insight? No, because we haven’t yet told Why It Happened…

analytics​

A classic mistake when trying to provide insight

To understand Why, 99% of all Finance groups will use their soft skillsets (communication, acumen, and teamwork) to get involved with the VP of Sales to understand his perspective on why sales are declining in NA and LA. 

The VP of Sales explains that the last two quarters had several deals which slipped to the next quarter in LA and NA, and provides a list below of the slipped deals: 

analytics​

Is this then insight? No, it is information or knowledge at its best, but you cannot take any data-driven decisions from it, so we still don’t know if the underlying driver for Why sales are down is because of slipped deals. The VP of Sales is providing his “first-hand explanation”, but unfortunately, Finance most often takes it as-is and stops their investigation here!

Looking for patterns to uncover real insights

However, what could Finance have done to provide real insight and not simply to copy a message from the VP of Sales? The 1% of Finance professionals who act as an Analytics Business Partner™ (ABP) approach the above situation differently.

It starts with curiosity. Are slipped deals really the underlying issue? The ABP will employ analytics to look for patterns in data to uncover insights.    

First, the ABP pull sales data by customer and salesman for the past two years and immediately observe there is no change in slipped deals YoY. As such, the VP sales explanation wasn’t sufficient, so the ABP will have to dig deeper for real insight. 

The ABP often use multi-source data to gain multi-dimensional perspectives. A salesmen's tenure may be pulled to learn if tenure correlates with sales performance. Quick insights appear, such as, the longer the tenure of a salesman, the more the salesman sells. A very strong correlation between tenure and sales by salesmen is shown in the chart below.

sales​

The Analytics Business Partner can now tell something valuable not yet known by the business, which the business can use to make decisions which are data-driven. In this case, that tenure is the underlying driver for how much the business is selling. 

Understanding the underlying driver

We can see that even though NA and LA have the same amount of salespeople, they have replaced salesman 5 (5 LA) and Salesman 10 (10 NA), who were some of the top sellers, with salesman 11 (11 NA) and Salesman 12 (12 LA). As tenure is the underlying driver for sales performance, this will have a significant effect on overall sales performance when there is a change in tenure. 

Understanding this relationship, the VP of Sales now learned to reduce overall sales expectations for the coming quarters, or if he cannot “afford” such reduction, he knows that initiatives need to be taken as this trend will continue for a while until more tenure has been built in the sales force.  

Conclusion

This is an example of how Finance use Diagnostic Analytics to tell ‘Why It Happened’ by finding a correlation for the financial performance and thereby providing real insight. And as demonstrated, insight is not to copy/paste of a message from having asked a Business Executive Why it happened. Insight is something that Finance has found through analytics that the business can form decisions from that are data-driven. This way of thinking in Finance is how the Analytics Business Partners differentiate themselves! 
 

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

Related articles

Decision-Making Process
Fair Analytics: Upgrade Your Decision-Making Process
November 11, 2020

The quality of a decision is a question about what data or lack of data the...

Read more
Business thinking
Going from Data to Insight
April 30, 2020

A recent Accenture study showed that 79% of large company executives think that companies that don’t...

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
How to Improve the Quality of Your Data in 4 Steps
February 11, 2020

According to a recent survey by Prophix and FP&A trends, 88% of companies claim they have...

Read more
5 Simple Steps to Help Drive Knowledgeable, Strategic Decisions
July 19, 2019

The decision cycle will help you and your association make knowledgeable decisions that drive exceptional results...

Read more
Self-Service Analytics: FP&A Challenges
March 13, 2019

Any activity or business process executed in the various departments across the enterprise has an impact...

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