Download Excel START Files:
\nhttps:\/\/ift.tt\/2LwCF91
\nDownload Excel FINISHED Files:
\nhttps:\/\/ift.tt\/2JLJr5F
\nDownload pdf Notes about Power Query: https:\/\/ift.tt\/2LrkvFv
\nAssigned Homework:
\nDownload Excel File with Homework: <\/p>\n
In this Video learn about Power Query\u2019s 6 types of Joins, 6 Types of Merges.
\nTopics:
\n1. (00:15) Introduction.
\n2. (00:24) Full Description of What A Join is and what a merge is. What is A Join?
\n3. (06:06) Inner Join
\n4. (13:05) Create Folders to organize Queries
\n5. (13:35) Full Outer Join
\n6. (17:55) Left Anti Join
\n7. (20:30) Right Anti Join
\n8. (23:27) Left Outer Join for Lookup
\n9. (26:16) Left Outer Join for Two Value Lookup
\n10. (28:28) Left Outer Join to pull matching Multiple Records from the Right Table (One Lookup Value, Return Multiple Items).
\n11. (29:41) See how to use Expand Column to Aggregate Values.
\n12. (31:53) Right Join Outer
\n13. (34:37) Self-Join
\n14. (36:56) Summary<\/p>\n
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.<\/p>\n