• Statistics
• The Research Process
• Initial Observation
• Generate Theory
• Generate Hypotheses
• Data collection to Test Theory

1. What to measure
2. How to Measure

• Analyze data
• Descriptive Statistics: Overview
• Central Tendency
• Measure of variation
• Coefficient of Variation
• Fitting Statistical Models
• Conclusion

• Building statistical models
• Types of statistical models
• Populations and samples
• Simple statistical models
• The mean as a model
• The variance and standard deviation
• Central Limit Theorem
• The standard error
• Confidence Intervals
• Test statistics
• Non-significant results and Significant results:
• One- and two-tailed tests
• Type I and Type II errors
• Effect Sizes
• Statistical power

• Accessing SPSS
• To explore the key windows in SPSS

1. Data editor
2. The viewer
3. The syntax editor

• How to create variables
• Enter Data and adjust the properties of your variables
• How to Load Files and Save
• Opening Excel Files
• Recoding Variables
• Deleting/Inserting a Case or a Column
• Selecting Cases
• Using SPSS Help

• The art of presenting data
• The SPSS Chart Builder

1. Histograms: a good way to spot obvious problems
2. Boxplots (box–whisker diagrams)

• Graphing means: bar charts and error bars

1. Simple bar charts for independent means
2. Clustered bar charts for independent means
3. Simple bar charts for related means
4. Clustered bar charts for related means
5. Clustered bar charts for ‘mixed’ designs

• Line charts
• Graphing relationships: the scatterplot

1. Simple scatterplot
2. Grouped scatterplot
3. Simple and grouped -D scatterplots
4. Matrix scatterplot

• Simple dot plot or density plot
• Drop-line graph
• Editing graphs

• What are assumptions?
• Assumptions of parametric data
• The assumption of normality
• Quantifying normality with numbers
• Exploring groups of data
• Testing whether a distribution is normal
• Kolmogorov–Smirnov test on SPSS

1. Output from the explore procedure
2. Reporting the K–S test

• Testing for homogeneity of variance

1. Levene’s test
2. Reporting Levene’s test

• Correcting problems in the data

1. Dealing with outliers
2. Dealing with non-normality and unequal variances
3. Transforming the data using SPSS

• Looking at relationships
• How do we measure relationships?

1. Covariance
2. Standardization and the correlation coefficient

• The significance of the correlation coefficient
• Confidence intervals for r
• Correlation in SPSS

1. Bivariate correlation
2. Pearson’s correlation coefficient
3. Spearman’s correlation coefficient
4. Kendall’s tau (non-parametric)
5. Biserial and point–biserial correlations
6. Partial correlation
7. The theory behind part and partial correlation
8. Partial correlation using SPSS
9. Semi-partial (or part) correlations

• Comparing correlations
• Comparing independent rs
• dependent rs
• Calculating the effect size
• How to report correlation coefficients

• An introduction to regression
• Some important information about straight lines
• The method of least squares
• Assessing the goodness of fit: sums of squares, R and R2
• Doing simple regression on SPSS

1. Interpreting a simple regression
2. Overall fit of the model
3. Model parameters
4. Using the model

• Multiple regression: the basics

1. An example of a multiple regression model
2. Sums of squares, R and R2
3. Methods of regression
4. How accurate is my regression model?
5. Assessing the regression model, I: diagnostics
6. Assessing the regression model II: generalization

• How to do multiple regression using SPSS

1. Some things to think about before the analysis
2. Main options
3. Statistics
4. Regression plots
5. Saving regression diagnostics
6. Interpreting multiple regression

• Descriptive

1. Summary of model
2. Model parameters
3. Excluded variables
4. Assessing the assumption of no multicollinearity
5. Case wise diagnostics

• Checking assumptions

1. What if I violate an assumption?
2. to report multiple regression

• Dummy coding
• SPSS output for dummy variables

• Background to logistic regression
• What are the principles behind logistic regression?
• Assessing the model: the log-likelihood statistic
• Assessing the model: R and R2

1. The Wald statistic
2. The odds ratio: Exp (B)

• Methods of logistic regression

1. Assumptions
2. Incomplete information from the predictors
3. Complete separation
4. Overdispersion
5. Binary logistic regression
6. The main analysis
7. Method of regression
8. Categorical predictors
9. Obtaining residuals

• Interpreting logistic regression

1. The initial model
2. Step: intervention
3. Listing predicted probabilities
4. Interpreting residuals
5. Calculating the effect size

