Certified Business Analytics Professional

TABLE OF CONTENT

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
• Summarizing Data
• Frequency Distributions
• PivotTables and Pivot Charts

Descriptive Statistical Measures

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

Probability Distributions

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

Sampling and Estimation

• Sampling Methods
• Statistical Sampling
• Sampling Distributions
• Estimation
• Interval Estimates
• Confidence Intervals
• Prediction Intervals

Statistical Inference

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

Predictive Modeling

• Logic-Driven Model
• 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
• Time Series Forecasting Models

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 Solver
• 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

• Stochastic Programming
• Risk Analysis in Optimization

Decision Analysis

• Decisions with Uncertain Information
• Decision Trees
• The Value of Information

R Programming Language

• Objects and Arithmetic
• Summaries and Subscripting
• Matrices
• Attaching to objects
• Statistical Computation and Simulation
• Graphics

Additional Course Videos