How to blend data in Looker or Google Data Studio | How to join multiple tables in Looker

Подписаться 3,9 тыс.

Просмотров 3,9 тыс.

50% 1

in this video we are going to discuss how you can blend multiple data sources into a single data source for your report. In simple words blending data means you are combining columns from multiple dataset into a single dataset for your report, just like we use joins in SQL , we can use data blending in looker to join multiple datasets into a single data set.
IN looker or data studio this Data blending feature lets you literally “blend” data from two sets, charts, or sources into a single visualized report. And Instead of running two visualized widgets side-by-side or up -down , you can merge the data or layer them to see how they are compared to each other.
In other words you can also say that Data blending lets you see the relationship between two datasets that normally wouldn’t fit together and you will not be able to analyze just by looking at data.
Now the question comes that How to blend data in Google Data Studio
Method-1 using Resources → Manage Blends
create new blended data using the already added data and then create a visualization using this new blended data
Method-2 Blending multiple existing visualizations using Resources
You have to create at least two visualizations from different data sources and then select both the visualization and then right click and select blend
__________________________________________________________________________________________________
Excel Playlist:- • What is MS Excel | Int...
SQL Playlist:- • Introduction to SQL | ...
Google Data Studio playlist:- • Introduction to Looker...
__________________________________________________________________________________________________
You can follow us on the below social media handles:-
Blog: - thedatamillennials.blogspot.com/
Facebook:- / the-data-millennials-5...
Instagram: - / the_data_millennials
LinkedIn: - / data-millennials-6b5a0...
Twitter: - / datamillennials

Опубликовано:

12 июл 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 8

@DataStadium0902 Год назад

Thank you so much for the nice video as well as nice explanation.

@thedatamillennials 9 месяцев назад

apologies for the delayed response. I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics

@hakanarslanturk 6 месяцев назад

I've completed the steps. but I have three Google Sheets files. However, when I apply filtering, it only organizes the one in which I am currently working. How can I apply the filtering process to all of them?

@thedatamillennials 6 месяцев назад

I think after blending your data you are applying the filter at a page level. Please apply filter at report level, and then anything that you will select in that filter will only be reflecting in the entire dashboard

@hakanarslanturk 6 месяцев назад

@@thedatamillennials How can I apply it at the report level?

@hakanarslanturk 6 месяцев назад

@@thedatamillennialsand how i can filter page level :) thanx

@thedatamillennials 5 месяцев назад

To apply a filter at the report level in Google Data Studio, you can use a Report-Level Filter. Here's how to do it: Open your report in Google Data Studio. In the toolbar at the top of the screen, click on "Add a control" (the icon looks like a funnel). Choose the type of control you want to add. If you want a basic filter, you can choose "Filter" or "Date Range" for filtering by date. Configure the control settings: For a basic filter control: Choose the data source that you want to filter. Select the dimension or metric you want to filter by. Choose the filter type (e.g., "Equals", "Contains", etc.). Enter the value(s) to filter by. For a date range control: Choose the data source that contains the date field you want to filter. Set the date range options as needed (e.g., "Last 30 days", "This month", etc.). Position and resize the control on your report canvas as desired. Test the filter by interacting with it in view mode. You can click on the control and select different options to see how it affects the data displayed in your report. By following these steps, you can apply a filter at the report level in Google Data Studio to control which data is displayed across all elements of your report.

@thedatamillennials 5 месяцев назад

To apply a simple page-level filter in Google Data Studio, you can use a Page-Level Filter control. This filter allows you to control which data is displayed on a specific page of your report. Here's how you can apply it: Open your report in Google Data Studio. Navigate to the page where you want to apply the page-level filter. In the toolbar at the top of the screen, click on "Add a control" (the icon looks like a funnel). Choose the type of control you want to add. For a page-level filter, you can choose either "Filter" or "Date Range" depending on the type of filtering you want to apply. If you're filtering based on a specific dimension or metric, choose "Filter." If you want to filter based on date, choose "Date Range." Configure the control settings: For a basic filter control: Choose the data source that you want to filter. Select the dimension or metric you want to filter by. Choose the filter type (e.g., "Equals", "Contains", etc.). Enter the value(s) to filter by. For a date range control: Choose the data source that contains the date field you want to filter. Set the date range options as needed (e.g., "Last 30 days", "This month", etc.). Position and resize the control on your report canvas as desired. (Optional) Customize the control further: You can adjust the appearance and behavior of the control using the properties panel on the right-hand side. For example, you can change the style, labels, default selection, etc. Test the filter by interacting with it in view mode. You can click on the control and select different options to see how it affects the data displayed on that specific page of your report. By following these steps, you can apply a simple page-level filter in Google Data Studio to control which data is displayed on a particular page of your report.