How to join data sources in your dashboards. By Alexander Junke

Photo by Jordan on Unsplash

Every chart inside a Data Studio report is based on exactly 1 data source. But sometimes you are getting confronted with the problem that you want to show data from different data sources inside a table, bar chart, or any other available chart type. In this case, the Data Studio functionality of blending data sources comes into action. The result of this is a data source that uses data from different sources.

You can be a beginner in creating Data Studio dashboards to understand this topic, but if you have some problems understanding the concept behind a join (connect different…

Find proper use cases for the different charts. By Alexander Junke

Photo by Jason Coudriet on Unsplash

Data Studio has a big variety of different chart types. You can use tables, bar charts, pie charts, maps, and many more to fill your dashboards. This blog post will create an overview of the different types. I will speak about our experiences with the charts and enumerate the pros and cons.

Because this blog post is a summary of a basic Data Studio topic, persons on a beginner level are the target audience.

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

Understanding the difference between DWH data, data source, and chart data. By Alexander Junke

Photo by Jacob Thomas on Unsplash

After building your first Data Studio dashboards, you will start developing a better feeling of how to visualize data. But then there is still another important aspect missing, in particular how data management works in Data Studio. There are 3 layers of data: the tables in the Data Warehouse, the data source in Data Studio and the data of the different charts. In this blog post, I want to show how these 3 data layers collaborate and for example how filters or custom metrics inflict the different data layers.

Beginners and Intermediates in Data Studio should read this blog post.

Overview

The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Photo by Bharat Patil on Unsplash

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

BigQuery got a lot of nice-looking…

Explore the chart filters possibilities in your reports. By Ahmed Masmoudi

Photo by Tyler Nix on Unsplash

In this blog post, we are going to discover the possibilities that Google Data Studio offers to its users when it comes to filtering data using the charts within your reports.

In the previous blog posts of our Google Data Studio series, we talked about different filter styles to use in your dashboards. Also, we explained the different filtering levels in your reports.

And finally, we had a thorough post about creating filters with multiple data sources that can be very useful when using chart filters which is our today’s topic.

Chart filters are a feature that enables users to…

Make uniform and professional-looking reports in less time. By Alexander Junke

Photo by Viva Zhang on Unsplash

In my first Data Studio reports I had many problems in terms of properly styling the charts and tables. After I added a new table to a page, I realized that the design of the table is totally different to the existing tables.

To avoid this situation you can create a theme right after creating a new report. I will write about the reason for using a theme, how to create a theme and which settings are the most important ones.

If you are a beginner or intermediate in Data Studio, this is the right blog post for you.

Why using themes?

Using…

How to filter data from more than one source. By Ahmed Masmoudi

Photo by Cedric Letsch on Unsplash

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…

Are you taking advantage of all the filter possibilities? By Alexander Junke

Photo by Madhu Shesharam on Unsplash

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…

The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Photo by Anthony Rosset on Unsplash

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…

Best practices to avoid costly behaviour on the Cloud. By Ahmed Masmoudi

Photo by Freddie Collins on Unsplash

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…

datadice

Agency of Business Intelligence specialists, based in Coburg, DE. Building modern, customized and cloud-based data warehouse solutions. https://www.datadice.io/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store