# Introduction to Data Analytics (ZD-1201)

Bachelor of Digital Science, Universiti Brunei Darussalam, Digital Science, 2022

Students will learn the latest technologies including Tableau and Python in the field of data analytics.

## Contents

• Data Pre-processing: Data Cleaning, Handling Missing Data, Graphical Methods for Identifying Outliers, Measures of Centre and Spread, Data Transformation
• Exploratory Data Analysis: Exploring Categorical and Numeric Variables, Exploring Multivariate Relationships, Deriving New Variables: Flag and Numeric Variables, Using EDA to Investigate Correlated Predictor Variables
• Univariate and Multivariate Statistical Analysis: Descriptive Statistics Measures, Statistical Approaches to Estimation and Prediction, Statistical Inference, Confidence Interval Estimation of the Mean and Proportion, Hypothesis Testing for the Mean and Proportion, Statistical tests (t-Test, Chi-Square, ANOVA), Simple and Multivariate Regression
• Data Visualization: Connecting to data, Dimension and Measure, Filtering and Sorting, Aggregation, Calculated Fields, Symbol Map, Trend Lines, Forecasting, Dashboard and Story
• Case Study using Visualization tool: Apply knowledge on real dataset and create a dashboard to present a story
• Introduction to Programming environment for data analytics: Data Wrangling: Data Gathering, Data Cleaning, Data Assessing, Clustering, Data Visualization: Univariate, Bivariate and Multivariate Exploration
• Case Study: Apply knowledge to real world dataset and create slide deck

# Lectures

## Tableau

Lesson 1 (Jan 11, 2022)Connecting to Data
Visualization - Introduction
Lesson 2 (Jan 13, 2022)Filtering and Sorting
Aggregation
Lesson 3 (Jan 18, 2022):Calculated Fields
Symbol Map
Trend Lines
Forecasting
Dashboard and Story
Project Discussion

## Python Programming

Lesson 4Python setup
Introduction to Python
Lesson 5Introduction to Python (contd…Tuple)
Introduction to Pandas
Lesson 6Introduction to Pandas cont indexing
Data Wrangling
Lesson 7Data Gathering
Data Assessing and Cleaning
Lesson 8Descriptive Statistics
Lesson 9Descriptive Statistics cont EDA
Mean Median Mode
Skewed Distribution
Range, Quartiles and Interquartile Range
Lesson 10Variance and Standard Deviation
Univariate Visualisation
Lesson 11Bivariate Visualization
Multivariate Visualization
Slide deck

## Statistics

Lesson 12Outliers
Normal Distribution
Lesson 13Probability Distributions
Lesson 14Sampling Distributions
Lesson 15Sampling Distributions contd CLT
Lesson 16Sampling Distributions Example
Lesson 17Estimation
Lesson 18Review Estimation
Lesson 19Review Normal Distribution
Lesson 20Test and Revision
Lesson 21Hypothesis Testing
Lesson 22t-Table
t-Tests
Lesson 23t-Tests Examples
Lesson 24Chi-Square Statistic
Lesson 25ANOVA
Lesson 26ANOVA contd
Lesson 27Simple and Multiple Regression
Clustering

## Assessment

• Examination: 30%
• Coursework: 70%
• Two Lab Tests (20%)
• Six Class Tests (30%)
• Project (20%)