Course Module

Data Analysis

Course Module

Module 1: Introduction to Data Analytics

Module 1: Lesson 1: What is Data Analysis?

Module 1: Lesson 2: The Data Analysis Process

Module 1: Lesson 3: Key Technologies in Data Analysis

Discussion Module 1 - Questions and Answers support during class hours
Module 2: Data Types, Sources, Privacy and Ethics

Module 2: Lesson 1: Understanding Data Types

Module 2: Lesson 2: Common Data Sources

Module 2: Lesson 3: Data Privacy and Ethics in Data Analysis

Discussion Module 2 - Questions and Answers support during class hours
Module 3: Data Cleaning and Preparation

Module 3: Lesson 1: Understanding Data Quality

Module 3: Lesson 2: Data Cleaning Techniques

Module 3: Lesson 3: Data Integration and Preparation

Discussion Module 3 - Questions and Answers support during class hours
Module 4: Advanced Microsoft Excel for Data Analytics

Module 4: Lesson 1: Introduction to Microsoft Excel for Data Analytics

Module 4: Lesson 2: Excel Functions

Module 4: Lesson 3: Excel Formatting

Module 4: Lesson 4: Excel Data Analysis

Module 4: Lesson 5: Table Pivot

Discussion Module 4 - Questions and Answers support during class hours
Module 5: Power BI

Module 5: Lesson 1: Introduction to Data Visualization

Module 5: Lesson 2: Principles of Effective Data Visualization

Module 5: Lesson 3: Tools and Techniques for Data

Discussion Module 5 - Questions and Answers support during class hours
Module 6: Introduction to SQL Database

Module 6: Lesson 1: Introduction to SQL, MySQL and NoSQL

Module 6: Lesson 2: SQL Queries

Module 6: Lesson 3: Data Manipulation and Data Modification

Module 6: Lesson 4: Advanced SQL

Discussion Module 6 - Questions and Answers support during class hours