By July 31, 2015 0 Comments Read More →

CRYSTAL BALL

CRYSTAL BALL

Bandung | 24 – 27 August 2015 | Rp 7.950.000/person
Bandung | 14 – 17 September 2015 | Rp 7.950.000/person
Bandung | 19 – 22 October 2015 | Rp 7.950.000/person
Bandung | 16 – 19 November 2015 | Rp 7.950.000/person
Bandung | 30 Nov – 03 December 2015 | Rp 7.950.000/person

 

 

TRAINING OVERVIEW CRYSTAL BALL:

In this course, you will learn to perform spreadsheet modeling and analysis using Crystal Ball Standard Edition. You will learn 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 understanding the best ways to present findings to peers, management, or clients. You will learn to develop advanced Crystal Ball models, expedite the model-building process, and apply the analytical tools of Crystal Ball Professional Edition. You will cover advanced topics, including optimization and time-series forecasting, advanced assumptions, forecast options, and precision controls. The emphasis in the second half of this course is on learning to make optimal decisions by using the combined power of Crystal Ball.


WHATYOU’LL LEARN:

  • Modeling and simulations
  • Start Crystal Ball and access resources
  • Crystal Ball probability distributions
  • Define assumptions
  • Correlate assumptions
  • Analyze and present simulation results
  • Analyze data with Crystal Ball tools
  • Set advanced options for assumptions and forecasts
  • Manipulate simulation controls
  • Optimize decisions with OptQuest and analyze solutions
  • Perform time series forecasting with Predictor

WHO SHOULD ATTEND THIS TRAINIG?:

Business analysts and end users

CRYSTAL BALL TRAINING MATERIAL OUTLINE:

1. Modeling and Simulation

  • Oracle’s Enterprise Performance Management System
  • Model Basics
  • Simulation Basics
  • Monte Carlo Simulations
  • Crystal Ball
  • Model Development Process

2. Getting Started with Crystal Ball

  • Setting Crystal Ball Start Preferences
  • Welcome Dialog Box
  • Basic Crystal Ball Terminology
  • Crystal Ball Ribbon
  • Additional Resources for Crystal Ball

3. Examining Probability Distributions

  • Probability Distributions
  • Basic Distribution Statistics
  • Viewing Distribution Types in the Distribution Gallery
  • Properties of Crystal Ball Distributions
  • Commonly Used Crystal Ball Distributions

4. Assumptions

  • Data-Based Assumptions through Distribution Fittings
  • Data-Based Assumptions with Custom Distributions
  • Expert-Based Assumptions
  • Referencing Cells for Parameter Values

5. Forecasts, Running Simulations, and Analyzing Results

  • Forecasts
  • Running Simulations
  • Analyzing Forecast Charts
  • Viewing Other Charts with Forecast Data
  • Saving and Loading Forecast Results
  • Editing Crystal Ball Data

6. 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

7. Creating Reports

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

8. Determining Assumptions with Tornado and Spider Charts

  • Considering Assumptions
  • Tornado and Spider Charts
  • Tornado Charts Versus Sensitivity Charts
  • Creating Tornado and Spider Charts
  • Examining Tornado Charts
  • Examining Spider Charts

9. Working with Multiple Assumptions

  • Batch Fitting Probability Distributions
  • Correlating Multiple Assumptions with Correlation Matrices

10. 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

11. Setting Advanced Options for Forecasts

  • Automatically Extracting Forecast Statistics
  • Adding Marker Lines to Forecast Charts
  • Fitting Distributions to Forecast Charts
  • Filtering Forecast Results

12. Working with Simulation Controls

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

13. Optimizing Decisions with OptQuest

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

14. Forecasting with Predictor

  • Crystal Ball Predictor
  • Creating Time Series Forecasts
  • Performing Linear Regressions

 

TRAINING INSTRUCTOR CRYSTAL BALL

Ir. Rahmat Priyo Handono, MM.  Lulusan dari  Institut Teknologi Bandung (ITB) jurusan Teknik Industri dan lulusan magister management, strategic marketing dari PPM Jakarta. Beliau sudah sering dan berpengalaman menjadi instruktur training industri di Indonesia untuk bidang industrial tecnology field(seperti  Maintenance, Reliability, Scheduling, Safety & Hazard, Total Quality Management ) dan managerial field(seperti  Smart Attitude, Smart Leadership, Smart Supervisor, Inner Success Motivational Training, Writing Sounds Business Planning). Bapak Ir. Rahmat Priyo Handono, MM. Berpengalaman dalam dunia kerja dan berpengetahuan dalam dunia akademik. Beliau memiliki pengalaman lapangan dan pernah menduduki posisi sebagai production supervisor, business consultant, marketing, marketing manager, marketing director, GA and Finance director, and terakhir sebagai seorang direktur di suatu perusahaan swasta.

VENUE :

Hotel Kagum Group Bandung (Golden Flower, Banana Inn, Amaroossa, Serela, Gino Feruci), Grand Setiabudi, De Java

 

TRAINING DURATION CRYSTAL BALL: 

3 days

TRAINING TIME CRYSTAL BALL:  

  1. 24 Aug 2015-27 Aug 2015
  2. 14 Sep 2015-17 Sep 2015
  3. 19 Oct 2015-22 Oct 2015
  4. 16 Nov 2015-19 Nov 2015
  5. 30 Nov 2015-03 Dec 2015

INVESTMENT PRICE/PERSON :

  1. Rp. 7.950.000/person (full fare) or
  2. Rp. 7.750.000/person (early bird, payment 1 week before training) or
  3. Rp. 7.500.000/person (if there are 3 persons or more from the same company)

FACILITIES FOR PARTICIPANTS :

  1. Training Module
  2. Flash Disk contains training material
  3. Certificate
  4. Stationeries: NoteBook and Ballpoint
  5. T-Shirt
  6. Backpack
  7. Training Photo
  8. Training room with full AC facilities and multimedia
  9. Lunch and twice coffeebreakeveryday of training
  10. Qualified instructor
  11. Transportation for participants from hotel of participants to/from hotel of training (if minimal number of participants from one company is 4 persons)

 

Recommendation:

Participants should bring a laptop for practice session.

Formulir Permintaaan Informasi Lanjutan / Pra-Pendaftaran Public Training
  1. INFORMATION OPTIONS
  2. (required)
  3. (required)
  4. PERSONAL DATA
  5. (required)
  6. (required)
  7. (required)
  8. (valid email required)
  9. (required)
  10. (required)
  11. PRE REGISTRATION DATA (Tidak Mengikat)
  12. (required)
  13. MESSAGE FOR TRAINING PROVIDER
 

cforms contact form by delicious:days

About the Author:

Post a Comment