How to export GA4 data to BigQuery and view it in Looker Studio
In this post I'll show you how to export your GA4 data to BigQuery and then view it in Looker Studio (formerly Data Studio).
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.
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.
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.
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.
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.
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.
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!
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.
Use SQL Queries in BigQuery to extract data for use in Google Sheets
In this post I'll describe how you can use SQL queries in BigQuery to extract relevant data and transfer it to Google Sheets.