UNIVERSITI TEKNOLOGI MARA
LESSON PLAN
: MGT555
Course Code
Course Name : Business Analytics
Level : Bachelor Degree
Total SLT : 120
Equivalent to 3 credit
Face-to-Face (F2F): 56
Non Face-to-Face: 0 Guided and 104 Non Guided
Part : 4
Course Status : Core
(Core/Non Core)
Prerequisite : No
Course Learning Outcomes
At the end of the course, students should be able to:
1. Apply the theories, concept and applications of business analytics in supporting
managerial decisions (PLO6, C3)
2. Display skills in using Tableau software and Microsoft Excel in data visualization and
analysis. (PLO2, P2)
3. Demonstrate managerial skills in data-driven business environment. (PLO8, A3)
1
Course Description
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 an 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.
Syllabus Content Hours Remarks
1. Introduction to Business Analytics
1.1. What is Business Analytics 2
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
2. Analytics on Spreadsheets 6
2.1. Basic Excel Skills
• MIN
• MAX
• SUM
• AVERAGE
• COUNT
• COUNTIF
2.2. Excel Functions
• Insert Function
• Logical Functions
o IF
o AND
o OR
2.3. Using Excel Lookup Functions for Database Queries
• VLOOKUP
• HLOOKUP
2.4. Spreadsheet Add-Ins for Business Analytics
• Add-in Analysis Toolpak
3. Data Visualization and Exploration 6
3.1. Pivot Tables
3.2. Creating Charts Using Tableau
3.3. Data Queries
3.4. Statistical Methods for Summarizing Data
4. Descriptive Statistical Measures 6
4.1. Populations and Samples
2
4.2. Measures of Central Tendency
• MEAN
• MEDIAN
• MODE
4.3. Measures of Dispersion
• Range
• Variance
• Standard Deviation
4.4. Measures of Shape
• Skewness
• Kurtosis
4.5. Excel Descriptive Statistics Tool (Application by Using
Excel)
4.6. Outliers
4.7. Statistical Thinking in Business Decision
Individual Assignment 1
Discussion Project Paper 1
5. Statistical Inference 16
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
3
• Conducting the Chi-Square Test
6. Regression Analysis 8
6.1. Modeling Relationships and Trends in Data
6.2. Simple Linear Regression
6.3. Multiple Linear Regression
Discussion on Project Paper 1
7. Forecasting Techniques 6
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
Individual Assignment 2
8. Introduction to Data Mining 2
8.1. The Scope of Data Mining
Test 2
Total 56
Assessment
Test 30%
Individual Assignments
Individual Assignment 1 20%
(500 to 1000 words)
Individual Assignment 2 20%
(500 to 1000 words)
Group Project 30%
Total 100%
Recommended Text
SC Chuah, JS Keshminder. (2019). Introduction to Business Analytics. Pearson.
James R. Evans, (2017). Business Analytics: Methods, Models, and Decisions. Pearson, 2 nd
Edition.
