Section 1 : Introduction

Lecture 1 The Power BI ecosystem 0:28
Lecture 2 What is Power BI 2:5
Lecture 3 Understanding ETL (extract, transform, and load) 1:56
Lecture 4 Focus on Power Query 2:17
Lecture 5 Course considerations 1:35

Section 2 : Extracting Data Files

Lecture 6 Connecting to CSV or text files 2:25
Lecture 7 Manually entering data 1:25
Lecture 8 Connecting to an Excel file 3:1
Lecture 9 Connecting to a PDF file 2:57
Lecture 10 Connecting to folders

Section 3 : Extracting Data Databases

Lecture 11 Connecting to databases 5:34
Lecture 12 Comparing data connection modes
Lecture 13 Query folding and native queries 3:19

Section 4 : Extracting Data Web and Other Options

Lecture 14 Connecting to web tables 6:15
Lecture 15 Querying API data 2:33
Lecture 16 Querying REST API connections 7:53
Lecture 17 Configuring OData feeds 1:54
Lecture 18 Installing Python 2:25
Lecture 19 Running Python scripts 2:2

Section 5 : Transforming Data Cleaning

Lecture 20 Leveraging metadata 1:28
Lecture 21 Leveraging data types 2:49
Lecture 22 Making initial field transformations 4:30
Lecture 23 Splitting fields 3:5
Lecture 24 Merging fields 1:56
Lecture 25 Cleaning text fields 2:7
Lecture 26 Transforming numerical fields 2:18
Lecture 27 Removing or replacing values 2:36
Lecture 28 Filtering and removing duplicates
Lecture 29 Accessing native query in cleaning 4:40

Section 6 : Transforming Data Integration

Lecture 30 Introducing table objects 4:6
Lecture 31 Introducing list and record objects 6:13
Lecture 32 Working with binary objects 3:35
Lecture 33 Grouping data 1:50
Lecture 34 Pivoting data 6:36
Lecture 35 Transposing data 2:10
Lecture 36 Unpivoting data 1:44
Lecture 37 Accessing native query in integration 4:23

Section 7 : Transforming Data Enrichment

Lecture 38 Leveraging text formulas 8:11
Lecture 39 Conditional formulas 2:51
Lecture 40 Filling up or down columns 1:43
Lecture 41 Leveraging date formulas 5:42
Lecture 42 Combining binary files with formulas 6:30
Lecture 43 Accessing native query in enrichment 3:25

Section 8 : Leveraging M Language Logic and Syntax

Lecture 44 Working with Query Editor steps 3:30
Lecture 45 Breaking down syntax 1:53
Lecture 46 Renaming steps in M 4:20
Lecture 47 Consolidating M steps 2:16
Lecture 48 Adding data types as custom M code 2:41
Lecture 49 Connecting to zipped binary data 2:59

Section 9 : Leveraging M Language Objects

Lecture 50 Utilizing parameters
Lecture 51 Creating list objects 4:2
Lecture 52 Referencing a list as a column in a table 3:0
Lecture 53 Leveraging record objects 1:49
Lecture 54 Leveraging list functions 1:57
Lecture 55 Creating date tables 3:3
Lecture 56 Looping with lists 6:34
Lecture 57 Combining list objects 5:36

Section 10 : Leveraging M language Custom Functions

Lecture 58 Setting up custom functions 6:23
Lecture 59 Converting queries into functions
Lecture 60 Configuring custom filtering 5:23

Section 11 : Loading Data

Lecture 61 Configuring loading options 3:5
Lecture 62 Fixing errors 3:24
Lecture 63 Refreshing data 6:29
Lecture 64 Joining sets of data 7:11
Lecture 65 Composite models 2:19