• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Replacing Spreadsheets With An Intelligent FP&A Solution

November 22, 2018   SAP

Part 6 in the “Understanding IFP&A” series

Despite its age, Excel is still the main tool used by FP&A departments for analyzing and reporting data. Many would argue that this is because of its ease of use, relatively low cost, extensive formatting, and graphing capabilities, and simply because there isn’t a better alternative.

But is this still true? To find out, we need to look at how Excel is used and compare this to modern solutions to see if there are enough benefits that would motivate people to change.

The following are some of the common uses of Excel within FP&A:

Combining data from disparate sources

Excel can be used to bring together a wide range of data, whether numeric or text. This can be done through “copy & paste,” loading from text-based files, or by direct import. Once in Excel, the data can be sorted and manipulated into a more usable format.

Modern solutions can do this as well, but in doing so, will leave a full audit trail of how the data was transformed – something that Excel can’t do. The audit trail will confirm which processes took place and whether there were any errors such as mismatches that occurred during the transformation. And a modern solution can repeat this at any time without user intervention, with vast quantities of data, completing each action successfully. That’s something else not possible with Excel.

Calculating additional data items

Using cell formulae or VBA code, Excel can create subtotals, variances, percentages, and a whole host of other calculations, thereby enhancing the data for analysis.

A modern solution can do it a whole lot better. With Excel, calculations are made in reference to their position on a grid. In a modern solution, calculations are named and thus are always applied to the right data. This makes the calculations easy to set up and manage, while with Excel you can only hope the right data is being accessed.

Inserting new data items is easy in a modern solution; you simply add them in. With Excel, you must make sure that any insertions do not mess up the other calculations, which often leads to undetected errors.

Data modeling

Although it’s relatively easy to set up a simple model in Excel, anything else is fraught with difficulty and integrity issues. This is because Excel’s rows, columns, and sheets are all you have to represent the different dimensions of a piece of data (for example, rows = variables, columns = time periods, sheets = divisions). Other business dimensions such as version, product, territory, etc. have to be accommodated by using a combination of columns to represent both version and time periods, for example. This makes the rules complex: you have to know exactly what is being stored in each cell and where rules cannot be copied, as the data represented may be of a different type. You can create a rule to add up columns of data to give a YTD value for P&L accounts, for instance, but those same rules cannot be applied to a balance sheet or statistical items.

This doesn’t happen with modern solutions, which have a built-in understanding of the different business dimensions and the type of data each represents. Rules are written in plain English so they make sense. Any data transformations such as currency conversion and totals are performed automatically.

Reporting data and analyses

Excel has excellent capabilities for creating highly formatted reports along with charts. But again, you need to be very careful about the selection of data, as the charts work off cell grid references and not the data they represent.

Modern solutions also have great reporting and charting capabilities. But they offer the big advantage of selecting data by business dimension names, which greatly increases the speed and integrity of what is being reported.

Unlike Excel, modern solutions support multiple views of the same data, but without any need to copy the data. And those reports can then be shared among other users who will all be looking at a single version of the data, within an access-controlled security system.

Encouraging people to change

There are many other advantages of moving users from Excel to a modern solution—too many to cover in this blog. The key takeaway: To get users to give up their spreadsheets requires showing them that there is a far better, faster alternative that is secure and doesn’t have the inherent integrity issues.

You can do this by creating a support group that has experience with using a modern solution, with examples of what can be done. Also, you can insist that only reports and analyses created by the adopted intelligent FP&A solution are acceptable when discussing performance.

The next blog in this series illustrates a few fascinating examples of companies using intelligent technologies for FP&A.

Follow SAP Finance online: @SAPFinance (Twitter)  | LinkedIn | Facebook | YouTube

iFP26A Blog CTA 1 Replacing Spreadsheets With An Intelligent FP&A Solution

Let’s block ads! (Why?)

Digitalist Magazine

FP&A, intelligent, replacing, Solution, Spreadsheets
  • Recent Posts

    • Accelerate Your Data Strategies and Investments to Stay Competitive in the Banking Sector
    • SQL Server Security – Fixed server and database roles
    • Teradata Named a Leader in Cloud Data Warehouse Evaluation by Independent Research Firm
    • Derivative of a norm
    • TODAY’S OPEN THREAD
  • Categories

  • Archives

    • April 2021
    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited