Course Content
Introduction
0/8
Introduction to Data Preparation
03:02
Getting Data into Power Query
06:34
Understanding how Power Query works
08:24
Previewing Column Quality for Errors and Empty values
03:37
Previewing number of Unique and Distinct Values with Column Distribution
04:16
Previewing Column Statistical Summaries with Column Profile
03:20
Setting Data Preview Checks for Entire Dataset
01:30
Intro Quiz
Combining Datasets
0/8
Introduction to combining data
01:58
Understanding Append Queries
07:08
What you must know about Append Queries
04:16
Understanding Merge Queries
06:31
Using multiple columns as keys for Merging Queries
08:03
Understanding Join Kinds
04:54
Using the Join Kinds in Power Query
10:16
What you must know about Merge Queries
04:30
Structuring Data in Power Query
0/7
Introduction to Transposing Data
04:12
Transposing Data when there is header row
05:15
Understanding Unpivot Columns
06:40
Unpivoting Columns when there are null values
03:26
Unpivoting Columns without Header Rows
03:38
Understanding Pivot Columns
06:32
Understanding GroupBy
09:21
Creating New Columns in Power Query
0/8
Adding Duplicate and Index Columns
04:39
Adding new columns from a Text Column
04:00
Adding new columns from numbers and date columns
05:08
Adding Conditional Columns (1)
04:19
Adding Conditional Columns (2)
05:59
Adding Custom Columns (1)
06:27
Adding Custom Columns (2)
04:19
Adding columns from example
02:42
Other Power Query Transformations
0/4
Other common column transformations
07:00
Removing Duplicate Records
02:07
Dealing with Cell Errors
08:07
Checking for reasons for Cell Errors
06:40
Cleaning Dirty Data
0/7
Introduction to Data Cleaning
01:47
Cleaning Dirty Data (Example 1)
08:01
Cleaning Dirty Data (Example 2)
06:13
Cleaning Dirty Data (Example 3)
06:07
Cleaning Dirty Data (Example 4)
04:35
Cleaning Dirty Data (Example 5)
07:41
Cleaning Dirty Data (Example 6)
11:46
ETL, Data Preparation and Data Cleaning with Power Query
About Lesson
  • Please download the attached Zipped Folder
  • Unzip the folder so you can connect to it when needed.

Exercise Files
PowerQuery Essentials.zip
Size: 462.65 KB
Previous
Next
0% Complete