• How to report logistic regression
• Testing assumptions

1. Testing for linearity of the logit
2. Testing for multicollinearity

• Predicting several categories: multinomial logistic regression
• Running multinomial logistic regression in SPSS

1. Statistics
2. Other options
3. Interpreting the multinomial logistic regression output
4. Reporting the results

• Looking at differences
• A problem with error bar graphs of repeated-measures designs

1. Step: calculate the mean for each participant
2. Step: calculate the grand mean
3. Step: calculate the adjustment factor
4. create adjusted values for each variable

• The t-test
• Rationale for the t-test

1. Assumptions of the t-test
2. The dependent t-test
3. Sampling distributions and the standard error
4. The dependent t-test equation explained
5. The dependent t-test and the assumption of normality
6. Dependent t-tests using SPSS
7. Output from the dependent t-test
8. Calculating the effect size

• Reporting the dependent t-test

1. The independent t-test
2. The independent t-test equation explained
3. The independent t-test using SPSS
4. Output from the independent t-test
5. Calculating the effect size

• Reporting the independent t-test
• Between groups or repeated measures?
• The t-test as a general linear model

• The theory behind ANOVA
• Inflated error rates
• Interpreting f-test
• ANOVA as regression

1. Logic of the f-ratio
2. Total sum of squares (SST)
3. Model sum of squares (SSM)
4. Residual sum of squares (SSR)
5. Mean squares
6. The f-ratio

• Assumptions of ANOVA
• Planned contrasts
• Post hoc procedure
• Running one-way ANOVA on SPSS
• Planned comparisons using SPSS
• Post hoc tests in SPSS

1. Output from one-way ANOVA
2. Output for the main analysis
3. Output for planned comparisons
4. Output for post hoc tests
5. Calculating the effect size
6. Reporting results from one-way independent ANOVA
7. Violations of assumptions in one-way independent ANOVA

• Analyzing categorical data
• Theory of analyzing categorical data

1. Pearson’s chi-square test
2. Fisher’s exact test

• The likelihood ratio
• Yates’ correction
• Assumptions of the chi-square test
• Doing chi-square on SPSS

1. Running the analysis
2. Output for the chi-square test
3. Breaking down a significant chi-square test with standardized residuals
4. Calculating an effect size

• Reporting the results of chi-square

• What is QlikSense?
• Comparing Qlik Sense Desktop with Qlik Sense
• Installing Qlik Sense Desktop
• How Qlik Sense varies from QlikView?
• Starting with QlikSense Desktop
• Opening an app with QlikSense
• QlikSense Architecture

• Navigating in the user interface
• Data Manager
• Data Load Editor
• Data Model Viewer
• Interacting with the user interface
• Creating apps and Visualizations
• Structuring an app with Sheets

• Different type of Visualizations
• Dimensions and Measures in a CHART
• When to use and What Chart to Use
• Selections in a Visualization
• Settings and Properties of each Visualization

• Expressions, Functions and Variables
• Working with Expression Editor
• Using Functions in Charts
• Using Variables in Expressions
• Set Analysis and Set Expressions
• Working with Master Items

• Adding data from files and databases
• Loading data with the data load script
• Data Connections
• Various types of Data loads
• Profile Data with QlikSense
• Troubleshooting

• Qlik Sense Data Architecture
• Creating Star and Snowflake schemas
• Use of Joins, Keeps, Concatenate etc.
• Understanding QVD layer
• Working on synthetic keys and circular references.

• Qlik Sense Star Schema
• Link Table
• Dimensions Table
• Master Calendar
• Optimizing data models
• Best Practices of Data Modelling

• Data Storytelling
• Publishing
• Exporting and Printing
• Advanced Scripting and Chart Functions
• Qlik Tips and Techniques

• Learning about Qlik Sense App and its security features
• Providing Qlik Sense access to user sets
• Qlik Sense Security rule code

• Introduction about PPM Concepts
• Project, Program and portfolio
• About Primavera P6
• Primavera P6 Professional GUI

• Creation of Project in Primavera and Project settings
• Calendar
• WBS
• Activities

• Relationships/Logics
• Critical path method as a scheduling tool
• DCMA Analysis
• Constraints and codes

• Roles and Resource
• Resource Assignment
• Resource analysis and resource leveling
• Setting up Baseline

