Jet Power Your Decision Making with Visual What-If Scenarios Using Xcelsius

  • by Nikhil Sharma, Manager, PricewaterhouseCoopers LLP, Mclean, VA
  • July 13, 2010
Using an interactive Xcelsius report to conduct what-if scenarios allows users to quickly see the effects of business decisions in an engaging manner. Find out how to create your own what-if analysis report. A sample data file and a working what-if analysis report are provided as download files to help you get started.
Key Concept
Business decision making is a complex mix of reporting, tracking trends, and benchmarking. This involves a simulation of the many parameters involved in complex business equations. What-if analysis is one of the ways to simulate and check the overall effect of changes.

Successful companies know how to best plan for possible scenarios by using what-if analysis. This enables companies to review potential outcomes to business decisions without affecting the business. SAP BusinessObjects Xcelsius Enterprise is one application you can use for this what-if analysis.

I’ll use the example of working capital to illustrate how to launch a what-if analysis with SAP BusinessObjects Xcelsius. A CFO of a retail enterprise (My Retail Business) wants to evaluate how the enterprise is doing with respect to working capital and how he can improve the overall cash flow position. Working capital depends on four main variables:

  • Accounts receivable (AR) days
  • Accounts payable (AP) days
  • Inventory days
  • Available cash

Nikhil Sharma

Nikhil Sharma is a manager in the advisory practice at PricewaterhouseCoopers LLP, based out of Mclean, VA. He specializes in SAP NetWeaver BW architecture, design, and visualization. For the past 10 years he has led several implementations, including projects in the retail, automotive, and chemical domains. Prior to consulting, he was involved in sustenance and development of SAP NetWeaver BW at SAP, primarily concentrating on master data services.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.