• // Business Intelligence
  • // Data Warehousing
  • // Business Analytics.

BI & Analytics - Financial Planning & Analysis Functions Need to Invest

Financial Planning and Analysis (FP&A) is Changing

The evolution of the FP&A role has involved two primary thrusts:


  • expanding the business focus of the role – the FP&A professional is increasingly expected to help line managers and key decision-makers optimize strategic performance, resource utilization, and profitability; and
  • using more powerful tools – business intelligence (BI) and analytics make it possible to enhance the contributions made by FP&A professionals – both in terms of the breadth of contribution and the level of output achievable in a given timeframe.


Arguably, the ability of FP&A professionals to make enhanced contributions is substantially impacted by the quality of tools provided to them.


BI and Analytics – It’s All Business Information in the End


Rather than getting hung up on semantic debates, we can define business intelligence as the use of business information (processed data) and business analyses to support business decisions in the context of core business processes that drive profit and performance.[1]   Typical business intelligence (BI) applications – all of which leverage business data – include:


  • Reports:      standard, pre-formatted information for backward-looking analysis of      business trends, events and performance results;
  • Multi-dimensional      analyses: applications that      leverage a common database of trusted business information and that      fully-automate information slicing and dicing for analysis of the      underlying drivers of business events, trends and performance results;
  • Scorecards and      dashboards: convenient forms of multi-dimensional analyses that are      common across an organization, that enable rapid evaluation of business      trends, events, and performance results, and that facilitate use of a      common management framework and vocabulary for measuring, monitoring, and      improving business performance;
  • Advanced analytics: automated applications that      distill historical business information so that past business trends,      events, and results can be summarized and described via well-known and      long-used statistical methods;
  • Predictive      analytics: automated      applications that leverage historical business information, descriptive statistics,      and/or stated business assumptions to predict or simulate future business      outcomes; and
  • Alerts:   automated      process control applications that analyze performance variables, compare results to a standard, and      report variances outside defined performance thresholds.


Ultimately, all of these forms of BI deliver business information for decision-makers to use to understand past performance and its root causes, model various courses of actions, predict future results, and make decisions that are informed by underlying data.   Simply put, BI is about leveraging business information to drive business results.


BI for FP&A


The role of the FP&A professional encompasses such activities as planning, forecasting, budgeting, controlling, variance analysis, scenario analysis, communicating goals and results, and decision support.  These activities are tools that support the broader FP&A role, which is increasingly focused on reduction of resource waste in business processes and creation of business value through effective resource utilization.  What this translates to is that FP&A professionals need to provide relevant information to the executives and managers who make the decisions that have the highest impact on business results.  This is consistent with the traditional role of management accountants, whose efficacy has been hampered to a meaningful degree by the lack of fully-automated access to high quality business information and the lack of advanced tools for analyzing such information.  While spreadsheets have been a huge advance and will continue to be a mainstay tool in the FP&A toolkit, modern BI and analytics represent the next generation of FP&A tools.  Here are a two high-level examples of how BI can augment and accelerate the FP&A contribution to business results:


  • Common, standardized business information for planning, forecasting, budgeting, modeling, and scenario analysis. Done well, BI is based on an underlying data warehouse and/or data mart, and thus it delivers common multi-dimensional views of business trends, events, and performance.  Planning, forecasting, and budgeting almost always start by looking at what has happened in the past to derive assumptions about the future.  BI eliminates much of the arduous data discovery work needed to develop and justify those assumptions. The same underlying data is also an input to models and scenario analyses, which basically predict and evaluate what might happen in the future under various assumed conditions.
  • Standard scorecards and dashboards for variance analysis, performance control, and communicating strategic and operational results.  Companies today often spend considerable manual effort to generate monthly scorecards and dashboards by extracting bits of information a piece at a time from standard reports or report data files, dropping the information into spreadsheets, and then copying the spreadsheets into presentation decks for upper management.  One study revealed than many companies invest over $100,000 per year in labor costs to produce such manual scorecards and dashboards.  BI automates such work, and it provides a robust platform for drilling down to root causes of variances.


There is much more to be explored when it comes to BI and analytics for FP&A.  In coming articles we will drill down into particulars, using case studies to illustrate the challenges FP&A professionals have described and their planned uses of BI.

[1] Williams, S. and Williams, N. The Profit Impact of Business Intelligence, Morgan Kauffman 2007

[1] Williams, S. and Williams, N. The Profit Impact of Business Intelligence, Morgan Kauffman 2007

Created by Matrix Group International, Inc. ®