After explaining the different types of filters Google Data Studio offers for your reports on the previous blog post of our GDS series. This time we are going to discuss the possibility of using filters from multiple data sources.

In many use cases, data analysts will have to put data from Google Sheets, Google Analytics, BigQuery, and many other third-party data sources altogether in one dashboard.

And filtering the different charts from their respective data sources all at once can be tricky, especially that the schema names can differ.

In this blog post, I will walk you through the different…

Data Studio offers a big variety of possibilities to filter the data visualized in the report. You can filter just in the current chart, current page or in all pages simultaneously. It also depends on where you put the filter on the page, inside or outside of the page.

This Blogpost describes the behavior of these different filter approaches. The topic is more directed to people who do not have much experience in creating dashboards in Data Studio.

All examples and screenshots of this article are based on data of a Bikeshare service in San Francisco, where people can rent…

In this blog post, I want to summarize the new releases from the Google tools, that we use daily in datadice. Therefore I want to give an overview of the new features of BigQuery, Data Studio, Google Analytics and Google Tag Manager. Furthermore I will focus on the releases that I consider to be the most important ones and I will also name some other changes that were made.

If you want to take a closer look, here you can find the Release Notes from BigQuery, Data Studio, Google Analytics & Google Tag Manager

BigQuery

Google finally announced the possibility to…

Google Data Studio is a powerful visualisation tool loaded with multiple possibilities that we talked about in the previous blog posts of this series.

This time we are going to talk about the best practices to save some bucks using this tool.

GDS or Google Data Studio does not have paid services included, nevertheless, the major data connector for this tool is BigQuery alongside other services that can be connected to it as well.

This blog post will mainly focus on BigQuery’s cost-effectiveness as it is the main service used for data warehousing before illustrating the results on Data Studio…

When you start with Data Studio and you want to filter in one of the reports, you get a broad offer of many different filters. In this Blogpost, I want to show the different kinds of filters and give some recommendations for their best use cases. Additionally I want to speak about which filter types we use most of the time and the reasons for that. The audience of this article are people taking the first steps with Data Studio.

Overview

With filters, you can select the data you want to see in the report. The filters vary in the used…

A community’s contribution to any tool is a critical factor for its success.

And for BI tools, the area of contribution is represented in adding third-party connectors for data sources and visualisation components for the dashboards.

Data Studio is already covering a broad area of chart types that are sufficient for the daily use of analysts, going from the usual bar plots, pie charts, pivot tables, and the native Google Maps implementation.

Some third-party charts are also available for users, with a limited number of possibilities compared to other BI tools.

Google Visualizations

Google offers its own native charts which are available…

In my first hours with Data Studio I had many problems really getting the difference between dimension and metrics. Especially because I had no experience with data transformation or data visualization it was difficult to think in groups of data, measurements, rows and columns. The next pitfall comes with the feature of breakdown and drill down dimensions in Data Studio.

In this post, I want to give an overview of these two dimension types. The explanations are on a beginner level, they will be more useful for people who are starting building dashboards in Data Studio.

Dimensions & Metrics

At first I want…

In this blog post, I want to summarize the new releases from the Google tools, that we use daily in datadice. Therefore I want to give an overview of the new features of BigQuery, Data Studio, Google Analytics and Google Tag Manager. Furthermore I will focus on the releases that I consider to be the most important ones and I will also name some other changes that were made.

If you want to take a closer look, here you can find the Release Notes from BigQuery, Data Studio, Google Analytics & Google Tag Manager

BigQuery

In BigQuery you can now change…