Crystal Ball 11.1.1 Essentials

Total time

Crystal Ball 11.1.1 Essentials

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

This product does not have fixed starting dates and/or places.

Description

During the first half of this two-day course, you begin spreadsheet risk analysis using Crystal Ball Fusion Edition. You will be taught 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 the best ways to present your 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 Fusion Edition. Advanced topics such as optimization and time-series forecasting, advanced assumptions, forecast options and precision controls are also covered. The emphasis in th…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: .

During the first half of this two-day course, you begin spreadsheet risk analysis using Crystal Ball Fusion Edition. You will be taught 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 the best ways to present your 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 Fusion Edition. Advanced topics such as 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 using the combined power of Crystal Ball and OptQuest.

Design discussions and real-world exercises are provided throughout the course to reinforce your understanding of the concepts presented.

Learn to:
  • Construct Spreadsheet Models
  • Analyze Spreadsheet Models
  • Optimize Decision Variables
  • Forecast Data with Predictor
  • Define Assumptions and Forecasts

* This course is also suitable for customers using Crystal Ball 7.3.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.


Audience
  • Data Modelers
  • End Users
  • Technical Consultant
  • System Analysts
  • Business Intelligence Developer
  • Business Analysts

Course Topics Modeling and Simulation Overview
  • Model Basics
  • Simulation Basics
  • About Crystal Ball
  • Modeling and Simulation Considerations
  • Model Development Process
  • About Monte Carlo Simulations
Probability Distribution Fundamentals
  • Probability Distributions Overview
  • Basic Distribution Statistics
  • Predefined Basic Distributions
Navigating Crystal Ball
  • Setting Crystal Ball Launch Preferences
  • Setting Run Preferences
  • Basic Terminology
  • Crystal Ball Menus
  • Additional Resources
Creating Assumptions and Forecasts
  • Creating Assumptions
  • Creating Forecasts
  • About Distributions
  • Editing assumption and forecast data
Creating Data-based Assumptions
  • About Data-Based Assumptions
  • Creating Assumptions Through Distribution Fitting
  • Creating Data-Based Custom Assumptions
  • Correlating Assumptions
Creating Assumptions Based on Expert Opinion
  • About Expert-Based Assumptions
  • Constructing Normal Distributions with Known Parameters
  • Creating Triangular Distributions
  • Building Custom Distributions
  • Additional References
Analyzing Simulation Results
  • Running Simulations
  • About the Base Case
  • Analyzing Forecasts
  • Viewing Assumption Charts
  • Analyzing Multiple Forecasts
Presenting Simulation Results
  • Types of Reports
  • Generating Reports
  • Saving Results
Analyzing with Crystal Ball Tools
  • About Crystal Ball Tools
  • Sensitivity Analysis
  • Tornado Charts
  • About Batch Fit
  • Generating Batch Fit Results
  • Generating Correlation Matrices
  • Analyzing correlations with Scatter Charts
Working with Simulation Controls
  • Setting Precision Control Preferences
  • Setting Sampling Preferences
  • Setting Run Time Preferences
  • Selecting Simulation Run Options
  • Setting Options for Simulation Statistics
  • Running Precision Control
Setting Advanced Options for Assumptions
  • Working with Alternate Parameters
  • Truncating Assumption Distributions
  • Creating Distribution Functions
  • Publishing and Subscribing to Distributions
  • Customizing the Distribution Gallery
Setting Advanced Options for Forecasts
  • Automatically Extracting Forecast Statistics
  • Adding Marker Lines to Forecast Statistics
  • Fitting Distributions to Forecasts
  • Filtering Forecast Results
Optimizing Simulation Models with OptQuest
  • Optimization Fundamentals
  • OptQuest Optimization Terms
  • OptQuest Optimization Process
  • OptQuest Optimization Overview
  • Optimizing Decision Variables
Analyzing Optimization Solutions
  • Managing OptQuest Solutions
  • OptQuest Performance Best Practices
  • Performing Efficient Frontier Analysis
Forecasting with Predictor
  • Creating Time Series Forecasts
  • Performing Linear Regressions

Course Objectives
  • Create Assumptions Based on Expert Opinion
  • Understand Probability Distribution Fundamentals
  • Navigate Crystal Ball
  • Create Assumptions and Forecasts
  • Create Data-based Assumptions
  • Analyze Simulation Results
  • Present Simulation Results
  • Analyze using Crystal Ball Tools
  • Work with Simulation Controls
  • Set Advanced Options for Assumptions
  • Set Advanced Options for Forecasts
  • Optimize Simulation Models with OptQuest
  • Analyze Optimization Solutions
  • Forecasting with Predictor
  • Understand Modeling and Simulation

There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.