Logo
Phone
Partner
Center Image

Advanced Essbase Calculations For Forecasting & Driver Based Budgeting

Click HERE to download an agenda and detailed description for Advanced Calculations for Forecasting and Driver Based Budgeting


    • Maximize the value of your company’s Hyperion investment
    • Revolutionize your company’s forecasting and planning
    • Boost your Professional skills

Course Description:

For many companies the annual budget is the single biggest investment in improving business performance. Most companies’ budgets are adequate for financial control but relatively few can be used for powerful strategic planning. In addition, in most cases the process is more time-consuming and labor intensive than necessary. So how can we make the process more strategic and at the same time make it faster and easier? The answer lies in improving the calculation logic.

    Essbase calculations can be used to:

      • Reduce effort by providing automatic “baseline” forecasts as a starting point
      • Implement more frequent reforecasts or continuous planning
      • Link budgeting to strategy by focusing on strategic drivers
      • Implement driver based budgeting

In this course you will learn the Essbase functions and structures that are most important for forecasting, projections and budgeting. Then you will apply your new skills to hands-on examples and exercises including:

      • Revenue

      • Workforce Expenses

      • Direct Costs

      • Workforce Expenses

      • Other Indirect Costs

      • Linking Budgets To Strategy

      • Rolling Forecasts And Continuous Planning

      • Currency Conversion

The calculation techniques covered in this class are applicable in both Essbase and Planning. Students are invited to bring their own budget models and work on them during class. You can make tangible progress toward implementing the new techniques at your company.

      • Rolling Forecasts

      • Burn Rate Modeling

      • Step Functions

      • Sales Pipeline Modeling

      • Exponential Smoothing

      • Regression

      • Workforce Overhead Forecasting

      • Controlling Block Creation

      • Automatic Baseline Forecasts

      • View Dimensions

      • Lookup Cubes

      • S-Curves (Penetration Curves)

      • Rule of 78

      • @XRANGE

      • @TREND

      • @CORRELATION

      • Custom Macros

      • @XREF

      • @SPLINE

      • @MDSHIFT

Click HERE to download an agenda and detailed description for Advanced Calculations for Forecasting and Driver Based Budgeting