MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples
Download Excel START Files:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/007-MSPTDA-PowerQueryJoinsMergesStart.xlsx
Download Excel FINISHED Files:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/007-MSPTDA-PowerQueryJoinsMergesFinished.xlsx
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/007-MSPTDA-PowerQueryJoinsMerges.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/007-MSPTDA-Homework-Start.xlsx
Example of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/007-MSPTDA-Homework-Finished.xlsx
Buy excelisfun products:
https://teespring.com/stores/excelisfun-store
In this Video learn about Power Query’s 6 types of Joins, 6 Types of Merges.
Topics:
1. (00:15) Introduction.
2. (00:24) Full Description of What A Join is and what a merge is. What is A Join?
3. (06:06) Inner Join
4. (13:05) Create Folders to organize Queries
5. (13:35) Full Outer Join
6. (17:55) Left Anti Join
7. (20:30) Right Anti Join
8. (23:27) Left Outer Join for Lookup
9. (26:16) Left Outer Join for Two Value Lookup
10. (28:28) Left Outer Join to pull matching Multiple Records from the Right Table (One Lookup Value, Return Multiple Items).
11. (29:41) See how to use Expand Column to Aggregate Values.
12. (31:53) Right Join Outer
13. (34:37) Self-Join
14. (36:56) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Видео MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples канала ExcelIsFun
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/007-MSPTDA-PowerQueryJoinsMergesStart.xlsx
Download Excel FINISHED Files:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/007-MSPTDA-PowerQueryJoinsMergesFinished.xlsx
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/007-MSPTDA-PowerQueryJoinsMerges.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/007-MSPTDA-Homework-Start.xlsx
Example of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/007-MSPTDA-Homework-Finished.xlsx
Buy excelisfun products:
https://teespring.com/stores/excelisfun-store
In this Video learn about Power Query’s 6 types of Joins, 6 Types of Merges.
Topics:
1. (00:15) Introduction.
2. (00:24) Full Description of What A Join is and what a merge is. What is A Join?
3. (06:06) Inner Join
4. (13:05) Create Folders to organize Queries
5. (13:35) Full Outer Join
6. (17:55) Left Anti Join
7. (20:30) Right Anti Join
8. (23:27) Left Outer Join for Lookup
9. (26:16) Left Outer Join for Two Value Lookup
10. (28:28) Left Outer Join to pull matching Multiple Records from the Right Table (One Lookup Value, Return Multiple Items).
11. (29:41) See how to use Expand Column to Aggregate Values.
12. (31:53) Right Join Outer
13. (34:37) Self-Join
14. (36:56) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Видео MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)Merging Data with the 6 Joins in Power Query: Inner Join, Outer Joins and Anti-Joins ExplainedPower Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.How to easily automate boring Excel tasks with Power Query!Amazing SUMIF Function with a FLOATING Criteria RangeCombining Multiple Files from a folder using Power Query in Excel or Power BIE-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?MSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important TransformationsMSPTDA 08.5: Power Query Group By Unique List or Consecutive OccurrencesMSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable ReportMSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database SizeCombine Files With Inconsistent Columns In Power QueryMSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many RelationshipE-DAB 06: The Magic of Power Query to Import, Transform & Load DataExcel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each ProductMicrosoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01.How to COMBINE DATA with MERGE and APPEND in Power BIMSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set