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
Online Training
- 180 Days access to HD Video Lecture delivered by industry experts
- Interactive Discussion Forum for solving queries.
- Course Completion Certificate
Privilege Membership: A pay-once access-all;subscription membership on ApnaCourse.com
Get access to 141+ courses at USD 3.33. Know More.
ApnaCourse for Teams
- Ideal for multiple participants.
- Single payment option for instant multi user on-boarding.
- Attractive discounts on bulk purchases.
- Option to include white labelled LMS with custom dashboard report.
- Multi course selection available.
Course Overview
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 Curriculum
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
Eligibility Criteria
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. Ratings & Reviews
Mr. Uma Shankar Mohanty
Management Consultant, MaGC
Management Consultant, MaGC
Good
Vijayakrishna Rapaka E
Professor, RGCET Puducherry
Professor, RGCET Puducherry
good course and excellent lecture
Mr. Abrar Iqbal Khalfe
3.5, 3.5
3.5, 3.5
Ok
Mr. Abrar Iqbal Khalfe
3.5, 3.5
3.5, 3.5
Nice
BATCHU SRIKAR
AIX Administrator, IBM India Pvt. Ltd.
AIX Administrator, IBM India Pvt. Ltd.
Good One
See More.....
CHANAKYA PALLEM
Student, Andhra University
Student, Andhra University
The course content and the faculty classes are good enough to enjoy the online class with a blend of nice examples
D SURESH
Assistant Professor/SAP PS Freelancer, Kongu Engineering College
Assistant Professor/SAP PS Freelancer, Kongu Engineering College
Excellent
Sri lalitha
It's a great course
Devavarna
grt doing this course...enjoyed and learnt a lot
