MASTERCLASS - Microsoft Power Query Fundamentals Concepts with Tips & Tricks | Microsoft POWER BI

CLICK HERE

PQ 1 - What is Power Query

PQ 2 - Data Types

PQ 3 - Fixing Dates & Date Locale Setting

PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES

PQ 5 - Split Columns

PQ 6 - Merge

PQ 7 - Filtering Rows

PQ 8 - Removing Duplicates and Errors

PQ 9 - Sorting

PQ 10 - Appending Data from Multiple Excel Worksheets

PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)

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

PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet Names

PQ 13 - Replace and Fill

PQ 14 - Formatting Numbers and Dates

PQ 15 - Adding Custom Calculated Columns

PQ 16 - GroupBy

PQ 17 - Unpivot

PQ 18 - 6 Types of Joins

PQ 19 - Create Calendar in PQ vs. DAX

#powerbi #powerquery