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.
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.
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.
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."