Everybody who knows SQL and JOINS, blending data in Looker Studio is exactly this. So with blending, you can bring data located in different data sources together. You have to define conditions when the data matches and the result of the process is one new data source, you can use like all the other data sources.
To discover the new blending menu, we want to connect the following three data sources:
The first new feature and maybe also the most important one is the selection of the JOIN type. Before that, we have to select which dimensions are part of the join conditions
Then we also have to add them as keys for the selected LEFT JOIN:
Then we also want to add the region name to the table and to do that, we have to join the region data to the table. Then you will see the other important new feature in the blending menu.
Then we have already a good overview of the current implementation:
The other new important change is the possibility to use different JOIN keys. Before the change, you have to use the same keys in all JOINs. Now you can select in every JOIN which field you want to set as key.
It would be nice if you could see which key is being used in which JOIN (currently just visible in the joining menu).
The rest is still the same as before. So when the join works as intended, you can select all the needed fields.
So I would name 3 new features:
We always have some discussions about using blending data in Looker Studio. To say it at the beginning, we found cases when it makes sense to use blending inside your reports (Especially self-joins are a powerful opportunity to level up your visualization).
But you should try at first to join the data in your database.
Otherwise, all creators blend data on their own, do mistakes and the data is not correct and uniform anymore.
The new blending menu has some good improvements, especially the new handling and appearance of the menu is more intuitive. Additionally, the most important new feature is the availability of all JOIN types in my mind.
But it has still some restrictions, you can just circumvent when you connect your data inside your database.
This post is part of the new features in the Google cloud series from datadice and gives you detailed insights about a new feature in BigQuery or Looker Studio.
Check out our LinkedIn account, to get insights into our daily working life and get important updates about BigQuery, Looker Studio and marketing analytics
We also started with our own YouTube channel. We talk about important DWH, BigQuery, Looker Studio and many more topics. Check out the channel here.
If you want to learn more about how to use Google Looker Studio and take it to the next level in combination with BigQuery, check our Udemy course here.
If you are looking for help to set up a modern and cost-efficient data warehouse or analytical dashboards, send us an email to email@example.com and we will schedule a call.