Master Microsoft POWER QUERY in POWER BI & Excel (ETL Tool)

Course Curriculum

Chapter 1: PQ 1 – What is Power Query

Lecture 1: PQ 1 – What is Power Query

Chapter 2: PQ 2 – Data Types

Lecture 1: PQ 2 – Data Types

Chapter 3: PQ 3 – Fixing Dates & Date Locale Setting

Lecture 1: PQ 3 – Fixing Dates & Date Locale Setting

Chapter 4: PQ 4 – For Columns – MOVE, REMOVE, RENAME, DUPLICATES

Lecture 1: PQ 4 – For Columns – MOVE, REMOVE, RENAME, DUPLICATES

Chapter 5: PQ 5 – Split Columns

Lecture 1: PQ 5 – Split Columns

Chapter 6: PQ 6 – Merge

Lecture 1: PQ 6 – Merge

Chapter 7: PQ 7 – Filtering Rows

Lecture 1: PQ 7 – Filtering Rows

Chapter 8: PQ 8 – Removing Duplicates and Errors

Lecture 1: PQ 8 – Removing Duplicates and Errors

Chapter 9: PQ 9 – Sorting

Lecture 1: PQ 9 – Sorting

Chapter 10: PQ 10 – Appending Data from Multiple Excel Worksheets

Lecture 1: PQ 10 – Appending Data from Multiple Excel Worksheets

Chapter 11: PQ 11 – Appending Data from Multiple Excel Workbooks (Same Table Names)

Lecture 1: PQ 11 – Appending Data from Multiple Excel Workbooks (Same Table Names)

Chapter 12: PQ 11-1 – Appending Data from Multiple Excel Workbooks (Same Sheet Names)

Lecture 1: PQ 11-1 – Appending Data from Multiple Excel Workbooks (Same Sheet Names)

Chapter 13: PQ 12 – Appending Data from Multiple Excel Workbooks – Different Table and Sheet

Lecture 1: PQ 12 – Appending Data from Multiple Excel Workbooks – Different Table and Sheet

Chapter 14: PQ 13 – Replace and Fill

Lecture 1: PQ 13 – Replace and Fill

Chapter 15: PQ 14 – Formatting Numbers and Dates

Lecture 1: PQ 14 – Formatting Numbers and Dates

Chapter 16: PQ 15 – Adding Custom Calculated Columns

Lecture 1: PQ 15 – Adding Custom Calculated Columns

Chapter 17: PQ 16 – GroupBy

Lecture 1: PQ 16 – GroupBy

Chapter 18: PQ 17 – Unpivot

Lecture 1: PQ 17 – Unpivot

Chapter 19: PQ 18 – 6 Types of Joins

Lecture 1: PQ 18 – 6 Types of Joins

Chapter 20: PQ 19 – Create Calendar in PQ vs. DAX

Lecture 1: PQ 19 – Create Calendar in PQ vs. DAX

Chapter 21: Append Data from Multiple Different Excel Files Combination of XLSX & CSV

Lecture 1: Append Data from Multiple Different Excel Files Combination of XLSX & CSV

Chapter 22: Working with very LARGE Datasets | 4+ Million Rows | Power Query and Power Pivot

Lecture 1: Working with very LARGE Datasets | 4+ Million Rows | Power Query and Power Pivot

Chapter 23: Skip Files with Errors Benefit when Appending Data from a Folder

Lecture 1: Skip Files with Errors Benefit when Appending Data from a Folder

Chapter 24: How to Extract Dates From Text Strings in Power Query

Lecture 1: How to Extract Dates From Text Strings in Power Query

Chapter 25: How to Append Data from Many Excel Files into Microsoft POWER BI

Lecture 1: How to Append Data from Many Excel Files into Microsoft POWER BI

Chapter 26: How to Calculate Hours Worked for Employees on Complex Data & to Summarize

Lecture 1: How to Calculate Hours Worked for Employees on Complex Data & to Summarize

Chapter 27: Fuzzy Lookup in Microsoft Excel / POWER BI (2 Methods: Addin or Power Query)

Lecture 1: Fuzzy Lookup in Microsoft Excel / POWER BI (2 Methods: Addin or Power Query)

Chapter 28: Normalize Data using Power Query

Lecture 1: Normalize Data using Power Query

Chapter 29: Combine Multiple Tables and Perform Aggregation Sum | POWER QUERY Solution

Lecture 1: Combine Multiple Tables and Perform Aggregation Sum | POWER QUERY Solution

Chapter 30: LinkedIn Profile Optimization Tips | Exploring Jobs (On-Site + Remote)

Lecture 1: LinkedIn Profile Optimization Tips | Exploring Jobs (On-Site + Remote)