Course Syllabus
Introduction to Business Analytics
1.1. What is Business Analytics
1.2. Evolution of Business Analytics
1.3. Scope of Business Analytics
1.4. Data for Business Analytics
1.5. Models in Business Analytics
1.6. Problem Solving with Analytics
Analytics on Spreadsheets
2.1. Basic Excel Skills
2.2. Excel Functions
2.3. Using Excel Lookup Functions for Database Queries
2.4. Spreadsheet Add-Ins for Business Analytics
Data Visualization and Exploration
3.1. Pivot Tables
3.2. Creating Charts Using Tableau
3.3. Data Queries
3.4. Statistical Methods for Summarizing Data
Descriptive Statistical Measures
4.1. Populations and Samples
4.2. Measures of Central Tendency
4.3. Measures of Dispersion
4.4. Measures of Shape
4.5. Excel Descriptive Statistics Tool (Application by Using Excel)
4.6. Outliers
4.7. Statistical Thinking in Business Decision
Statistical Inference
5.1 Hypothesis Testing
One-Sample Hypothesis Tests (mean and proportion)
Hypothesis Development
Type I error and Type II error
z-statistic, t-statistic
One-Tailed and Two-Tailed test (critical value and p-value methods)
Two-Sample Hypothesis Tests
Hypothesis Development
z-statistic, t-statistic
Two-sample test for means, σ^2 known
Two-sample test for means, σ^2 unknown
Two-sample test for means, σ^2 unknown, assumed equal
Paired samples
5.2 ANOVA
Hypothesis Development
F-statistic
5.3 Chi-Square Test for Independence
Hypothesis Development
Computing Expected Frequencies
Conducting the Chi-Square Test
Regression Analysis
6.1. Modeling Relationships and Trends in Data
6.2. Simple Linear Regression
6.3. Multiple Linear Regression
Forecasting Techniques
7.1. Qualitative and Judgmental Forecasting
7.2. Statistical Forecasting Models
7.3. Forecasting Models for Stationary Time Series
7.4. Forecasting Models for Time Series with a Linear Trend
Introduction to Data Mining
8.1 The Scope of Data Mining
1.1. What is Business Analytics
1.2. Evolution of Business Analytics
1.3. Scope of Business Analytics
1.4. Data for Business Analytics
1.5. Models in Business Analytics
1.6. Problem Solving with Analytics
Analytics on Spreadsheets
2.1. Basic Excel Skills
2.2. Excel Functions
2.3. Using Excel Lookup Functions for Database Queries
2.4. Spreadsheet Add-Ins for Business Analytics
Data Visualization and Exploration
3.1. Pivot Tables
3.2. Creating Charts Using Tableau
3.3. Data Queries
3.4. Statistical Methods for Summarizing Data
Descriptive Statistical Measures
4.1. Populations and Samples
4.2. Measures of Central Tendency
4.3. Measures of Dispersion
4.4. Measures of Shape
4.5. Excel Descriptive Statistics Tool (Application by Using Excel)
4.6. Outliers
4.7. Statistical Thinking in Business Decision
Statistical Inference
5.1 Hypothesis Testing
One-Sample Hypothesis Tests (mean and proportion)
Hypothesis Development
Type I error and Type II error
z-statistic, t-statistic
One-Tailed and Two-Tailed test (critical value and p-value methods)
Two-Sample Hypothesis Tests
Hypothesis Development
z-statistic, t-statistic
Two-sample test for means, σ^2 known
Two-sample test for means, σ^2 unknown
Two-sample test for means, σ^2 unknown, assumed equal
Paired samples
5.2 ANOVA
Hypothesis Development
F-statistic
5.3 Chi-Square Test for Independence
Hypothesis Development
Computing Expected Frequencies
Conducting the Chi-Square Test
Regression Analysis
6.1. Modeling Relationships and Trends in Data
6.2. Simple Linear Regression
6.3. Multiple Linear Regression
Forecasting Techniques
7.1. Qualitative and Judgmental Forecasting
7.2. Statistical Forecasting Models
7.3. Forecasting Models for Stationary Time Series
7.4. Forecasting Models for Time Series with a Linear Trend
Introduction to Data Mining
8.1 The Scope of Data Mining
Frequently Asked Questions
Q1 : When can I joining the course?
A1 : Our course at online and self-paced so you can start at any time.
A1 : Our course at online and self-paced so you can start at any time.