Facets Demo New Batches Starting from Saturday... 22-10-2016
Search Course Here

Live Chat

Hyperion Crystal Ball


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.
course content
  • Modeling and Simulation Overview
    • Oracle's Enterprise Performance Management System
    • Model Basics
    • Simulation Basics
    • 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 Assumptions
    • About Assumptions
    • 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
    • Defining Forecasts
    • Running Simulations
    • Analyzing Forecast Charts
    • Viewing Other Charts with Forecast Data
    • Saving and Loading Forecast Results
    • Editing Crystal Ball Data

  • Correlating Assumptions
    • 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

  • Creating Reports
    • About Crystal Ball Reports
    • Generating Reports
    • Extracting Data to Excel

  • Determining Assumptions with Tornado and Spider Charts
    • Considering Assumptions
    • 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

  • Setting Advanced Options for Assumptions
    • Building Distributions 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 Charts
    • Fitting Distributions to Forecast Charts
    • Filtering Forecast Results

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

  • Optimizing Decisions with OptQuest
    • About Optimization
    • About OptQuest
    • Optimizing Decision Variables
    • Analyzing OptQuest Results
    • OptQuest Performance Best Practices
    • Performing Efficient Frontier Analysis

  • Forecasting with Predictor
    • About Crystal Ball Predictor
    • Creating Time Series Forecasts
    • Working with Predictor Results
    • Performing Linear Regressions
    • Predictor Integration with Planning and Essbase
For Videos Click Here Videos

Flash News

AngularJS New Batch Start From 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :