I’ve described the basics of joins in my first article. Hope you have found it helpful. In this article, I will show you how these joins can be done using Power BI’s Power Query and also in R using dplyr.

Power BI has a “Click” type ( Using the mouse alot) UI while R has a “Typing” interface (Using the keyboard alot).

I love both and hope you will too.

Let’s get back to our little stick figures — useful right?

Image by author

Let’s get into it!

Let’s load in our data :) Two tiny data sets, but great for our examples.

Image by author

Now that they are loaded, let’s go into Power Query

Image by author

Once I am in the Power Query side — I see my two data sets.

#power-bi-tutorials #sql-joins #data-science #power-bi #tutorial