Summary of ATW115R PENGENALAN ANALITIK DATA (INTRODUCTION TO DATA ANALYTICS)

Contact Us Elearn USM Support Center

Website OPAC ePerpustakaan Course Reserve Reference & Academic Support Research Data Management Proquest eBook Central Open Educational Resources (OER) Open Science USM Library TV

General

Announcements

Webex Link for SECOND class (2nd April)

Teaching Plan

Lecture Groups

Coursework - Project

Registration: Group Project

Project Brief

Project Rubrics

Project Cover Template

Submission: Group Project

COURSEWORK: ASSIGNMENT

Registration: Group Assignment

Assignment Brief

Lecture Materials

Slides - Course Introduction

Slides - Introduction to Business Analytics

Slides - Data Analytics Lifecycle

Slides - AI

Slides - Descriptive Statistics (I)

Slides - Descriptive Statistics (II)

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 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 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