How to analyse sales data using Google BigQuery and Data Studio

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

Read more


Build a Google Data Studio report using BigQuery Public Data-Sets

Build a Google Data Studio report using BigQuery Public Data-Sets

In this post I'll show you how to build a dashboard using one of the many Public data-sets available to users in BigQuery.

Read more


How to make a simple Ecommerce dashboard in Google Data Studio

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.

Read more


How to use Conditional Formatting in Google Data Studio

How to use Conditional Formatting in Google Data Studio

Today I'll take a first look at the recently launched Conditional Formatting in Google Data Studio.

Read more


Create Custom Channel Groupings in Google Data Studio using CASE statements

In this post I'll discuss how to create custom channel groupings in Google Data Studio using CASE statements.

Read more


A Top Content report in Google Data Studio

How to make a Top Content report in Google Data Studio

In this post I'll show you how to make a top content report in Google Data Studio. This report shows you how the top pages on your site perform, based on your choice of sessions, users, page views, bounce rate or average time on page.

Read more


How to Compare Google Analytics segments in Data Studio

How to Compare Google Analytics segments in Data Studio

In this post I'll show you how you can compare Google Analytics segments in Google Data Studio.

In Data Studio we can use CASE statements to create our own segments, but there is also the option to use pre-existing segments that we've created in Google Analytics.

Read more


Humans of Data Studio (2)

Humans of Data Studio

Some fun with Data Studio, making a Humans of New York style report with a face, a location and a quote.

Read more


Using Data Studio as a Inspirational Poster Generator

Using Data Studio as a Inspirational Poster Generator

I wanted to have a bit of fun with Google Data Studio, so created an inspirational poster generator!

Hope you enjoy!

Read more


How to Measure Accordion Clicks in Google Data Studio

How to Measure Accordion Clicks in Google Data Studio

In a previous post I described how you can Track Accordion Clicks using Google Tag Manager. In this post I'll show how you can measure accordion clicks in Google Data Studio.

Read more