Oracle Crystal Ball is the leading spreadsheet-based application for predictive modeling, forecasting, simulation, and optimization. It gives you unparalleled insight into the critical factors affecting risk. With Crystal Ball, you can make the right tactical decisions to reach your objectives and gain a competitive edge under even the most uncertain market conditions.
Crystal Ball software is a powerful set of spreadsheet-based tools that empower you to forecast your business data and turn your financial and operational spreadsheet models into dynamic analytical applications.
Leveraging the power and ease of Crystal Ball Decision Optimizer, Oracle Crystal Ball Enterprise Performance Management enables managers, executives and analysts to better manage risk and improve planning/forecast accuracy across the enterprise using EPM and Business Intelligence (BI) applications.
Introductory understanding of Excel and competence with Windows operating systems
Basic knowledge of probability and statistics
It is a 16 days program and extends up to 2hrs each.
The format is 40% theory, 60% Hands-on.
It is a 4 days program and extends up to 8hrs each.
The format is 40% theory, 80% Hands-on.
Private Classroom arranged on request and minimum attendies for batch is 4.
Modeling and Simulation Overview
Oracle's Enterprise Performance Management System
About Monte Carlo Simulations
About Crystal Ball
Model Development Process
Getting Started with Crystal Ball
Setting Crystal Ball Start Preferences
About the Welcome Dialog Box
Basic Crystal Ball Terminology
Crystal Ball Ribbon
Additional Resources for Crystal Ball
Examining Probability Distributions
About Probability Distributions
Basic Distribution Statistics
Viewing Distribution Types in the Distribution Gallery
Properties of Crystal Ball Distributions
Commonly Used Crystal Ball Distributions
Defining Data-Based Assumptions Through Distribution Fittings
Defining Data-Based Assumptions with Custom Distributions
Defining Expert-Based Assumptions
Referencing Cells for Parameter Values
Generated Names for Assumption Cells
Best Practices for Defining Assumptions
Defining Forecasts, Running Simulations, and Analyzing Results
Analyzing Forecast Charts
Viewing Other Charts with Forecast Data
Saving and Loading Forecast Results
Editing Crystal Ball Data
Importance of Correlating Assumptions
Rank Correlation Method
Crystal Ball Options for Correlating Assumptions
Defining Correlations by Modifying Assumption Definitions
Adjusting Correlation Coefficients During Simulations
Best Practices for Correlating Assumptions
About Crystal Ball Reports
Extracting Data to Excel
Determining Assumptions with Tornado and Spider Charts
About Tornado and Spider Charts
Tornado Charts Versus Sensitivity Charts
Creating Tornado and Spider Charts
Examining Tornado Charts
Examining Spider Charts
Working with Multiple Assumptions
Batch Fitting Probability Distributions
Correlating Multiple Assumptions with Correlation Matrices