Data Blending in Google Data Studio Made Easy

By Petr Nemeth | 5 min read

Google Data Studio is great for data visualization and offers some transformation capability via in-built functions, but it is unable to perform advanced data manipulations such as data joining. Although it does offer data blending functionality, the functionality is rather difficult to set up and debug.

Here is a workaround using Dataddo, which allows users to easily and without coding perform various joining operations (e.g. left join, right join, inner join) before sending data to Data Studio. This gives users much more visualization flexibility.

Want more Data Studio tips & tricks?

  1. Learn how to work with multiple date ranges.
  2. Get 3 free dashboard templates for beginners.
  3. Find out how to track your Instagram follower count.
  4. Learn how to calculate weighted averages.

Step 1. Log into the Dataddo platform and click on Flows at the top of the page.

Step 2. Click on Create Flow in the top right corner.

Step 3. Click on Add Source to connect it to the destination. You can type the connector's name into the search bar to find it faster.

Add source to flow

Step 4. Click on Blend Sources.

Choose first source to blend

Step 5. Click on Select Source to choose the sources you wish to blend.

Data blending in app - step 5

Add second source to blend

Step 6. Choose a Join Key that is the same for both sources. Dataddo will blend the datasets based on this particular key.

You can select other columns for each source by dragging the fields from the list on the left or right. The columns do not need to be the same for each source.

Data blending in app - step 7

Step 7. Click on the button between the sources to configure the joining type. By default, Left Join is selected.

  • Left Join - records from the right source will be joined to the left dataset.
  • Right Join - records from the left source will be joined to the right dataset.
  • Inner Join - returns only records whose values match in both column sources.

Options to join sources

Step 8. Click on Save Source.

Step 9. Once the data is configured for blending, you can Add Destination.

Add destination

To set up the destination, choose the write mode and other necessary settings. You can also name the flow at the top.

Set up your destination

Step 10. By clicking on Data Preview, you can check what data will be sent to the destination. The preview has a limit of approximately 100 rows. Click on Save Flow.

Preview data

Step 11. Under the Flows tab, click Config and copy the API key and API endpoint ID into Google Data Studio to complete synchronization.

Get API for Google Data Studio

The above functionality is important because it enables any business professional to overcome the blending limitations of Google Data Studio.

 

See how Dataddo can help your business

In just a few quick steps, get your data to Google Data Studio or any other dashboarding app.

Start for Free

 


Category: Product

Comments