Certified Business Analytics Professional

Introduction

• Evolution and Scope
• Data for Business Analytics
• Decision Models
• Problem Solving and Decision Making

Analytics and Spreadsheets

• Excel Formulas
• Excel Functions
• Spreadsheet Add-Ins
• Spreadsheet Modeling

Visualizing Data

• Data Visualization
• Data Queries
• Statistical Methods for Summarizing Data
• Frequency Distributions
• PivotTables and Pivot Charts

Descriptive Statistical Measures

• Statistical Notation
• Measures of Location
• Measures of Dispersion
• Measures of Shape
• Excel Descriptive Statistics Tool
• Measures of Association

Probability Distributions

• Probability Basics
• Discrete Probability Distributions
• Continuous Probability Distributions
• Random Sampling
• Distribution Fitting

Sampling and Estimation

• Statistical Sampling
• Sampling Distributions
• Interval Estimates
• Confidence Intervals
• Confidence Intervals and Decision Making
• Prediction Intervals

Statistical Inference

• Hypothesis Testing
• One-Sample Hypothesis Tests
• Two-Sample Hypothesis Tests
• ANOVA

Predictive Modeling

• Logic-Driven Modeling
• Data-Driven Modeling
• Analyzing Uncertainty and Model Assumptions
• Risk Solver Platform

Regression Analysis

• Simple Linear Regression
• Residual Analysis and Regression Assumptions
• Multiple Linear Regression
• Regression with Categorical Independent Variables
• Regression Models with Nonlinear Terms

Forecasting Techniques

• Qualitative and Judgmental Forecasting
• Statistical Forecasting Models
• Forecasting Models for Time Series with a Linear Trend
• Forecasting Time Series with Seasonality

Simulation and Risk Analysis

• Monte Carlo Simulation
• New-Product Development Model
• Newsvendor Model
• Overbooking Model
• Cash Budget Model

Data Mining

• Data Mining Basics
• Cluster Analysis
• Classification
• Association Rule Mining
• Cause-and-Effect Modeling

Linear Optimization

• Building Linear Optimization Models
• Excel Functions
• Solver and Outcomes
• Optimization Models for Prediction and Insight
• Applications of Linear Optimization

Integer Optimization

• Solving with General Integer Variables
• Integer Optimization Models with Binary Variables
• Mixed-Integer Optimization Models

Nonlinear and Non-Smooth Optimization

• Modeling and Solving Nonlinear Optimization Problems
• Quadratic Optimization
• Spreadsheet Models

Optimization Models with Uncertainty

• Risk Analysis in Optimization
• Optimizing Monte Carlo Simulation Models
• Simulation Optimization Using Risk Solver

Decision Analysis

• Decisions with Uncertain Information
• Decision Trees
• The Value of Information
• Utility and Decision Making