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
Seven Key Analytic Models
September 22, 2017

By Michael Coveney, Analytics Thought Leader and Author

FP&A Tags
Modelling and Forecasting
FP&A Analytics

The role of planning is to help manage what can be controlled (i.e. the organisation’s business processes, the resources it applies to those processes,  and the volume and quality of work done in those processes) to produce outcomes that will achieve organisational objectives, within an uncontrollable and unknowable external environment. From this, it can be seen that an organisation’s business processes are central to Business Analytics.

To plan and monitor performance effectively requires a network of analytic models. Most organisations are too large and complex to have a single model, and so the models I will describe may be implemented as separate but linked physical entities.

These models focus on 7 key questions that management should know about its business processes:

  • How efficient and effective are the organisation’s business processes? (Operational Activity Model - OAM).  This model is where the relationships between business process activities, resources, and outcomes are defined and comprises of a range of measures through which departmental activities and outcomes can be judged. It also holds a number of versions of data (Target, Budget, Forecast, Actual, Benchmark) that can be used to assess whether the operation is functioning well and if the resources allocated to activities represent good value.
  • What trends are ‘hidden’ in the historic detail? (Detailed History Model). This comprises detailed data behind each measure, such as sales which may be broken down into customer, product, channel, and so on. Similarly, it may also contain a list of general ledger transactions behind a departmental expense line that appears in the above OAM.  The aim is to reveal any trends that can be used to predict future performance and how they can be enhanced/mitigated.
  • What long-range targets should be set given where the market is heading? (Target Setting Model). This model is typically driver based at a summary level to allow senior management to set aspirational goals for the organisation to achieve in the medium to long term.
  • Where is the organisation heading if it continues with its current business model? (Detailed Forecast Model). This contains details behind user-entered forecasts and should be a true reflection of the current prospect of the organisation.
  • What could be done differently to better meet long-range targets, and how much would it cost? (Strategy Improvement Model). This model allows managers to run a variety of scenarios of changes to the way it operates in order to meet long-term targets.
  • What choices/risks do management face, and what would be the impact on corporate goals? (Scenario / Optimization Model). This is similar to the Strategy Improvement model but allows management to stagger strategic improvements that make the best use of available resources
  • How much funding is required to implement the plan, and where will it come from? (Cash / Funding Model). This last model looks at the cash-flow implications and allows senior managers to assess how any capital items are to be resourced.

Each of the above models is likely to have different content, and structures and are used by different people at different times. However, none can be omitted or ignored, and all need to operate as a single, data-driven management system.

From a planning systems point of view, this network of models can be visualized as follows:

Figure 1: Schematic overview of the 7 key models required to manage performance

As can be seen, these models are fed with data from internal systems, such as the general ledger, and from external sources, such as market information, along with data supplied by end-users.

Obviously, in this type of blog, I’ve been unable to go into too much detail on how these operate, but hopefully, there is enough here to get you thinking about the models you need to run your business.

 

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

Related articles

Michael-Coveney-Life-Cycle-Planning-Model-Main-Picture
Life Cycle of a Planning Model
April 6, 2023

In this series of blogs, the author will be providing a comprehensive approach to the design...

Read more
Scenario Modelling in a Disrupted Environment by Marat Lomakov
Scenario Modelling in a Disrupted Environment
January 5, 2023

In this short video, Marat Lomakov, Finance Director, Europe Supply Chain at Ecolab, shares his insights on...

Read more
Driver-Based Modeling as the Basis for Flexible and Dynamic FP&A by Jim Boswell
Driver-Based Modeling as the Basis for Flexible and Dynamic FP&A
November 15, 2022

Learn from Jim Boswell, VP of Finance at FullSpeed Automotive about the best practices in building Driver-Based...

Read more
fp&a
Keys to Building a Dynamic Financial Model
July 12, 2022

For anyone unfamiliar, a financial model is a tool used to reflect the economics of a...

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

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