Section 1 : Introduction

Lecture 1 Beginning your data analysis journey 0:52
Lecture 2 What you should know 0:35
Lecture 3 Using the exercise files 0:21

Section 2 : Getting Started with Data Analysis

Lecture 4 Defining data analysis and data analyst 3:1
Lecture 5 Discovering if you are an analyst
Lecture 6 Organizational roles in data 3:5
Lecture 7 Understanding types of data job roles 4:44
Lecture 8 Discovering skills of the data analyst 5:0

Section 3 : Fundamentals of Data Understanding

Lecture 9 Learning to identify data 4:48
Lecture 10 Learning about data fields and types 7:23
Lecture 11 Dealing with the data you don't have 5:42
Lecture 12 Learning syntax 3:37
Lecture 13 Learning basic SQL statements 6:29
Lecture 14 Challenge Reading SQL 0:58
Lecture 15 Solution Reading SQL 1:23

Section 4 : Key Elements to Understand when Starting Data Analysis

Lecture 16 Learning to interpret existing data 3:27
Lecture 17 Finding existing data 3:23
Lecture 18 Cleaning data 2:6
Lecture 19 Understanding data and workflow 5:48
Lecture 20 Understanding joins 0:0
Lecture 21 Working with joins and validation 7:0
Lecture 22 Challenge Products are not categorized 0:42
Lecture 23 Solution Products are not categorized 2:33

Section 5 : Getting Started with a Data Project

Lecture 24 Getting started with data projects 3:12
Lecture 25 Discovering common beginner mistakes 4:12
Lecture 26 Learning Excel datasets 5:57
Lecture 27 Learning database datasets 5:46
Lecture 28 Maintaining original data 7:1
Lecture 29 Understanding truths 3:3

Section 6 : Data Importing, Exporting, and Connections

Lecture 30 Learning about data governance 4:27
Lecture 31 Understanding source data 4:6
Lecture 32 Working with flat files 8:27
Lecture 33 Working with connections 2:9
Lecture 34 Creating datasets for others 7:43

Section 7 : Getting Started with Data Cleaning and Modeling

Lecture 35 Understanding ETL in data 1:56
Lecture 36 Cleaning data using Excel macros
Lecture 37 Cleaning data with Power Query 6:30
Lecture 38 Working with reusable data
Lecture 39 Modeling data with queries
Lecture 40 Modeling data in Power Query 8:34
Lecture 41 Challenge Rename headers in Power Query 0:47
Lecture 42 Solution Rename headers in Power Query 4:11

Section 8 : Applying Common Techniques for All Data Analysts

Lecture 43 Convert data in Power Query 4:4
Lecture 44 Finding and removing duplicates 8:0
Lecture 45 Changing case and replace values 3:37
Lecture 46 Combining data with merge columns 4:22
Lecture 47 Creating logical functions 2:46
Lecture 48 Building aggregate datasets 4:56
Lecture 49 Challenge Count and amounts of products
Lecture 50 Solution Count and amounts of products 3:33