Explore Power Query's six types of joins and merges through nine practical examples in this comprehensive 38-minute video tutorial. Learn the fundamentals of joins and merges, including inner join, full outer join, left and right anti joins, and various left outer join applications. Discover how to organize queries using folders, perform lookups, and aggregate values using the Expand Column feature. Master self-joins and gain a thorough understanding of these essential data manipulation techniques. Download accompanying Excel files and PDF notes to enhance your learning experience and complete assigned homework to reinforce your skills in Microsoft Power Tools for Data Analysis.
Overview
Syllabus
) Introduction..
) Full Description of What A Join is and what a merge is. What is A Join?.
) Inner Join .
) Create Folders to organize Queries.
) Full Outer Join.
) Left Anti Join.
) Right Anti Join.
) Left Outer Join for Lookup.
) Left Outer Join for Two Value Lookup.
) Left Outer Join to pull matching Multiple Records from the Right Table (One Lookup Value, Return Multiple Items)..
) See how to use Expand Column to Aggregate Values..
) Right Join Outer.
) Self-Join.
) Summary.
Taught by
ExcelIsFun
Related Courses
-
Microsoft Excel: Learn Power Query Basics!
-
Power Query Count & Extract Customer Names for 8 Sales Coupon Groups
-
Power Query Complete M Code Introduction - Values, Let, Lookup, Functions, Parameters, More
-
All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples
-
Power Query Group By Feature and Table.Group Function - Examples
-
Master Power Query M Code and Data Shaping for Data Analysis
