Visualizing Canadian Visitor Visa Processing Times

Visualizing Canadian Visitor Visa Processing Times

Recently I discovered that according to the Immigration, Refugees and Citizenship Canada (IRCC)'s website the average processing time for a visitor visa to Canada applying from South Africa was a whopping 569 days.

Read more


Comparing Flight Prices between Toronto and other Cities

A while back I took a look at flights on a random date to see how the flight prices out of Toronto compared with other cities. I wanted to do it again to see if the same trend continued.

It did and it seems flights out of Toronto are just insanely expensive.

Read more


Combining Ad Data using Dataform in Google Cloud Platform

Combining Ad Data using Dataform in Google Cloud Platform

In this post I'll be sharing how to combine various ad data sources into a single BigQuery table using Dataform in Google Cloud Platform. This uses fake dummy ad data.

Read more


Interactive Dashboard Wine Farms in the Western Cape

Interactive Dashboard: Wine Farms in the Western Cape

Having visited a couple of wine farms in the Western Cape recently, I thought it might be fun to visualize how many there were.

Read more


Ultimate Ads Dashboard Looker Studio template

The Ultimate Ads Dashboard

The Ultimate Ads Dashboard

Here's a Looker Studio dashboard template you can purchase and download on ByMarketers.

View the Ultimate Ads Dashboard on the ByMarketers website

Read more


200 Food Additives and their Legal Status in Canada, the EU, and the US

200 Food Additives and their Legal Status in Canada, the EU, and the US

Something I've been reading up on lately is the number of Food Additives in various food products. I was curious in the differences in regulations between Canada (where I live), the EU and the USA. I used ChatGPT to compile some data (which I hope is accurate but proceed with caution) and visualized it in an interactive Looker Studio report.

Read more


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


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


North American Sports Teams Data Visualization

All the different sports teams and leagues across the US and Canada had always seemed a bit overwhelming, so I decided to make a report in Looker Studio to visualize which teams from which leagues are in which cities. Hope you enjoy!

Read more

Michael Howe-Ely