Crystal Ball 11.1.1 Essentials
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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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 Distributions Overview
- Basic Distribution Statistics
- Predefined Basic Distributions
- Setting Crystal Ball Launch Preferences
- Setting Run Preferences
- Basic Terminology
- Crystal Ball Menus
- Additional Resources
- Creating Assumptions
- Creating Forecasts
- About Distributions
- Editing assumption and forecast data
- About Data-Based Assumptions
- Creating Assumptions Through Distribution Fitting
- Creating Data-Based Custom Assumptions
- Correlating Assumptions
- About Expert-Based Assumptions
- Constructing Normal Distributions with Known Parameters
- Creating Triangular Distributions
- Building Custom Distributions
- Additional References
- Running Simulations
- About the Base Case
- Analyzing Forecasts
- Viewing Assumption Charts
- Analyzing Multiple Forecasts
- Types of Reports
- Generating Reports
- Saving Results
- About Crystal Ball Tools
- Sensitivity Analysis
- Tornado Charts
- About Batch Fit
- Generating Batch Fit Results
- Generating Correlation Matrices
- Analyzing correlations with Scatter Charts
- Setting Precision Control Preferences
- Setting Sampling Preferences
- Setting Run Time Preferences
- Selecting Simulation Run Options
- Setting Options for Simulation Statistics
- Running Precision Control
- Working with Alternate Parameters
- Truncating Assumption Distributions
- Creating Distribution Functions
- Publishing and Subscribing to Distributions
- Customizing the Distribution Gallery
- Automatically Extracting Forecast Statistics
- Adding Marker Lines to Forecast Statistics
- Fitting Distributions to Forecasts
- Filtering Forecast Results
- Optimization Fundamentals
- OptQuest Optimization Terms
- OptQuest Optimization Process
- OptQuest Optimization Overview
- Optimizing Decision Variables
- Managing OptQuest Solutions
- OptQuest Performance Best Practices
- Performing Efficient Frontier Analysis
- 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
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.