Section 1 : Introduction
|
Lecture 1 | The Power BI ecosystem | 00:00:28 Duration |
|
Lecture 2 | What is Power BI | 00:02:05 Duration |
|
Lecture 3 | Understanding ETL (extract, transform, and load) | 00:01:56 Duration |
|
Lecture 4 | Focus on Power Query | 00:02:17 Duration |
|
Lecture 5 | Course considerations | 00:01:35 Duration |
Section 2 : Extracting Data Files
|
Lecture 1 | Connecting to CSV or text files | 00:02:25 Duration |
|
Lecture 2 | Manually entering data | 00:01:25 Duration |
|
Lecture 3 | Connecting to an Excel file | 00:03:01 Duration |
|
Lecture 4 | Connecting to a PDF file | 00:02:57 Duration |
|
Lecture 5 | Connecting to folders |
Section 3 : Extracting Data Databases
|
Lecture 1 | Connecting to databases | 00:05:34 Duration |
|
Lecture 2 | Comparing data connection modes | |
|
Lecture 3 | Query folding and native queries | 00:03:19 Duration |
Section 4 : Extracting Data Web and Other Options
|
Lecture 1 | Connecting to web tables | 00:06:15 Duration |
|
Lecture 2 | Querying API data | 00:02:33 Duration |
|
Lecture 3 | Querying REST API connections | 00:07:53 Duration |
|
Lecture 4 | Configuring OData feeds | 00:01:54 Duration |
|
Lecture 5 | Installing Python | 00:02:25 Duration |
|
Lecture 6 | Running Python scripts | 00:02:02 Duration |
Section 5 : Transforming Data Cleaning
|
Lecture 1 | Leveraging metadata | 00:01:28 Duration |
|
Lecture 2 | Leveraging data types | 00:02:49 Duration |
|
Lecture 3 | Making initial field transformations | 00:04:30 Duration |
|
Lecture 4 | Splitting fields | 00:03:05 Duration |
|
Lecture 5 | Merging fields | 00:01:56 Duration |
|
Lecture 6 | Cleaning text fields | 00:02:07 Duration |
|
Lecture 7 | Transforming numerical fields | 00:02:18 Duration |
|
Lecture 8 | Removing or replacing values | 00:02:36 Duration |
|
Lecture 9 | Filtering and removing duplicates | |
|
Lecture 10 | Accessing native query in cleaning | 00:04:40 Duration |
Section 6 : Transforming Data Integration
|
Lecture 1 | Introducing table objects | 00:04:06 Duration |
|
Lecture 2 | Introducing list and record objects | 00:06:13 Duration |
|
Lecture 3 | Working with binary objects | 00:03:35 Duration |
|
Lecture 4 | Grouping data | 00:01:50 Duration |
|
Lecture 5 | Pivoting data | 00:06:36 Duration |
|
Lecture 6 | Transposing data | 00:02:10 Duration |
|
Lecture 7 | Unpivoting data | 00:01:44 Duration |
|
Lecture 8 | Accessing native query in integration | 00:04:23 Duration |
Section 7 : Transforming Data Enrichment
|
Lecture 1 | Leveraging text formulas | 00:08:11 Duration |
|
Lecture 2 | Conditional formulas | 00:02:51 Duration |
|
Lecture 3 | Filling up or down columns | 00:01:43 Duration |
|
Lecture 4 | Leveraging date formulas | 00:05:42 Duration |
|
Lecture 5 | Combining binary files with formulas | 00:06:30 Duration |
|
Lecture 6 | Accessing native query in enrichment | 00:03:25 Duration |
Section 8 : Leveraging M Language Logic and Syntax
|
Lecture 1 | Working with Query Editor steps | 00:03:30 Duration |
|
Lecture 2 | Breaking down syntax | 00:01:53 Duration |
|
Lecture 3 | Renaming steps in M | 00:04:20 Duration |
|
Lecture 4 | Consolidating M steps | 00:02:16 Duration |
|
Lecture 5 | Adding data types as custom M code | 00:02:41 Duration |
|
Lecture 6 | Connecting to zipped binary data | 00:02:59 Duration |
Section 9 : Leveraging M Language Objects
|
Lecture 1 | Utilizing parameters | |
|
Lecture 2 | Creating list objects | 00:04:02 Duration |
|
Lecture 3 | Referencing a list as a column in a table | 00:03:00 Duration |
|
Lecture 4 | Leveraging record objects | 00:01:49 Duration |
|
Lecture 5 | Leveraging list functions | 00:01:57 Duration |
|
Lecture 6 | Creating date tables | 00:03:03 Duration |
|
Lecture 7 | Looping with lists | 00:06:34 Duration |
|
Lecture 8 | Combining list objects | 00:05:36 Duration |
Section 10 : Leveraging M language Custom Functions
|
Lecture 1 | Setting up custom functions | 00:06:23 Duration |
|
Lecture 2 | Converting queries into functions | |
|
Lecture 3 | Configuring custom filtering | 00:05:23 Duration |
Section 11 : Loading Data
|
Lecture 1 | Configuring loading options | 00:03:05 Duration |
|
Lecture 2 | Fixing errors | 00:03:24 Duration |
|
Lecture 3 | Refreshing data | 00:06:29 Duration |
|
Lecture 4 | Joining sets of data | 00:07:11 Duration |
|
Lecture 5 | Composite models | 00:02:19 Duration |