Comparing COVID-19 cases in the United States and Europe
In this dashboard I wanted to show the differences between the number of COVID-19 cases in the United States and Europe. Thanks to Johnny Miller from Unequal Scenes for the suggestion to take a look at the data.
How to make an Interactive List of People in Google Data Studio
So in this post I'll show you how to make what I've called an Interactive List of People in Google Data Studio.
Use a Constant Value to make a Goal dashboard in Google Data Studio
So in this post I'll show you how to create a Constant Value in Google Data Studio, and give you a practical example of how you can use a constant value to create a Goal dashboard.
How to build a compact Google Search Console Dashboard in Google Data Studio
In this post I'll show you how to make a compact, one page Google Search Console Dashboard using Google Data Studio.
How to Filter by Email in Google Data Studio
In this post I'll be showing you how you can filter by email in Google Data Studio.
This is a new feature, and I'll be giving a simple overview of it and how it works. To learn more about this feature see the official Google notes or this blog post from Wissi Analytics.
How to build a Twitter dashboard in Google Data Studio using IFTTT
A while back I wrote a post about how to build a Twitter dashboard in Google Data Studio. Unfortunately it seems that that version no longer works, or if it does work is very buggy. But I have discovered a new way of getting tweets into Data Studio so figured I'd write a new post about how to do it.
Create Revenue Targets in Google Data Studio using CASE statements
I had been looking for a way to create Revenue Targets in Google Data Studio, and tested out a method using CASE statements that works. So thought I'd share it!
Use the CONCAT function to create Custom Dimensions in Google Data Studio
In this post I'll show you how you can use the CONCAT function in Google Data Studio to create Custom Dimensions.
In this case, we can combine multiple different dimensions into one dimension and filter our data accordingly.
How to analyse sales data using Google BigQuery and Data Studio
In this post I'll show you how to analyse sales data using Google BigQuery and Google Data Studio.
According to Google Cloud; "BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in."
How to make a simple Ecommerce dashboard in Google Data Studio
In this post I'll show you how to make a simple Ecommerce dashboard in Google Data Studio. This report gives you a quick overview of how your online store is performing.