• Visit Our Network:
  • AFP
  • CTP Certification
  • FP&A Certification
  • AFP Annual Conference
  • CTC
The Resource for the Global Finance Profession

BI & Analytics: Key Tools for FP&A Professionals

  • By Steve Williams
  • Published: 2014-06-10

The evolution of the financial planning and analysis 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.
  • 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.  

It’s all business information

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

Steve Williams is the founder of DecisionPath Consulting and author of The Profit Impact of Business Intelligence. He can be reached at steve.williams@decisionpath.com.

Copyright © 2015 Association for Financial Professionals, Inc.
All rights reserved.

You May Also Be Interested In...

Copyright © 2015 Association for Financial Professionals, Inc. - All rights reserved.
AFP, 4520 East-West Highway, Suite 750, Bethesda, MD 20814, Phone 1.301.907.2862
Follow Us AFP on LinkedInAFP on TwitterAFP on YouTubeAFP FacebookAFP Newsfeed