Oracle Crystal Ball & Decision Optimizer

Crystal Ball Suite is the simplest and most complete tool for Monte-Carlo simulations + optimization +time-series forecasting for Microsoft Excel spreadsheets and models. Crystal Ball automatically calculates thousands of different "what if" cases, saving the inputs and results of each calculation as individual scenarios.Analysis of these scenarios reveals the range of possible outcomes, their probability of occurring, which input has the most effect on your model and where you should focus your efforts. Furthermore, with the Crystal Ball Professional you can use data from a variety of sources, including your ERP, Data Warehouse, Business Intelligence, etc. to :

  • Build sophisticated time-series forecasts (for sales, product demand, production requirements, etc.) using CBPredictor.

  • Optimize simple and complex multi-variable models and spreadsheets i.e. Maximize Profit, Minimize Costs, Maximize NPV, Eliminate Production Waste, etc. with OptQuest

  • Crystal Ball is designed with enterprise data in mind, to learn more click here

Solve tough problems and do complex scenario analysis with Decision Optimizer

Decision Optimizer (OptQuest) is an optimization tool that runs as an add-in to Crystal Ball that enhances simulation models by automatically searching for and finding optimal solutions.

At the basic level, OptQuest selects a value for each decision variable, enters those values into your spreadsheet, runs a Monte Carlo simulation on the spreadsheet, records the results, and repeats the process.

With OptQuest, you can determine the best combination of decision variables that yields the results you are seeking!

  • Test thousands of scenarios
  • View all the best scenarios
  • 3 Solution Search Models (Network, Neural and TabooSolution Searches)
  • Incorporate multiple constraints such as profitability, NPV, quality specs, etc.


Discover The Power Of Decision Optimizer

Easily add optimization to your Crystal Ball simulation model

  • Build simple or complexe models
  • Example models covers the Portfolio Allocation Model, Productio Optimization, Queuing, Supply Chain Optimization

Use Discreet, Continuous or Custom Variables to test your decisions

  • Define or modify upper and lower bounds for each decision varable
  • Ability to set continuous or discreet simulations

Flexible settings and options to ensure optimal results

  • Use both stochastic and deterministic simulation to test your models
  • Run either a set of itereration or time limit for the optimization
  • Powerful output and reporting options

Optimize any forecast or output in your model

  • Select optimization objectives from your models forecasts
  • Define requirements for feasible solutions
  • Minimize or maximize any forecast

Create natural language logical constraints

  • Create multiple constraints
  • Use of simple operators
  • Natural Language
  • Logic based constraints
 For more information on Decision Optimizer, call us at 1-888-879-8440
  • Test thousands of scenarios
  • View all the best scenarios
  • 3 Solution Search Models (Network, Neural and TabooSolution Searches)
  • Incorporate multiple constraints such as profitability, NPV, quality specs, etc.

Documentation and Reference for Crystal Ball

 TitleDescription 
Crystal Ball Consulting and TrainingTechnology Partnerz complete array of consulting and training to get you up and going with CBDownload
Crystal Ball Quick Reference CardLearn Crystal Ball's powerful shortcut keys and hotkeys for Excel 2007/2010 with this complete quick referenceDownload
Crystal Ball EPM Data SheetCrystal Ball EPM allows users to connect to their Oracle backend to perform sophisticated calculations.Download
Crystal Ball New Feature GuideComplete description of Crystal Ball's new and powerful features, including 64bit compatibilityDownload
Crystal Ball EPM TourSee how you can build simulations models with Excel that are enterprise ready using Oracle Essbase and Planning Download
Optimization using Optquest and Crystal BallSee how optimization can be done quickly and effectively using Decision Optimizer/OptQuest with Crystal BallDownload
Oracle Crystal Ball Demo TourSee how Crystal Ball is used to build quick and powerful models in Excel.Download
Time Series Forecasting with CrystalBall PredictorHow to use the Predictor add-in to quickly perform time series forecasting using 8 different methods.Download
New Horizons in Predictive ModelingPerspectives on how predictive modeling with Crystal Ball can impact business performance.Download
What is Monte-Carlo Simulation with Crystal Ball?This document provides an overview of Monte Carlo method applied using Oracle Crystal Ball within ExcelDownload

Get results faster, check-out our Crystal Ball Training

 TitleDescription 
Analytics Training and ConsultingAn overview of Technology Partnerz complete array of consulting solutions for Crystal Ball, @Risk, Risk Solver, ModelRisk....Download
Crystal Ball EPM SkillsWorkshop on modeling and implementing Oracle
Crystal Ball EPM Solutions		Download
Finance & Risk Analysis SkillsThis workshop focuses on incorporating and analyzing
risk in financial modelssuch as DuPont,
Black-Scholes, Discounted Cash-Flows...		Download
Professional Analytics SkillsLearn Monte Carlo simulation and Optimization. Build
accurate predictive models in 3 key areas: Finance,
Operation and Project Management		Download
Project Planning
& Estimating Skills		Incorporate cutting edge simulation and optimization
techniques into your project plans and portfolios.		Download
Quality & Engineering SkillsLearn and apply simulation and optimization
techniquesused in quality, design and production
engineering projects.		Download

Need assistance with your project or model now?


Try our remote consulting services with a free 20min consultation


Need help with your project? Give us a call at 1-888-879-8440 Live GoToMeeting for one-on-one training and support

Our professional analytics consultants provide on-line help as well as ad-hoc support and problem solving to your business team when you need it. Through application sharing and conference calls, we can provide both business/software consulting and training to solve problems quickly and cost-effectively.

Remote consulting packages for problem solving and end-user training are available in 1 to 100 hour blocks and can be purchased on-line. Essentially we outline the need or the problem to be solved and work out a coaching program that can include a mix of R&D/Custom VBA, End-user training, consulting and coaching.

When working remote, we use web conferencing and application sharing to further enhance the learning, exchange and knowledge transfer processes.

Remote Consulting Services

  • Outsourced Simulations and risk analysis of business problems. We create reports detailing the results, customized to your requirements, with ease of presentation to management as a priority.
  • Remote coaching and support for model building, simulation and problem solving
  • VBA and Excel Application Development
  • Audits and model reviews to ensure accuracy as well as find errors, inaccuracies and missed opportunities
  • Qualitative and quantitative risk analysis of complex business problems (Project Management Risk, Operational Risk, Information Security Risk)

Technology Partnerz Ltd. provides support for the following leading technology vendors :


For more information, please call us at 1-888-879-8440 or email-us at [email protected]