Category Google Data Studio
A beginner's guide to Google Data Studio blending
As compared to tools like Tableau or Looker, Google Data Studio is pretty simple. However, for a lot of users, it will be their first confrontation with data manipulations like case formula or data blending. In this article, I’ll explain in detail how to blend data sources. It can be pretty intimidating, but don’t worry; it is not that complicated. What is data blending? Data blending is a feature of data studio allowing you to cross, merge, join (or whatever term you want to use) data sources.
Bend data studio to your will with "photoshop" layers or How to freeze Table rows
Here is a short article on how to freeze top rows in Google Data Studio with Tables. The fix itself might be quickly outdated but the solution is interesting as it shows how to play with “layers” to bend Data Studio to your will. The issue When you create a table in Google Data Studio, there is no way (yet!) to freeze the first row. I’m not talking about the header of your table but the first “real” row.
How to transfer google data studio ownership
Transferring Google Data Studio ownership is not as straightforward as it should. Firstly it is essential to understand that transferring ownership of a report is not the same as transferring ownership of a Data source. If you want to own a dashboard fully, you will need to own the report but also the Data Source. Secondly, you can only transfer Reports ownership to a Google account from the same domain.
How to share Google Data Studio Reports and Data Sources
A lot of people are confused about sharing and managing access with Google Data Studio. I think that most of the confusion comes from the fact that you can share and manage access at Reports level or Data sources level. Understanding this distinction is crucial. It will help you bring much more granularity in the way you share and manage access to your reports and data sources. Let’s take a look at it in more detail.
Mistakes to avoid when blending data with Google Data Studio
The goal is this article is to highlight and explain some subtleties of Data Studio Data blending. I hope it will help my readers avoid and understand the most common pitfalls. Only rows with matching keys are returned. The first thing to known when blending data is that only rows with a key from the primary data source matching a key from the second data source are passed into the blended data.
How to show the “Last 6 months” in a line chart with Google Data Studio.
When working with Google Data Studio client regularly asked me to display line chart showing data for the last six months. Even if the request seems pretty reasonable, it is not so easy to answer it. However there is nothing impossible with the help of a google spreadsheet and some formula. The problem with showing the last 6 months data in Google Data Studio Looking at the built-in date range selector in Google Data Studio you have everything… last 14 days, last 30 days, this quarter, last quarter, This years, last years, yesterday, last month, this week, last week… but nothing like last 6 months or even last 3 months…
How to create a bar chart in Google Data Studio without dimensions… the case of Google Analytics Goals.
Google Data Studio is a great tool however some limitation can be incredibly frustrating. Things can get quickly complicated even for what it seems to be a most straightforward, apparent request. I recently found myself in a situation where a client wanted to have Google Analytics goals displayed in a simple bar chart using Google Data Studio. My client wanted something like this : [caption id=“attachment_571” align=“alignnone” width=“420”] Expected visualization (Bar Chart + Google Analytics goals)[/caption]
How to duplicate a Google Data Studio Reports
You might want to copy a Google Data Studio report for at least two reasons: Copying a report you don’t own and want to use. Like for example a report from the Google Data Studio Report Gallery. Copying a report to create a Master Template you want to reuse as a base for future reports. There are two ways you can copy a report: If you can access the edit interface go to ‘File’ > ‘Make a copy…’: