课程信息 | ARCHIVE for POB30203 - BUSINESS ANALYTICS

首页 Search Courses CIDEX Open Courses Online Guide (Lecturer) Online Guide (Student)

🌟 Welcome to Your New UniKL VLE ! 🌟 We’ve made these improvements to ensure your learning experience is engaging, flexible, and more enjoyable than ever! 🎉

ARCHIVE for POB30203 - BUSINESS ANALYTICS

教师: KoshyGeorge Samuel

Skill Level: Beginner

常规

Announcements

Course Content and Course Learning Plan

Course Content

Course Learning Plan

Table of Specification (TOS)

Excel Notes

Excel Functions

Excel Functions

Cleaning Data

Tables, Pivot Tables and Pivot Charts

Lecture Slides

1. Introduction to Business Analytics

2. Problem Solving Methodology

3. Descriptive Statistics : Qualitative and Quantitative Data

3a_Exercises for Descriptive Statistics

4 .Predictive Analytics

4a: Exercises for Predictive Analytics

5. Prescriptive Analytics : Linear Programming

6. Prescriptive Analytics : Decision Making

6a : Exercise for Decision Making

6b: Decision Making Tutorial

Learning Activities

Use of Data Analytics

Basic Excel Formulas

The need for forecasting in business

Group Assignment ( Sem July 2026 ) 10 marks

Group Assignment Worksheet

Group Assignment

HW

HW1: Chapter 1 : Introduction to Data Analytics

HW1

HW2 : Chapter 2 _ Problem Solving Methodology

HW2

HW3 : Excel : Cash Flow Projection with What If Analysis and Goal Seek

HW3

HW4 Excel Functions

HW4 Excel Functions

HW5 : Descriptive Analytics : Categorical and Continuous Data

HW5

HW6 : Predictive Analytics : Regression Equation

HW6

HW7 Predictive Analytics : Forecasting

HW7

HW8 : Prescriptive Analytics : Linear Programming

HW8

HW9 : Decision Making

HW9

HW10 : Tables and Dashboards

HW10

TEST 1: 10 Marks

Test 1 (August 2026_Short Sem) (RESIT)

Sem Aug 2026 (Short Sem) : Test 2

Test 2 : August 2026 (Short Sem)

Test 2 Question

Group Assignment

ARCHIVE for POB30203 - BUSINESS ANALYTICS