How to build a custom Google Map in Data Studio using Google Sheets and Geocode

How to build a custom Google Map in Data Studio using Google Sheets and Geocode

In this post I'll show a way of creating a detailed, custom Google Map in Google Data Studio.

So let's say you have a list of Addresses that you'd like to map out in Data Studio. What are the steps to get this done? I'll go over how you can do this using Google Sheets, the Geocode add-on and the newly released Google Maps chart type in Data Studio.

Read more


How to build a Twitter dashboard in Google Data Studio using IFTTT

How to build a Twitter dashboard in Google Data Studio using IFTTT

A while back I wrote a post about how to build a Twitter dashboard in Google Data Studio. Unfortunately it seems that that version no longer works, or if it does work is very buggy. But I have discovered a new way of getting tweets into Data Studio so figured I'd write a new post about how to do it.

Read more


How to create a five year Currency Exchange Rate report in Google Data Studio

How to create a five year Currency Exchange Rate report in Google Data Studio

In this post I'll show you how to make Currency Exchange Rate report in Google Data Studio showing five years worth of data.

Before I begin I owe a big thank you to Lee Hurst, who helped me figure out how to fix some issues in Google Sheets.

Read more


How to Send Emails using a VBA macro in Excel

How to Send Emails using a VBA macro in Excel

Here is a method for how to send Emails using a VBA macro in Excel. In this post, I won't go through a step by step guide on how sending emails using Excel is possible using macros and VBA options in Microsoft Excel.

This is because the spreadsheet template I would like to share was created for a very specific purpose, and is unlikely to be useful to the average blog reader.

Read more