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
'Business Analytic' Model Life Cycle
September 19, 2017

By Michael Coveney, Analytics Thought Leader and Author

FP&A Tags
Financial Planning and Analysis
FP&A Analytics
Modelling and Forecasting

Analytic models are rarely static. Their aim is to model the organisation in such a way as to allow managers to investigate what is actually going on and to assess changes to the way it operates. These changes may include looking at price/cost structures; the way in which departments are organised; partnerships; outsourcing; or introducing new products/services into new territories.

In each investigation, the model being used will evolve as new information is uncovered that impacts into what is being analysed.  The following graphic illustrates these major steps in a model’s evolution:

By way of example, I will use my experience in a real situation, to explain each phase of development.

Define what is being investigated

A number of years ago I was involved in an exercise with a major brewer as to what areas of the business were the most profitable.  As profitability was the main focus, the model concentrated on the different sources of income and associated costs.  They brewed beer which was sold through pubs they owned as well as other outlets such as supermarkets, restaurants and independent pubs. They also sold products such as wines and spirits bought in from other suppliers – all of which were put into the model so that profitability could be calculated by brand and outlet over time.

Collect relevant data

Now the model was built we had to find the data.  As a tip, don’t create a model from the data that is to hand – first model what you need and then go find the data.  Of course we didn’t have all the data we needed, so estimates were made but noted that they were estimates.  As models evolve, you might need to consider replacing these estimates with systems that can supply facts.

Model / analyse the data

Once the model was completed extensive analysis of the data was performed.  This was done by posing a number of questions such as ‘How has profitability of beer changed over time compared to spirits?”, and ‘Which locations have the lowest cost/structure per unit sold’.  We were using a specialised analytic system so answering these questions was quite easy.

Adapt the Model

What surprised us was the answers.  It appeared the most profitable area of the business was the product labelled ‘Other’, which was a ‘catch all’ for revenue that didn’t fall into beer and spirits.  So the model was adapted to look at ‘Other’ in more detail. This revealed that most of the organisation’s profits were coming from the gambling machines placed in the pubs they managed.  The organisation thought they were a drinks company but in fact they had become part of the leisure industry.

Use Model as a basis for Planning

Now profitability was understood, arrangements were made to improve this through targeted marketing campaigns, incentives and restructures.  The model again was adapted for these and now used to assign budgets and predict future performance.

Monitor Model Performance

The last step was then to track performance to see whether the changes were having the right effect.

Of course, this isn’t really the last step.  And that’s because the world we live in isn’t static. There will always be more/different competitors, the markets will continue to change – and so must our analytic models. Models are never finished – they need to continually evolve if they are to be of any real use.

This article was originally published in ​prevero Blog

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

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