MSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important Transformations

Download Excel START Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-StartFilePowerQueryMergeAppendUnPivot.xlsx https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-dSalesRepTable.xlsx https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-dTerritoryTable.txt Download Excel FINISHED Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-FinishedFilePowerQueryMergeAppendUnPivot.xlsx Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-PowerQueryImportCurrentWorkbook.pdf Assigned Homework: Download Excel File with Homework: Assigned Homework: Download Excel File with Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-Homework-Start.xlsx Download Files to import for Merge Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-HomeworkExcelSalesTable.xlsx https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-HomeworkTextdProductTable.txt Example of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-Homework-Finished.xlsx In this Video learn about three important Power Query Transformations: Merge, Append and UnPivot. Topics: 1. (00:15) Introduction. 2. (02:00) Example1: Merge 2 Tables to Replace VLOOKUP or Relationship 3. (08:11) Example 2: Transform 3 Non-Uniform Sales Tables Then Append into Single Proper Data Set 4. (16:31) Example 3: UnPivot to Convert Cross Tabulated Data Tables into Proper Data Set 5. (22:29) Summary Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor. The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!