Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power Query for Excel and Power BI
Download Practice Files
Practice Files
Section 01: Getting Ready
1_Introduction to Power Query - What is it? How to access it? (3:06)
2_Power Query User Interface - A Walkthrough (2:58)
3_Power BI - Nov 2019 Update (0:53)
4_M-Query Basics - Reading Commands in Power Query Editor (2:24)
5_Activate your Applied Steps Panel (0:46)
Feedback
6_Getting the List of all M-Query Commands (2:47)
7_Importing Data (incl Use First Rows as Header) (2:48)
Course Feedback
Section 02: Data Preparation - Part 1 (Blending)
1_Combine or Merge Multiple Files from a Folder (6:02)
2_Importing Data from the Web (7:04)
3_Merge Queries vs. Append Queries (2:35)
4_JOIN Types for Beginners (3:59)
5_Understanding JOIN Concept and its Types (6:21)
6_JOIN in Action - Basic Example (5:57)
7_Quick DOs and DONTs for Merge Queries (3:05)
8_Merging Queries with more than 1 KeyID Column (6:35)
9_Fuzzy Lookup (5:37)
Course Feedback
Section 03: Data Preparation - Part 2 (Cleaning)
1_Using First Rows as Header (1:43)
2_Cleaning Up Data with Case Change, TRIM, CLEAN (3:29)
3_Working with Data Types (2:29)
4_Fill Down Feature (2:00)
5_Removing Duplicates and Blank Rows (4:05)
6_Split Column - Part 1 (Delimiter and By Position) (4:44)
7_Split Column - Part 2 (Digit vs Non-Digit) (3:24)
8_Split Column - Part 3 (Split to Rows) (4:53)
9_Rectify Date Format using Data Type (Locale) (5:12)
10_Working with Column From Examples Feature (3:56)
11_Adding a Conditional Column (3:22)
12_Merge Columns (Concatenate) (1:48)
13_Replace Values and Extract Characters (5:46)
Course Feedback
Section 04: Data Preparation - Part 3 (Re-Structuring)
1_Unpivot Column - Cross Tab vs. Flat File (3:57)
2_Group By - Basic to Advanced (4:51)
3_Pivot Column - An Overview (3:40)
4_Transpose (2:20)
Course Feedback
Section 05: Data Preparation - Part 4 (ETL Project)
Project - Find Top 3 Analysts (8:52)
Course Feedback
Section 06: Bonus Tricks
1_Copy Data from Power Query Tables (0:47)
2_Column Profiling and Distribution (3:01)
3_Duplicate and Rename Queries (0:57)
4_Index Column (1:01)
Course Feedback
7_Importing Data (incl Use First Rows as Header)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock