Performing Joins Using Merge Queries in Power BI

Power BI 2.12    |    Intermediate
  • 14 videos | 1h 24m 47s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
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 46s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 5m 51s
    During this video, discover how to set up relationships between tables in Power BI. FREE ACCESS
  • Locked
    3.  Performing Inner Joins Using Merge Queries
    8m 40s
    Learn how to perform inner joins in Power BI. FREE ACCESS
  • Locked
    4.  Performing Left Outer Joins Using Merge Queries
    6m 16s
    In this video, find out how to perform left outer joins in Power BI. FREE ACCESS
  • Locked
    5.  Performing Right Outer Joins Using Merge Queries
    5m 6s
    Discover how to perform right outer joins in Power BI. FREE ACCESS
  • Locked
    6.  Performing Full Outer Joins Using Merge Queries
    5m 18s
    During this video, you will learn how to perform full outer joins in Power BI. FREE ACCESS
  • Locked
    7.  Performing Left Anti and Right Anti Joins
    5m 39s
    Find out how to perform anti joins in Power BI. FREE ACCESS
  • Locked
    8.  Using Anti Joins to Filter Errors
    7m 42s
    In this video, discover how to filter error rows with anti joins. FREE ACCESS
  • Locked
    9.  Pivoting and Unpivoting Columns
    6m 6s
    Learn how to pivot and unpivot columns. FREE ACCESS
  • Locked
    10.  Performing Fuzzy Merging
    8m 9s
    In this video, find out how to perform fuzzy merging. FREE ACCESS
  • Locked
    11.  Ignoring Case and Combining Text Parts
    7m 10s
    During this video, you will learn how to configure settings for fuzzy merging. FREE ACCESS
  • Locked
    12.  Configuring the Similarity Threshold
    8m 38s
    Discover how to tweak the similarity threshold for fuzzy merging. FREE ACCESS
  • Locked
    13.  Performing Fuzzy Merging Using a Transformation Table
    5m 47s
    Learn how to perform fuzzy merging with a transformation table. FREE ACCESS
  • Locked
    14.  Course Summary
    2m 38s
    In 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 1802 users Rating 4.5 of 1802 users (1802)
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)