Skip to main content
Help Center
×
How Can I Help?
Help
Micro-credential@USM
ATW115MQ PENGENALAN ANALITIK DATA (INTRODUCTION TO DATA ANALYTICS)
0%
Previous
Course data
General
SINOPSIS KURSUS / COURSE SYNOPSIS
Announcements
Course Mapping- Teaching Plan
WhatsApp's Group - ATW115MQ
Teaching Assessment - Proof of Submission
Teaching Assessment - Proof of Submission
ATW115 MQ COURSEWORK: GROUP PROJECT
GROUP PROJECT Registration
PROJECT BRIEF
PROJECT RUBRIC
Project Cover Template
Midterm Exam
Midterm Exam
COURSEWORK: Group Assignment
Assignment Registration
Assignment Brief
Assignment Rubrics
Assignment Submission
Chapter 1: Introduction to Data Analytics
Module 1: Overview of Data Analytics
Lecture Slides: Overview of Data Analytics
MODULE 2: Types of Data Analytics
Lecture Slides: Types of Data Analytics
Module 3- Impact of Data Analytics across different sectors
Lecture Slides: Impact of Data Analytics Across Sectors
Discussion
Topic 2: Data Analytics Life Cycle
Module 1: Overview of Data Analytics Life Cycle
Lecture Slides: Overview of Data Analytics Life Cycle
Module 2: Key Roles and Advantages of the Data Analytics Life Cycle
Lecture Slides: Key Roles and Advantages of the Data Analytics Life Cycle
Quiz: Data Analytics Life Cycle
Chapter 3: AI for Business Analytics
MODULE 1: Introduction to AI in Data Analytics
Lecture Slide: Introduction to AI in Data Analytics
Module 2: Future trends, Ethical and Strategic Implications
Lecture Slides: Future trends, Ethical and Strategic Implications
Discussion Forum
Chapter 4: Descriptive Statistics I
Module 1- Introduction to Data and Descriptive Statistics
Module 2- Data Organization and Excel Tools
Module 3- Descriptive Measures and Distribution in Excel
Module 3: Lecture Slides:
Dataset
Discussion:
Chapter 5: Descriptive Statistics II
Module 1 Recording: Distributions and Skewness
Module 1 Slides
Dataset
MODULE 2: Advanced Measures of Central Tendency
MODULE 2: Lecture Slides
Module 3: Analyzing Data with Percentiles and Boxplots
Module 3: Lecture Slides
Module 4: Measures of Association (Understanding Relationships in Data)
Module 4: Lecture Slides
Datasets: Module 2,3 and 4
Descriptive Statistics II: Quiz
Chapter 6: Data Visualization
Module 1: Fundamental Visualization Techniques
Lecture Slides
Module 2: Enhanced Charting Technique
Module 2 Slides
Module 3: Advanced Data Visualization
Module 3 Slides
Hands-On Data Visualization Examples for All Modules
Hands-on Exercise:
Hands on answers
Chapter 7: Descriptive Data Mining
Module 1-Fundamentals of Data Mining
Module Slides
Module 2- Clustering Techniques and Distance Metrics
Module Slides
MODULE 3: Advanced Clustering Methods and Evaluation
Module Slides
Class Assessment
Chapter 8: Linear Regression
Module 1: Basics of Linear Regression
Module 1 Slides
Module 2: Practical Applications of Simple Linear Regression
Module 2 Slides
Module 3: Exploring Multiple Linear Regression And advanced Regression Analysis
Module 3 Slides
Chapter 9: Time Series Analysis and Forecasting
MODULE 1: Introduction to Time Series Forecasting
Module 1: Lecture Slides
MODULE 2: Forecasting with Simple Techniques
Module 2: Lecture Slides
Chapter 10: Decision Analysis
MODULE 1: Formulating Decision Problems
Module 1: Lecture Slides
MODULE 2: Decision Making without Probabilities
Final Exam Tips
Final Exam Tips
Tutorial Banner
Tutorial 01 - Basic Excel Skills
Tutorial 01 - Basic Excel Skills
Tutorial 01 - Guidelines
Tutorial 01 - Datasets
01. Enable Analysis Toolpak
02. Excel Formulas
03. Basic Excel Functions (Part 1)
04. Basic Excel Functions (Part 2)
05. Basic Excel Functions (Part 3)
06. Range Names
Video 09 - Measures of Association, and Outliers
Tutorial 02 - Database Analytics I
Tutorial 02 - Database Analytics I
Tutorial 02- Guidelines
Tutorial 02 - Datasets
01. Create Excel Table
02. Table-Based Calculations
03. Sorting Data in Excel
04. Pareto Analysis
05. Filtering Records
06. Advanced Filtering
07. Logical Functions
08. VLOOKUP
09. Combinations of Lookup Functions
Tutorial 03 - Database Analytics II
Tutorial 03 - Database Analytics II
Tutorial 03 - Guidelines
Tutorial 03 - Datasets
01. Create Excel Template
02. Create Form Controls
03. Create Combo Box
04. PivotTable: Display Revenue
05. PivotTable: Explore Value Field Settings
06. PivotTable: Using Slicers
07. Create PivotChart
Tutorial 05- Descriptive Statistical Measures (I)
Tutorial 05 - Guidelines
Tutorial 05 - Datasets
Video 01 - Frequency Distribution for Categorical Data
Video 02 - Relative Frequency Distribution for Categorical Data
Video 03 - Frequency Distribution and Excel Histogram
Video 04 - Grouped Frequency Distribution for Numerical Data
Video 05 - Cumulative Relative Frequencies
Video 06 - Grouped Frequency Distribution using PivotTables
Video 07 - Percentiles
Video 08 - Using Excel Rank and Percentile Tool
Video 09 - Quartiles
Video 10 - Cross Tabulation
Tutorial 06 - Descriptive Statistical Measures (II)
Tutorial 06 - Guidelines
Tutorial 06 - Dataset
Video 01: Find the Mean
Video 02: Find the Median
Video 03: Find the Mode
Video 04: Compute the Midrange
Video 05: Range and Interquartile Range
Video 06: Variance and Standard Deviation
Video 07: z-Scores
Video 08: Skewness
Video 09: Excel Descriptive Statistics Tool
Video 10: Proportion
Video 11: Statistical Measures in PivotTable
Video 12: Covariance
Video 13: Correlation Coefficient
Video 14: Outliers
Tutorial 04 - Data Visualisation
Tutorial 04 - Data Visualisation
Tutorial 04 - Guidelines
Tutorial 04 - Datasets
Video 01 - Column Chart
Video 02 - Line Charts
Video 03 - Pie Chart
Video 04 - Area Chart
Video 05 - Scatter Chart
Video 06 - Bubble Chart
Video 07 - Combination Chart
Video 08 - Radar Chart
Video 09 - Data Bars
Video 10 - Colour Scales
Video 11 - Icon Sets
Video 12 - Sparklines
Tutorial 7 - Trendlines and Regression Analysis
Tutorial 7
Tutorial 07 - Dataset(1)
Video 1 - Investigate Relationships
Video 2 - Regression Line
Video 3 - Least Squares Coefficients
Video 4 - Simple Linear Regression
Video 5 - Multiple Linear Regression
Next
Micro-credential@USM
Side panel
Categories
All categories
SCHOOL OF MANAGEMENT
SCHOOL OF MANAGEMENT/Bachelor of Management in S...
SCHOOL OF MANAGEMENT/Bachelor of Management in S.../Sidang 2024/2025
SCHOOL OF MANAGEMENT/Bachelor of Management in S.../Sidang 2024/2025/Semester I
SCHOOL OF MANAGEMENT/Bachelor of Management in S.../Sidang 2024/2025/Semester II
SCHOOL OF MANAGEMENT/Bachelor of Management in S.../Sidang 2024/2025/KSCP
Home
Teaching Assessment
Library
Website
OPAC
ePerpustakaan
Course Reserve
Reference & Academic Support
Research Data Management
Proquest eBook Central
Open Educational Resources (OER)
Open Science
USM Library TV
Library Guides
ProQuest Dissertations and Theses (PQDT)
Course Search
Log in
Login using USM Identity :
Username
Username
Password
Password
Log in
Micro-credential@USM
Categories
Collapse
Expand
All categories
SCHOOL OF MANAGEMENT
SCHOOL OF MANAGEMENT/Bachelor of Management in S...
SCHOOL OF MANAGEMENT/Bachelor of Management in S.../Sidang 2024/2025
SCHOOL OF MANAGEMENT/Bachelor of Management in S.../Sidang 2024/2025/Semester I
SCHOOL OF MANAGEMENT/Bachelor of Management in S.../Sidang 2024/2025/Semester II
SCHOOL OF MANAGEMENT/Bachelor of Management in S.../Sidang 2024/2025/KSCP
Home
Teaching Assessment
Library
Collapse
Expand
Website
OPAC
ePerpustakaan
Course Reserve
Reference & Academic Support
Research Data Management
Proquest eBook Central
Open Educational Resources (OER)
Open Science
USM Library TV
Library Guides
ProQuest Dissertations and Theses (PQDT)
Course Search
SCHOOL OF MANAGEMENT
Summary
Course info
ATW115MQ PENGENALAN ANALITIK DATA (INTRODUCTION TO DATA ANALYTICS)
Lecturer:
DR. ALDOWAH HANAN AHMAD YAHYA
Skill Level
:
Beginner
