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.