• We are available for any custom works this month
  • Main office: Springville center X264, Park Ave S.01
  • Call us (123) 456-7890 - (123) 555-7891
  
  
  

Course Info

About this Course

This course provides an introduction to the field of business analytics, which has been defined as the extensive use of data i.e., statistical and quantitative analysis, descriptive, predictive, and prescriptive models. The use of Excel and Tableau as analytic and visualization tools to support business analytics is discussed. Moreover, the application of selected data mining techniques to business decision-making situations is also illustrated. Students actively participate in the delivery of this course through case, problem-based learning, and project presentations.

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

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.