Center Image

Advanced Essbase Calculations For Forecasting & Driver Based Budgeting

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

In a content rich two day training session, Ron expanded our imaginations by categorizing advanced Essbase techniques in an easy to understand framework and illustrating practical approaches using mini practice cases. Ron’s request for satisfied students is unparalleled. I look forward to the post training catch up session.” –Hugh L. (Financial Services Company)



Register Format Price Duration Dates
Register Live Classroom, NYC $1350.00 USD 2 Days  May 2-3, 2013
Register Live Online Class $1350.00 USD 2 Days  TBA


Learning new Essbase calculation skills is one of those things that can deliver quick ROI by solving a few existing problems or it can revolutionize your entire budgeting and planning process. It’s not expensive and in most cases the environment is already in place.

But until recently there hasn’t been a course that pulls together the most useful intermediate and advanced Essbase calculation techniques and shows you how to apply them to build practical analytics that every company can use.

That’s the goal of MTG’s Advanced Calculations for Forecasting and Driver Based Budgeting. We want to help you acquire the next level of intermediate and advanced calculation skills and then we want to show you concrete examples of how you can apply them. If you bring your Essbase outlines we will even help you implement the new techniques on your database during class.

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 Expense
    • 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
    • Custom Macros
    • @XREF
    • @SPLINE
    • @MDSHIFT

Registration Information: The course applies to both Essbase and Hyperion Planning. Course size is strictly limited to 12 students. The class will be delivered by Ron Moore (learn more about our instructor). You will receive a course guide that includes exercises and code samples along with all files required to complete the exercises. Participants are eligible for CPE credit on completion.

Who Should Attend:

      Finance and/or IT professionals working with Essbase or Hyperion Planning calculations particularity calculations for forecasting, budgeting, sales and marketing.

Prerequisites: Essbase Bootcamp or equivalent

Cost: $1350*

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

Still not sure? Call us at 212.824.2900 and get a free evaluation of how this course can help you boost ROI!

Thursday, May 2 – Friday, May 3, 2013
9am-5pm EST
$1350.00 USD
Live Register

*If you are part of a company or group of four or more interested in signing up for this class or any of MTG’s other Essbase offerings (excluding OU classes) please contact us at (212) 824-2900 or training@mtgny.com to find out about our discount group rates.