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

 

Apply for Certification

https://www.vskills.in/certification/Management/Business-Analytics-Professional