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.
Course Offerings
51 lecture topics
Live video interaction
Interactive discussion forum
11+ course files
Special Add-ons (Free with Course)
Certificate
Course Completion Certificate *Important: Course Completion Certificate will be awarded by UpSkillCareer Certificate will be awarded only after completion of all video lectures and the Final Exam
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
V
Hypothesis Testing
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
VI
Multiple Regression
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
VII
Logistic Regression
34
Logistic Regression Concepts Part 1
11:16
35
Logistic Regression Concepts Part 2
18:20
VIII
Segmentation
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
X
Assignment Solutions
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
Course Eligibility
Any Individual who is interested in pursuing their career in Analytics can take this course. No prior knowledge of analytics is required since the course covers the fundamentals. The tools used during the course are Excel and SAS for key Statistical concepts.
This online training course is meticulously designed to provide a comprehensive understanding of Basic SAS Programming. The course begins with the emphasis on the features and capabilities of SAS. It covers concepts required to perform day to day work in the professional world.
It covers topics on reading data from various sources to creating datasets, data step processing, data manipulation, creating reports using SAS procedures, performing descriptive statistics and combining datasets.It also covers advanced topics like usage of SQL and macros in SAS.
SAS University Edition is used during the course to explain the concepts. Hands-on experience is guaranteed as various concepts are shown throughout the course.
Course Offerings
58 lecture topics
Live video interaction
Interactive discussion forum
Special Add-ons (Free with Course)
Certificate
Course Completion Certificate *Important: Course Completion Certificate will be awarded by UpSkillCareer Certificate will be awarded only after completion of all video lectures and the Final Exam
Demo - Conditional Processing -If Else, If Else If
04:28
27
Demo- Subsetting datasets-IF, WHERE
06:56
28
Demo - PROC SORT
09:08
VIII
Enhancing Your Output with ODS
29
Using ODS Statements to Create outputs
05:53
30
Demo - Using ODS statements
05:15
IX
Using SAS Functions
31
Character functions
12:50
32
Numeric & Date functions, Put & Input functions
11:25
33
Demo - Character functions
10:27
34
Demo - Numeric functions
04:31
35
Demo - Date functions
09:38
36
Demo - Input and Put
03:30
X
Modifying and Combining SAS Data Sets
37
Stacking & Interleaving Data Sets using the SET Statement
04:40
38
Using Merge statement
09:04
39
Example on Merge, IN dataset option
08:57
40
One-to-Many merge, Many-to-Many
07:14
41
Demo - SET, Interleave
04:20
42
Demo - One-to-One merge, types of merges, match merge
13:20
43
Demo - One-Many & Many-Many Match merge
05:27
XI
Summarizing Your Data - Procedures
44
Procedures - MEANS, SUMMARY, TABULATE
06:03
45
Demo- Procedure MEANS
08:04
46
Demo- Procedure SUMMARY
05:54
47
Demo- Procedure TABULATE
08:31
XII
Using SQL with in SAS
48
The Simplest SELECT, WHERE, ORDER Statement
10:08
49
SQL Joins
05:10
50
Using Group Functions
06:06
51
Quick Summary
06:29
52
Demo -SELECT, WHERE, ORDER
07:52
53
Demo - GROUP BY, HAVING
05:36
54
Demo - SQL Joins
15:19
XIII
Introduction to SAS Macros
55
Define Macros Variables and Macros
08:51
56
Demo - Define Macro Variables
07:04
57
Demo - Define Macros
07:33
58
Demo - Symput, Symget
04:21
Final Exam - SAS
Course Eligibility
Freshers and experienced professionals who are interested in pursuing a career in Data analysis, Reporting and Analytics. No prior knowledge of programming/SQL is required. It is the entry point to learning SAS programming and is a prerequisite to advanced SAS and analytics courses.
