Dashboard In A Day (DIAD): 5. The six types of Join query

Episode 5 in a series about how to use Microsoft’s Dashboard In A Day (DIAD) dataset to understand the basics of working with Power BI.

This episode steps off the main path of the DIAD course to explain what the six types of database join mean. We will need to understand this when we come to use Power Query to apply a Merge operation between two tables. It’s also fundamental knowledge when you are working with databases.

Links

Previous episode: https://www.youtube.com/watch?v=BtgIXJlkQMc
Microsoft’s page about the Dashboard In A Day (DIAD) course: https://powerbi.microsoft.com/en-us/instructor-led-training/#section_diad
Download the content for the course including the dataset here: https://aka.ms/diad_student
Further details about the course on the OP-Training website: https://op-training.co.uk/diad-landing-page/