Mapping all WWE pay per view events in Looker Studio

In this post I'll show you a Looker Studio dashboard I've built that lets you view all of WWE's pay per view events over the last 40 years.

Read more


Looker Studio connection map

How to make a Looker Studio Connection Map

In this blog post I'll show you how to build a Connection Map in Looker Studio. A Connection Map is a type of Google Map in Looker Studio that allows you to map a line between two points on a map.

Read more


Four in One Analytics Looker Studio Dashboard Template

Four in One Analytics Looker Studio Dashboard Template

I recently released a new Looker Studio dashboard template on ByMarketers which includes Google Analytics, Search Console, Google Ads and YouTube Analytics data. ByMarketers is a site on which you can download many different digital marketing templates & resources.

Read more


Visualizing Fertility Rates across the World

Visualizing Fertility Rates across the World

I've seen quite a few blogs and videos discussing declining fertility rates and the resulting population decline across the world, so I thought it would be interesting to explore some World Bank data on the topic. These visualizations are based on the Total Fertility Rate metric within the World Bank's World Development Indicators public data set available in Google BigQuery.

Read more


GDP per Capita within African Regions

GDP per Capita within African Regions

In this blog post I'll explore GDP per capita within the regions of Africa.

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


Analyzing South African Crime data using ChatGPT

Analyzing South African Crime data using ChatGPT

A few years ago I published a blog post analyzing Crime data from the South African Police Service (SAPS) in a blog post. You can read it here. I thought it might be interesting to run the data from Open AI's ChatGPT and see what it analysis it produces.

Read more


Visualizing ESKOM Loadshedding Data

Visualizing ESKOM Loadshedding Data

In this post I'll share some visualizations of ESKOM Loadshedding data created in Looker Studio (Google Data Studio). Load shedding in South Africa is a method used by the country's primary power utility, Eskom, to prevent the national electric grid from total collapse. This becomes necessary when the demand for electricity exceeds available supply.

Read more


Visualizing GA4 Geographic Data with Python

Visualizing GA4 Geographic Data with Python

In this post I just wanted to show a couple of basic examples of how you can display Google Analytics 4 data using Python.

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