• Updating Project, Automatic and manual update
• Monitoring and controlling using EVA
• Generating reports in Primavera, tabular and graphical reports
• Miscellaneous: Global change, UDF, top down estimation, P6
• visualizer, reflection.

• Building Blocks of Golden Gate
• Manager
• Extract(Capture)
• Datapump(Routing)
• Replicate(Delivery)
• Trails (Extract) Files
• Checkpoints – Detailed explanation of checkpoints
• Collector (Server collector)
• Data Source
• Groups
• Transformation

Preparation & Installation of GG S/W on Source Server

• Very Important pre-requisites on Source DB
• Installing OGG S/W on Source Server
• Creating of working /mandatory directories
• Verifying DB connectivity from GG S/W

Preparation & Installation of GG on Target server

• Very Important Pre-requisites on Target DB
• Installing OGG S/W on Target Server
• Creating of working /mandatory directories
• Verifying DB connectivity from GG S/W

• Reports (.rpt)
• Parameters (.prm)
• Stdout (.out)
• Replicate checkpoints (.cpr)
• Extract checkpoints (.cpe)
• Process Status (.pcs)
• SQL Scripts (.sql)
• Database Definitions (.def)

• Memory Requirements
• Disk Requirements
• Storage for Oracle Golden Gate Trails
• To estimate required trail space
• Temporary Disk requirements
• Network
• Operating System Privileges

• Checkpoint table
• Configuring the Manager Process
• Describing the Manager Parameters
• Starting the Manager Process

• Describing the Extract process
• Explaining Extract checkpoints
• Extract Creation on source side
• Adding Extract on GG Interface
• Adding remote trail at GG Interface on source side
• Registering Extract at GG Interface on source side
• Starting Extract process
• Describing GGSCI commands
• Describing Extract trails and files
• Configuring Replicate on target side

1. Describing the Replicate process
2. Explaining Replicate checkpoints
3. Replicate Creation on target side
4. Adding Replicate on GG Interface
5. Starting replicate process on target side

• Observing Unidirectional Replication

1. Describing GGSCI commands
2. Describing Extract trails and files

Extract Configuration on Source side

• Describing the Extract process
• Explaining Extract Checkpoints
• Extract Creation on Source side
• Adding Extract on GG Interface
• Registering Extract at GG Interface on source side
• Adding local trail at GG Interface on source side
• Starting an Extract process
• Describing GGSCI commands
• Describing Extract trails and files

Datapump (Secondary Extract-Optional) Configuration on Source side

• Describing the Datapump process
• Explaining Datapump checkpoints
• Datapump Creation on source side
• Adding Datapump on GG Interface
• Adding remote trail at GG Interface on source side
• Starting Datapump process
• Describing GGSCI commands
• Describing Extract trails and files

Configuring Replicate target side

• Describing the Replicate process
• Explaining Replicate Checkpoints
• Replicate Creation on target side
• Adding Replicate on GG Interface
• Starting replicate processes on target side

Observing Unidirectional Replication

• Describing GGSCI Commands
• Describing Extract trails and files

• Instantiation through Initial Load (table level)
• Instantiation through exp & Imp (Schema/table)
• Instantiation through RMAN cloning (FULL DB)

• Importance of Discard file
• Overview of Data Definition File
• When to use Data Definition File
• Configuring Data Definition File

• Overview of Integrated Capture

• Handing Data missing errors on target side
• Handing TCP/IP Errors
• Troubleshooting process startup failures
• Troubleshooting Extract problems
• Troubleshooting missed transactions
• Using the discard file
• Using SHOWSYNTAX to view Replicate SQL statements
• Using the Log dump utility

• SAAS, PAAS and IAAS Overview
• Oracle SCM Cloud Capabilities: Overview
• Navigation Basics
• Resources

• Implementation Planning
• Roles and Responsibilities
• Offerings
• Implementation Considerations
• SCM Simplified Setup: Overview
• Automated Setup of SCM Common Components
• Simplified Setup: Time Savings
• Best Practices

• Walkthrough on Enterprise Structure
• Differentiate E-Business Suite and Cloud Org Structure
• Business Unit Overview
• Business Unit Implementation

• Introduction to Product Hub

  • Features of Product Hub
  • Key benefits of using Product Hub
  • Product Hub functionality architecture
  • Basics of navigation in Fusion Applications interface

• Functional overview of Functional Setup Manager
• Roles and responsibilities
• Implementing a Product Hub offering using Functional Setup Manager

• Creating item organizations
• Item class concepts
• Creating item classes

