This online training course is meticulously designed to provide a comprehensive understanding of Business Analytics. The course begins with the emphasis on the Importance of Analytics and moves onto introducing basic Statistical concepts & Data visualizations using Excel. Later, advanced topics such as Correlation, Linear/Logistic Regression, Segmentation and Time Series Analysis are thoroughly discussed with Case-studies & exercises.
Hands-on Analytics experience is guaranteed as we solve various Case-studies, Exercises and Assignments throughout the course.
Curriculum
I
Introduction to Business Analytics
| 1 |
Introduction to course, Course Objective and Overview of Topics
|
11:11
|
| 2 |
What is Analytics, Benefits from Analytics Preview
|
13:07
|
| 3 |
Analytics vs Reporting, Analytics Use Cases Part 1
|
16:55
|
| 4 |
Analytics vs Reporting, Analytics Use Cases Part 2
|
15:45
|
| 5 |
Listen from Experts on Analytics
|
07:16
|
| 6 |
Analytics Case Studies Part 1
|
09:29
|
| 7 |
Analytics Case Studies Part 2
|
17:10
|
| 8 |
Analytics Emerging Trends (Big Data)
|
08:35
|
| 9 |
Career in Analytics
|
05:25
|
II
Statistics for Business Analytics
| 10 |
Introduction to Statistics
|
06:40
|
| 11 |
Population and Sample, Descriptive and Inferential Statistics
|
15:53
|
| 12 |
Central Tendency and Dispersion Measures Part 1
|
18:09
|
| 13 |
Central Tendency and Dispersion Measures Part 2
|
20:48
|
| 14 |
Exercises using Excel
|
09:05
|
| 15 |
Distributions (Normal, Skewed and Uniform)
|
15:42
|
III
Organizing and Graphing Data
| 16 |
Excel Graphs with Exercises Part 1
|
10:10
|
| 17 |
Excel Graphs with Exercises Part 2
|
13:40
|
| 18 |
Assignments 1 and 2
|
06:36
|
| |
Assignment 1-2 Questions
|
|
| 19 |
Excel Pivots Part 1
|
16:55
|
| 20 |
Excel Pivots Part 2
|
19:13
|
| 21 |
Assignment 3
|
04:10
|
| |
Assignment 3 Questions
|
|
IV
Correlation and Regression
| 22 |
Correlation Concepts and Exercises Part 1
|
18:12
|
| 23 |
Correlation Concepts and Exercises Part 2
|
20:00
|
| 24 |
Regression Concepts and Exercises Part 1
|
21:23
|
| 25 |
Regression Concepts and Exercises Part 2
|
16:09
|
| 26 |
Assignments 4 and 5
|
01:48
|
| |
Assignment 4-5 Questions
|
|
| 27 |
Re-cap concepts of Dispersion
|
18:16
|
| 28 |
Hypothesis Testing Concepts with Examples Part 1
|
14:41
|
| 29 |
Hypothesis Testing Concepts with Examples Part 2
|
20:13
|
| 30 |
Multiple Regression through Exercises Part 1
|
16:11
|
| 31 |
Multiple Regression through Exercises Part 2
|
15:51
|
| 32 |
Multicollinearity Concept & its impact
|
19:20
|
| 33 |
Assignment 6
|
01:35
|
| |
Assignment 6 Questions
|
|
| 34 |
Logistic Regression Concepts Part 1
|
11:16
|
| 35 |
Logistic Regression Concepts Part 2
|
18:20
|
| 36 |
Introduction to Segmentation
|
13:35
|
| 37 |
Segmentation Techniques (Cluster Analysis) Part 1
|
21:10
|
| 38 |
Segmentation Techniques (Cluster Analysis) Part 2
|
18:17
|
| 39 |
Segmentation Techniques (Decision Tree)
|
14:43
|
IX
Time Series Analysis and Forecasting
| 40 |
Introduction to Time Series
|
21:15
|
| 41 |
Forecasting Techniques - Moving Average & Exponential Smoothing Part 1
|
23:07
|
| 42 |
Forecasting Techniques - Moving Average & Exponential Smoothing Part 2
|
10:56
|
| 43 |
Forecasting Techniques - Double and Triple Exponential Smoothing Part 1
|
13:54
|
| 44 |
Forecasting Techniques - Double and Triple Exponential Smoothing Part 2
|
17:09
|
| 45 |
Assignment 1
|
03:52
|
| 46 |
Assignment 2
|
09:55
|
| 47 |
Assignment 3
|
09:03
|
| 48 |
Assignment 4
|
04:29
|
| 49 |
Assignment 5
|
02:50
|
| 50 |
Assignment 6
|
08:55
|
| |
Assignment 1-3 with solutions
|
|
| |
Assignment 4-5 with solutions
|
|
| |
Assignment 6 with solutions
|
|
XI
Excels related to Exercises solved in the class
| 51 |
Excels related to Exercises solved in the class
|
00:05
|
| |
Graphs and Pivot Table - Excercise
|
|
| |
Correlation & Regression - Exercise
|
|
| |
Multiple Regression and Logistic Regression - Exercise
|
|
| |
Time Series Forecasting - Exercise
|
|
| |
Final Exam - Business Analytics
|
|
