Course Highlights
  • Government Certification
  • Certification valid for life
  • Lifelong e-learning access
  • Learning Hours: 18 hrs
  • Life Time Job Support
  • Job Profile Tagging
Curriculum

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

4 Topics
Excel Formulas
Excel Functions
Spreadsheet Add-Ins
Spreadsheet Modeling

5 Topics
Data Visualization
Data Queries
Summarizing Data
Frequency Distributions
PivotTables and Pivot Charts

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

4 Topics
Probability Basics
Discrete Probability Distributions
Continuous Probability Distributions
Distribution Fitting

7 Topics
Sampling Methods
Statistical Sampling
Sampling Distributions
Estimation
Interval Estimates
Confidence Intervals
Prediction Intervals

4 Topics
Hypothesis Testing
One-Sample Hypothesis Tests
Two-Sample Hypothesis Tests
ANOVA

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

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

3 Topics
Qualitative and Judgmental Forecasting
Statistical Forecasting Models
Time Series Forecasting Models

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

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

4 Topics
Building Linear Optimization Models
Excel Solver
Optimization Models for Prediction and Insight
Applications of Linear Optimization

3 Topics
Solving with General Integer Variables
Integer Optimization Models with Binary Variables
Mixed-Integer Optimization Models

3 Topics
Modeling and Solving Nonlinear Optimization Problems
Quadratic Optimization
Spreadsheet Models

2 Topics
Stochastic Programming
Risk Analysis in Optimization

3 Topics
Decisions with Uncertain Information
Decision Trees
The Value of Information

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

  Write a Review

Certified Business Analytics Professional

Go to Paid Course