Business Analytics

Course Duration :    60 Hours

Course Fees  :    Rs. 10,520/-

Participant Profile:

• Thorough Understanding of Databases and Complex Queries from Database
• Clearing the “Database Bridge Course”

1. End Objective:
   • Appreciate need of Business Analytics in real life environment
2. Course Outline
   • Statistical Techniques
     • Different types of data
     • Frequency Distributions
     • Measures of central tendency and dispersion
     • Basic Probability
     • Normal Distribution
     • Central Limit Theorem
     • Hypothesis Testing
   • Regression
     • Simple and Multiple Linear Regression
     • R2 and Adj R2
     • ANOVA
     • Interpretation of coefficients
     • Dummy Variables
     • Residual Analysis
     • Outliers
     • Logistic Regression
     • Assumptions
     • Logistic Function
     • Chi-Square
     • 2 Log Likelihood
     • Classification Table
     • Interpreting Coefficients
     • Dependent Variable Prediction
   • Forecasting (Time Series)
     • Time Series vs. Causal Models
     • Moving Average
     • Exponential Smoothing
     • Trend, Seasonality
     • Cyclicity,
     • Causal modeling using linear regression
     • Forecast Accuracy

• Data Mining Techniques
  • Market Basket Analysis
  • Apriori
  • FPGrowth
  • Evaluation Methods: Lift, Kulc, IR, Chi –Square
  • Classification
  • Decision Tree Induction
  • Bayes Methods
  • Rule-Based Classification
  • Model Evaluation and Selection
  • Ensemble Approaches
  • Clustering
  • Partitioning Methods
  • Hierarchical Methods
  • Density-Based Methods
  • Grid-Based Methods
  • Evaluation of Clustering
• Excel Proficiency
  • Formatting of Excel Sheets
  • Use of Excel Formulae Function
  • Advanced Modeling Techniques
  • Data Filter and Sort
  • Charts and Graphs
  • Table formula and Scenario building
  • Lookups
  • pivot tables
• Introduction to R and SAS
  • Reading and writing data in R
  • Vectors, Frames and Subsets
  • Code Writing and R code Debugger
  • Managing and Manipulating Data in SAS
  • Creating Charts in SAS
  • Simple Linear Regression in SAS
  • Multiple Linear Regression in SAS
  • Data Mining in SAS
• Orientation of Big Data and Hadoop
  • Awareness of Big Data and Hadoop
  • Why is it relevant?
  • The four V’s,