How to Translate Survey Responses using Google Sheets
In this blog post I'll show you how to translate survey responses using Google Sheets!
Let's assume you have a survey running in which the responses may be in multiple languages. What's the easiest way to quickly and simply translate them to a language you're more comfortable with?
In this post I'll show you how you can use some Google Sheets formulas to translate survey responses.
Creating an Avengers Dashboard in Google Data Studio: Part 1
Since Avengers: Endgame is almost upon us, I thought why not look back at the previous Marvel Cinematic Universe movies using Google Data Studio.
Since 2008, Marvel has released 21 films featuring their iconic superhero characters. I thought that for the first dashboard, I'd take a look at each film individually.
How to calculate Conversion Rates in Google Data Studio
In this post I'll give you a quick example on how to calculate Conversion Rates in Google Data Studio.
Thanks to Lee Hurst (aka Helpful Lee) I know that the correct formula to calculate a conversion rate is;
How to add Images to a table in Google Data Studio
In this post I'll show how you can add images to a table in Google Data Studio.
I need to thank Lee Hurst @Helpfullee for introducing me to this method. I came across it in his excellent Data Studio Resource finder.
Visualizing Geographic Data using Google Data Studio
In this blog post I'll provide some examples of how to visualize Geographic data using Google Data Studio.
How to create a Currency Conversion dashboard in Google Data Studio
To illustrate how the currency feature works, I will show how to use Google Sheets and Google Data Studio to create a currency dashboard.
Google Sheets has many useful functions. One of these is it's currency conversion formula that allows users to get a live conversion rate between different currencies.
How to integrate Typeform, Google Sheets and Google Data Studio
Below is a Typeform survey. Feel free to fill it in. The results of this survey are automatically sent to a Google sheet. They are then sent to a Google Data Studio report, which you will see if you scroll down.