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…


Are you using all the Filter Types properly? By Alexander Junke

Photo by David Stamm on Unsplash

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…


Getting to know the powerful (but less-known) charts built by third-party developers. By Ahmed Masmoudi

Photo by Jason Leung on Unsplash

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…


Split your visualized metrics properly. By Alexander Junke

Photo by Janik Fischer on Unsplash

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…


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

Photo by Yolanda Sun 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

In BigQuery you can now change…


7 areas for Google to really improve Data Studio. By Ahmed Masmoudi

Photo by Ludovic Charlet on Unsplash

Introduction

Data Studio is the official business intelligence tool offered by Google Cloud Platform. Data Studio is an intuitive interface to explore and build insights using Data. This tool comes for free alongside the other services Google offers with a Google cloud account. This BI tool is so efficient, integrated with a lot of third party data sources, easy to use and has a decent level of customisation for its charts and components.

Nevertheless, Google Data Studio or “GDS” has many drawbacks when it comes to some edge use cases for advanced users.

We are going to list some of those…

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