• Item terminologies
• Item setup tasks
• Creating items
• Implementing item relationships

• Item attributes
• Defining and assigning EFF attribute groups

• Overview of catalogs and categories
• Creating and publishing catalogs

• Item Mass update functionality
• Item class updated through excel

• Overview of structures
• Creating a product structure
• Overview of packs
• Creating a pack

• Overview of new item requests
• Configuring new item requests
• Creating and managing new item requests
• Change Order Approval Workflows

• Overview of item rules concepts
• Creating item rules

• Inventory Overview

  • How Inventory Fits into Oracle’s SCM Cloud Offering
  • Oracle’s SCM Cloud Progress
  • Oracle Inventory Management Cloud Capabilities: Overview

• Inventory Transaction Uses
• Inventory Transaction Sources and Types
• System- and User-defined Inventory Transaction Types
• Inventory Transaction Setup Tasks
• Inventory Transaction Profile Options

• Lot Control: Overview
• Lot Control Organization Parameters
• Lot Control Item Attributes
• Lot Management
• Serial Number Control
• Lot and Serial Number Control Profile Options

• On-Hand Quantity and Availability
• Manage Item Quantities Page
• Reservations

• Receiving: Overview
• Receipt Routing
• Receipt Processing Methods
• Expected Receipts
• Receipt Structure
• Returns and Corrections
• Additional Receiving Features
• Receiving Parameters

• Inventory Transactions: Overview
• Miscellaneous Transactions
• Sub inventory Transfers
• Movement Requests – Approval check
• Direct and In-Transit Inter-organization Transfers

• Explain Min-Max Planning
• Min-Max Planning Report Parameters: Points to Consider
• Min-Max Planning Replenishment Quantities: How They Are Calculated

• Cycle Counting: Explained
• ABC Analysis
• Create and Manage Cycle Counts
• Generate Count Schedules
• Generate Count Sequences

• Analyze Materials Management and Logistics Performance
• Monitor Warehouse Operations Dashboard

• Overview of Cost Management
• Cost Planning

• Creation of Cost Organization
• Creation of Cost books and Valuation Structure
• Manage Cost Elements and Cost Profile
• Demo on Costing method

• Procurement Application Overview

  • Explain Procurement architecture and components
  • Explain simplified Procure to Pay flow
  • Explain Procurement applications integration

• identify common procurement tasks
• Configure required common procurement tasks
• Identify common purchasing tasks
• Configure required common purchasing tasks

• Explain purpose and use of Supplier Model within Fusion Procurement
• List the benefits provided to suppliers by Fusion Supplier Portal
• Explain the methods available for registering suppliers
• Identify the job roles available to the supplier self-service administrator to provision
• Implement Supplier Model and Supplier Portal

• Understand the approval management workflow
• Set up approval management
• Understand approval policy configuration
• Describe steps for defining approval groups
• Manage, edit, and deploy approval rules
• Create approval rule conditions

• Identify common procurement tasks
• Configure required common procurement tasks
• Identify common purchasing tasks
• Configure required common purchasing tasks

• Understand the basics of requisition management
• Manage requisitions
• Create and modify approved orders

• Understand the components and use of purchase orders
• Create purchase orders
• Maintain purchase orders
• Understand setup options related to purchase orders

• Identify Self Service Procurement setup tasks and profile options
• Manage value sets and descriptive flex fields for information templates
• Create, manage, and secure catalogs
• Understand Supplier Content Map Sets
• Create local and informational catalogs
• Create and manage public shopping lists
• Create and manage smart forms
• Understand content zones

• Course Introduction

  • Oracle Order-to-Cash Cloud Overview
  • Demo with a Standard Order – O2C Cycle
  • Demo with Return Order

• Pricing Strategies
• Price Lists
• Discount Lists
• Shipping Charge Lists

• Global Order Promising
• Order Promising Rules
• Key Order Promising Functionality
• Data Collection and Global Order Promising Administration

• Defining Orchestration
• Managing Orchestration Statuses
• Change Management and Process Assignment
• Orchestration Process Planning, Deployment, and Jeopardy
• Defining Processing Constraints and Hold Codes

• Introduction to Shipping
• Shipping – Basic Setup
• Pick Wave Management
• Pick Confirmation
• Ship Confirm

• Explain Reporting and Business Intelligence for SCM
• Configure OTBI, RTF Templates for Trading documents, Dashboard metrics