Use SQL Queries in BigQuery to extract data for use in Google Sheets
In this post I'll describe how you can use SQL queries in BigQuery to extract relevant data and transfer it to Google Sheets.
How to make a Stock Market dashboard in Google Data Studio
In this post I'll explain the steps to creating a Stock Market dashboard in Google Data Studio. This will display the prices of shares in companies.
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.
How to add a Feedback form to Google Data Studio
In this post I'll show you how to add a Feedback Form to Google Data Studio.
This will allow you and your team to post feedback about the Data Studio report, as well as to note any annotations or make comments on the data itself.
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.
How to display Google Form results in Data Studio
In this post I'll show you how to display Google Form results in Data Studio.
Google Forms are very useful for informal market research, gathering opinions on social media and deciding where to go for the office Christmas party!
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.
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.