Crystal Ball 11.1.2 Essentials

////Crystal Ball 11.1.2 Essentials

Crystal Ball 11.1.2 Essentials

Course ID: P923 2 Days

Crystal Ball 11.1.2 Essentials


This course enables you to perform spreadsheet risk analysis using Crystal Ball Standard Edition. On day one, you learn the basics of Monte Carlo simulation, tornado analysis, and steps to develop Crystal Ball models. A strong emphasis is placed on gaining insight from simulation results and understanding the best ways to present findings to peers, management, or clients.

On day two, you develop advanced Crystal Ball models, expedite the model-building process, and apply the analytical tools of Crystal Ball Professional Edition. Advanced topics, including optimization and time-series forecasting, advanced assumptions, forecast options, and precision controls, are also covered. The emphasis in the second half of this course is on learning to make optimal decisions by using the combined power of Crystal Ball and OptQuest.



  • End Users
  • Business Analysts





Instructor-led / Virtual Instructor-led

Singapore: Upon Request



  • Describe modeling and simulations
  • Start Crystal Ball and access resources
  • Explain Crystal Ball probability distributions
  • Define assumptions
  • Correlate assumptions
  • Analyze and present simulation results
  • Analyze data with Crystal Ball tools
  • Set advanced options for assumptions and forecasts
  • Manipulate simulation controls
  • Optimize decisions with OptQuest and analyze solutions
  • Perform time series forecasting with Predictor


Module 1: Modeling and Simulation Overview

  • Simulation Basics
  • Model Basics
  • Oracle’s Enterprise Performance Management System
  • About Monte Carlo Simulations
  • About Crystal Ball

Module 2: Getting Started with Crystal Ball

  • Crystal Ball Ribbon
  • About the Welcome Dialog Box
  • Additional Resources for Crystal Ball
  • Setting Crystal Ball Start Preferences

Module 3: Examining Probability Distributions

  • Commonly Used Crystal Ball Distributions
  • About Probability Distributions
  • Properties of Crystal Ball Distributions
  • Basic Distribution Statistics
  • Viewing Distribution Types in the Distribution Gallery

Module 4: Defining Assumptions

  • Defining Data-Based Assumptions with Custom Distributions
  • Defining Expert-Based Assumptions
  • About Assumptions
  • Best Practices for Defining Assumptions
  • Generated Names for Assumption Cells
  • Referencing Cells for Parameter Values
  • Defining Data-Based Assumptions Through Distribution Fittings

Module 5: Defining Forecasts, Running Simulations, and Analyzing Results

  • Analyzing Forecast Charts
  • Viewing Other Charts with Forecast Data
  • Editing Crystal Ball Data
  • Running Simulations
  • Saving and Loading Forecast Results
  • Defining Forecasts

Module 6: Correlating Assumptions

  • Rank Correlation Method
  • Defining Correlations by Modifying Assumption Definitions
  • Adjusting Correlation Coefficients During Simulations
  • Crystal Ball Options for Correlating Assumptions
  • Importance of Correlating Assumptions
  • Best Practices for Correlating Assumptions

Module 7: Creating Reports

  • About Crystal Ball Reports
  • Generating Reports

Module 8: Determining Assumptions with Tornado and Spider Charts

  • Creating Tornado and Spider Charts
  • Examining Tornado Charts
  • Considering Assumptions
  • Examining Spider Charts
  • Tornado Charts Versus Sensitivity Charts
  • About Tornado and Spider Charts

Module 9: Working with Multiple Assumptions

  • Batch Fitting Probability Distributions
  • Correlating Multiple Assumptions with Correlation Matrices

Module 10: Setting Advanced Options for Assumptions

  • Creating Distribution Functions
  • Customizing the Distribution Gallery
  • Truncating Assumption Distributions
  • Publishing and Subscribing to Distributions
  • Building Distributions with Alternate Parameters

Module 11: Setting Advanced Options for Forecasts

  • Fitting Distributions to Forecast Charts
  • Adding Marker Lines to Forecast Charts
  • Filtering Forecast Results
  • Automatically Extracting Forecast Statistics

Module 12: Working with Simulation Controls

  • Setting Run Mode Preferences
  • Setting Sampling Preferences
  • Setting Precision Control Preferences
  • Selecting Options for Simulation Statistics

Module 13: Optimizing Decisions with OptQuest

  • About OptQuest
  • About Optimization
  • Optimizing Decision Variables
  • Performing Efficient Frontier Analysis
  • Analyzing OptQuest Results

Module 14: Forecasting with Predictor

  • About Crystal Ball Predictor
  • Predictor Integration with Planning and Essbase
  • Working with Predictor Results
  • Creating Time Series Forecasts
  • Performing Linear Regressions

What’s Next

Subscribe to our mailing list for special offers and promotions.

Thank you! Your subscription has been confirmed. You'll hear from us soon.