Visualizing a young Africa and an aging World

Visualizing a young Africa and an aging World

In this post I'll be looking at data showing a young Africa and an aging world. The charts are based on World Bank Indicators data/ I used Looker Studio to connect to the dataset in BigQuery and visualized it.

Read more


Africa's GDP Growth Over Time

Africa's GDP Growth Over Time

I was interest in exploring some World Bank Indicators data to look at Africa's changing GDP over time. So I used Looker Studio to connect to the dataset in BigQuery and visualized the data.

Read more


YouTube Analytics Looker Studio Dashboard Template

YouTube Analytics Looker Studio Dashboard Template

I've made a YouTube Analytics template for Looker Studio that you can download from the ByMarketers website. I used YouTube Analytics data from my own small channel where I've messing around with AI generated images.

Here is the link to view the YouTube Analytics template.

Read more


How to map Growth in Google Analytics sessions by Country in Data Studio

Google Data Studio has always had the ability to add in a comparison column to tables, but not to map out a change in values on a map. Ideally I would want to be able to see which countries have seen the highest rates of growth over a period of time. This is a method that worked for me and hopefully it will be useful for you too!

Read more


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


Comparing Geo Maps and Google Maps in Google Data Studio

Comparing Geo Maps and Google Maps in Google Data Studio

I thought I'd put together a blog post comparing Geo Maps and Google Maps and looking at the advantages and disadvantages of both when displaying geographic data in Google Data Studio.

Read more


How to filter values using Metric Sliders in Google Data Studio

How to filter values using Metric Sliders in Google Data Studio

So in this post I'll just run through how you can use Metric Sliders in Google Data Studio to filter values in charts and tables in your reports.

Read more


Use Google Sheets to pull data from Wikipedia to Google Data Studio

Use Google Sheets to pull data from Wikipedia into Google Data Studio

So in this post I'll show you how to use Google Sheets to pull data from Wikipedia to use in Google Data Studio.

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 the Average Monthly Temperatures of Cities in Google Data Studio

Compare the Average Monthly Temperatures of Cities in Google Data Studio

In this post I'll share a Data Studio report I made that lets you Compare the Average Monthly Temperatures of Cities around the world.

Read more