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


Mapping all Formula 1 Grand Prix Races

In this post I'll show you a data visualization showing all of the Formula 1 Grand Prix that have taken place over the years. I've built it in Looker Studio.

Read more


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


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


Testing out ChatGPT Code Interpreter

Testing out ChatGPT Code Interpreter

I just wanted to document my first interactions with ChatGPT's new Code Interpreter.

I used a data set from the Toronto Police Service Public Safety Data Portal.

This is a screenshot of what the data looks like in the CSV file I downloaded.

CSV file toronto crime data

1. Describing the Dataset itself

I asked the Code Interpreter "Can you provide some insights about crime in Toronto based on this data?"

There is a lot going on under the hood which you take a look at, as shown below. ChatGPT uses Python code to create the visualizations.

ChatGPT uses Python code to create the visualizations.

2. Analyzing the Data

ChatGPT provides some analysis of the data.

3. Visualizing the Data

The real cool stuff when ChatGPT visualizes the data. The following were created as image files.

4. Asking ChatGPT for some Unusual Visualizations

I asked ChatGPT for some unusual or interesting data visualizations and it gave me the following;

WordCloud for Neighbourhoods: This word cloud represents the frequency of homicides in various neighbourhoods. The size of each neighbourhood name in the word cloud corresponds to the frequency of homicides in that neighbourhood. Larger names correspond to neighbourhoods with more incidents. This visualization provides an immediate visual understanding of the areas with the most frequent incidents.

Donut Plot for Crime Type: This donut plot provides a visual breakdown of the types of homicides in the dataset. The size of each section corresponds to the frequency of each type of homicide, with labels and percentages for clarity. This visualization provides a clear and immediate understanding of the most common types of homicides.

My Other Blog Posts

If you liked this you might enjoy my other blog posts.


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


ChatGPT-4 created and visualized the top 30 Wine Farms near Cape Town

ChatGPT-4 created and visualized the top 30 Wine Farms near Cape Town

Below is an interactive map showing the top 30 wine farms surrounding. I created it relatively quickly using ChatGPT-4!

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 use Google Maps in Google Data Studio

How to use Google Maps in Google Data Studio

Yesterday Google Data Studio launched a cool new feature - Google Maps as a chart type! This is major game changer for Data Studio and opens up a lot of possibilities.

Read more