How to combine data from two BigQuery public datasets using SQL

How to combine data from two BigQuery public datasets using SQL

So in this blog post I'll show how you can combine data from two BigQuery public datasets using SQL and to visualize the data in Data Studio.

Read more


How to connect Google Data Studio to a CSV file using Big Query and Cloud Storage

How to connect Google Data Studio to a CSV file using BigQuery and Cloud Storage

So let's say you have data sitting in a very big CSV file. What's the best way to connect it to Google Data Studio? In this post I'll show you a method of connecting a big CSV file using Google BigQuery and Cloud Storage.

Read more


Looking at Political Advertising on Google using BigQuery and Data Studio

Looking at Political Advertising on Google using BigQuery and Data Studio

So I wanted to build a report looking at Political Advertising on Google using the Google Transparency Report BigQuery dataset.

It's an interesting data set showing the vast amounts spent on political advertising.

Read more


Compare Countries using World Development Indicators in Google Data Studio

Compare Countries using World Development Indicators in Google Data Studio

So in this post I'll share a dashboard I made that allows you to compare countries using World Development Indicators from the World Bank.

Read more


COVID-19 by Region of the World

COVID-19 cases by Region of the World

I wanted to build another Coronavirus dashboard in Google Data Studio, this time looking at the number of COVID-19 cases by region of the world.

Read more


Comparing Canada and South Africa using World Development Indicators

Comparing Canada and South Africa using World Development Indicators

In this post I'll show you a Google Data Studio dashboard I built for Comparing Canada and South Africa using World Development Indicators from the World Bank.

Read more


Looking at Coronavirus COVID-19 cases in Africa

Looking at Coronavirus COVID-19 cases in Africa

I wanted to build a dashboard to look specifically and the number of COVID-19 cases in Africa and how it is affecting different countries.

Read more


How to create a Virtual Art Gallery in Google Data Studio

How to create a Virtual Art Gallery in Google Data Studio

Since many people are all stuck in Coronavirus lockdowns all over the world at the moment, so I thought I'd have a go at creating a virtual art gallery in Google Data Studio!

Read more


A COVID-19 dashboard in Google Data Studio

A COVID-19 dashboard in Google Data Studio

In this post I will be sharing a dashboard I made focused on COVID-19 cases worldwide.

Read more