Microsoft Power Query in POWER BI & Excel Fundamentals Concepts with Advanced Tips & Tricks

Description
Power Query is an ETL tool created by Microsoft for data extraction, loading and transformation, and is used to retrieve data from sources, process it, and load them into one or more target systems.



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


Power Query is the data connectivity and data preparation technology that enables end users to seamlessly import and reshape data from within a wide range of Microsoft products, including Excel, Power BI, Analysis Services, Dataverse, and more. Power Query is an ETL tool created by Microsoft for data extraction, loading and transformation, and is used to retrieve data from sources, process it, and load them into one or more target systems.



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