10.1. Intro & Limitations of Old Data Blending

Welcome to the advanced course on data modeling and data blending in Looker Studio! In our last session, we explored the foundations of data blending in Looker Studio and discussed the left outer join. Today, we'll dive deeper into the rest of the join types available in Looker Studio, starting with some examples of the left join.

Data Blending: A Refresher

Remember, in Looker Studio, we can only use one data source per chart. However, we can blend data sources based on specific criteria and join keys, essentially creating a single blended data source. This allows us to connect multiple data sources to a single chart.

Initially, data blending had some limitations:

1. A maximum of five data sources could be blended.
2. Only left outer join was supported.
3. The same join key needed to be present in all data sources.

While the limitation of blending up to five data sources still exists, we now have access to multiple join types and keys across different joins.

Expanded Join Types

In addition to the left outer join, Looker Studio now offers right outer join, inner join, full outer join, and cross join types. This provides greater flexibility in how you can mix and match different join types between tables. For example, you might want a left join between the first and second tables, a full outer join between the second and third tables, and a cross join for the final table.

Understanding Join Types with Venn Diagrams

Venn diagrams are often used to illustrate different join types. These overlapping circles show how data from different tables is combined based on the join type being used.

Let's take a closer look at the various join types in Looker Studio and how they can be applied in real-life scenarios.

Enroll in Looker Studio Masterclass →

📩 Receive my weekly Looker Studio tips

🖇 Connect with me on LinkedIn