Performing Joins Using Merge Queries in Power BI
Power BI 2.12
| Intermediate
- 14 videos | 1h 24m 47s
- Includes Assessment
- Earns a Badge
In Power BI, you can establish data relationships and use Power Query to perform joins to merge multiple data tables into a cohesive dataset. By defining these relationships and using functions like merge queries, you can seamlessly combine data from different sources based on common keys, enhancing data integration and enabling in-depth analysis. In this course, you will discover how to create relationships between tables that will allow you to perform more complex inter-table operations. Next, you will learn how to perform SQL-style joins on two tables. Power BI offers numerous types of joins, including inner, outer, left, right, left anti, and right anti joins. You will implement all of these join techniques to define the differences between them and describe their use cases. You will also learn how to pivot and aggregate data in Power Query. Finally, you will explore fuzzy merging to perform joins for inexact matches. This course will provide you with a foundation for how to perform exact and fuzzy joins in Power BI.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Set up relationships between tables in power bi
Perform inner joins in power bi
Perform left outer joins in power bi
Perform right outer joins in power bi
Perform full outer joins in power bi
Perform anti joins in power bi -
Filter error rows with anti joins
Pivot and unpivot columns
Perform fuzzy merging
Configure settings for fuzzy merging
Tweak the similarity threshold for fuzzy merging
Perform fuzzy merging with a transformation table
Summarize the key concepts covered in this course
IN THIS COURSE
-
1m 46sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
5m 51sDuring this video, discover how to set up relationships between tables in Power BI. FREE ACCESS
-
3. Performing Inner Joins Using Merge Queries8m 40sLearn how to perform inner joins in Power BI. FREE ACCESS
-
4. Performing Left Outer Joins Using Merge Queries6m 16sIn this video, find out how to perform left outer joins in Power BI. FREE ACCESS
-
5. Performing Right Outer Joins Using Merge Queries5m 6sDiscover how to perform right outer joins in Power BI. FREE ACCESS
-
6. Performing Full Outer Joins Using Merge Queries5m 18sDuring this video, you will learn how to perform full outer joins in Power BI. FREE ACCESS
-
7. Performing Left Anti and Right Anti Joins5m 39sFind out how to perform anti joins in Power BI. FREE ACCESS
-
8. Using Anti Joins to Filter Errors7m 42sIn this video, discover how to filter error rows with anti joins. FREE ACCESS
-
9. Pivoting and Unpivoting Columns6m 6sLearn how to pivot and unpivot columns. FREE ACCESS
-
10. Performing Fuzzy Merging8m 9sIn this video, find out how to perform fuzzy merging. FREE ACCESS
-
11. Ignoring Case and Combining Text Parts7m 10sDuring this video, you will learn how to configure settings for fuzzy merging. FREE ACCESS
-
12. Configuring the Similarity Threshold8m 38sDiscover how to tweak the similarity threshold for fuzzy merging. FREE ACCESS
-
13. Performing Fuzzy Merging Using a Transformation Table5m 47sLearn how to perform fuzzy merging with a transformation table. FREE ACCESS
-
14. Course Summary2m 38sIn this video, we will summarize the key concepts covered in this course. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
