Name: Advanced Crystal Ball
Course Code: ORHY70218
Duration: 1
Scheduled Dates for ORHY70218
This course will enable participants to develop advanced Crystal Ball models, expedite the model building process and apply the analytical tools of Crystal Ball Professional Edition. Participants can extend their understanding of Crystal Ball to include optimization, time-series forecasting and more. Participants learn to make optimal decisions using the combined power of Crystal Ball and OptQuest, and they also gain an understanding of time-series forecasting, advanced assumptions, forecast options and precision controls.
This course is designed for intermediate and advanced Crystal Ball users who want to expand their modeling tool set. This offering covers most, if not all, of the suite of tools in the Professional Edition.
Learn To:
- Use the tools of Crystal Ball Professional
- Make optimal decisions despite uncertain conditions
- Build and analyze spreadsheet risk models
Target Audience
End Users
Key Topics
- Advanced Assumption Options
- - Using alternate parameters
- - Using a formula as a parameter
- - Truncating assumption distributions
- - Using a function as a distribution
- - Customizing the distribution gallery
- - Publishing and subscribing to distributions
- Advanced Forecast Options
- - Fit a distribution to a forecast
- - Forecast filtering
- - Auto extract forecast data
- - Adding marker lines to forecast statistics
- Advanced Simulation Control
- - Precision control
- - User defined macros
- - 2D simulation
- - Bootstrapping
- OptQuest
- -What is optimization?
- - How OptQuest works
- - Optimization applications
- - Running OptQuest
- - OptQuest results
- - Efficient frontier
- Predictor
- - Time series forecasting
- - Linear regression
- A Taste of Real Options
Objectives
- Understand the tools of Crystal Ball Professional suite and its usage
- Make optimal decisions despite uncertain conditions
- Communicate the concept of risk to others
- Extend ability to build and analyze spreadsheet risk models
- Understand about some handy tips, shortcuts, and modeling techniques
Required Skills/Experience
- An introductory understanding of Excel
- Competence with Windows operating systems
- Introduction to Crystal Ball
Fee: $750.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
