Build Insightful Dashboards with Google Data Studio
4.8 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
255 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Build Insightful Dashboards with Google Data Studio to your Wishlist.

Add to Wishlist

Build Insightful Dashboards with Google Data Studio

Create powerful data visualisations within minutes from google analytics and google sheets to speed up time to insight
4.8 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
255 students enrolled
Created by Annabel Lyle
Last updated 9/2017
English [Auto-generated]
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 18 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Connect to a range of Data Sources (Google Analytics, Google Sheets, Excel, SQL Database)
  • Get started with a FREE Data Studio Account
  • Create and customise a range of data visualisations (scorecards, time series charts, bar charts, area charts, tables)
  • Create re-usable report templates that follow best practice principles to share with collegues
  • Create advance visualisations (maps, scatter charts, bullet charts)
  • Add dynamic date and dimension filters to make dashboards interactive
  • Tell powerful stories from your data
  • Confidently create interactive analytical dashboards with your own Data
View Curriculum
  • A google or gmail account
  • Any experience with Google Analytics, Google Sheets or Excel will be helpful


  • Tracking Usage of your Google Analytics Reports

This course also now supports Captions in English to help support your learning.

The Power of Data Studio

  • Automate all those Excel Reports (with broken formulas) that you have been manually updating
  • Scale your insights - build shareable dashboards saved in Google Drive
  • Speed up time to insight - build reports and visualisations to answer questions within minutes
  • User friendly Templates and Layouts - will make it easier for users to interpret the data.

Data Studio is a new Data Visualisation Tool created by Google. It is part of the Google Suite including Google Docs, Google Sheets and Google Slides.

Data Studio is FREE and allows you to connect to a range of data sources.

It's an incredible tool to create powerful and interactive dashboards for you to explore your underlying data.

I look forward to showing you how powerful Data Studio is for speeding up time to insight.

Target Audience

This course is for anyone who wants to learn how to find meaning from their data and communicating insights through great dashboards.

Your role might fall into one of the following

  • Online Marketer

  • Product Analyst

  • Data Analyst

  • Product Owners/Manager

  • Small business Owner

Data Sources you may already use

  • Google Analytics,  Adwords or other Google Product

  • Google Sheets

  • Excel

  • Relational databases e.g SQL, BigQuery

Data Studio has 3 Key Pillars which are;

1. Connecting to many data sources

2. Visualising data through a range of customisable reports and widgets 

3. Sharing dashboards for collaboration and communicating insights.


  • Prepare your data in Google Sheets for Data Studio
  • Connecting Google Sheets to Data Studio
  • Connect your own Google Analytics Data to Power your reports

Who is the target audience?
  • Anyone who wants to learn how to tell stories from data using dashboards
  • Improve your analytical skills and capabilities
  • Automate Manual reports based in Excel/Google Sheets
  • Users of Google Analytics, Google Sheets, Excel or a Database
  • Data Analysts/Online Marketers/Product Owners/ Business Intelligence Analysts/Business Owners
Compare to Other Google Data Studio Courses
Curriculum For This Course
41 Lectures
Introduction to the Course and Data Studio
1 Lecture 02:58

An overview of the key topics and goals in this course and the skills you will have gained at the end of it.

Preview 02:58
Get familiar with Data Studio
8 Lectures 18:11

An Introduction to Data Sources

EXERCISE - More about Data Sources

Connecting to Google Analytics

EXERCISE - Connecting your own Google Analytics Data

The Reporting Interface

EXERCISE - Customising your Layout
Your first Dashboard and Beyond
13 Lectures 32:37

EXERCISE - Additional Scorecard Customisations

Time Series Charts for Analysing Trends

EXERCISE - More Options for Time Series Charts

Bar Charts for making Comparisons

EXERCISE - Bar Chart Options

Tables for Presenting Detail

EXERCISE - Customise your Tables

Add new pages to your Report

Use a Pie Chart (if you really need to) to show Categorical Data

The Pie Chart Data Visualisation is great for showing additional details about your data for reference.

You have learnt to customise Tables by:

  • Adding in multiple metrics - you can add a maximum of 10 (though that's a lot of data for someone to understand)
  • Adding in comparisons with % changes - comparisons help add context to your data
  • Showing and Hiding Row numbers - it's helpful to show them when you're interested in Rank
  • Showing and hiding pagination (the ability to click through to another page of data within the table) - Pagination is useful if there is useful data past the first page of results
  • How to Change the number of Rows shown per page in the table
  • Changing the colour of the header background

Below are some things you can try out to customise your tables even further.

In the Style Tab

  • Wrap the text so that you can see the full descriptions of the products without the ellipsis i.e the ...
  • Set the decimal precision of Columns 1 and 2 to 0 decimal places
  • For column 2 show the absolute change rather than the % change
  • Set the odd-row colour to grey

That's tables for you!

EXERCISE - Pie Chart Customisation

Add an Area Chart to segment your data

EXERCISE - 100% Stack your Area Chart
Make your Dashboards Interactive with Filters
4 Lectures 08:11
Filtering by Date

EXERCISE - Date Range Filters

Filtering by Dimensions

EXERCISE - Dimension Filters
Advance Data Visualisations
7 Lectures 22:31
The Map Visualisation

EXERCISE - More about Maps

Exploring Data with Scatter Charts

EXERCISE - Scatter Charts

EXERCISE - Everything to know about Bullet Charts

Adding Heatmaps and Bar Charts to Tables
Sharing your dashboard
2 Lectures 03:35
Sharing your Reports

Exercise - Accessing your Dashboards in Google Drive
Data Sources - Connect your Google Analytics Data
1 Lecture 03:41
Data Sources - Connect your Google Analytics Data
Data Sources - Connecting Google Sheets to Data Studio
2 Lectures 12:29
Preparing Data in Google Sheets

Connecting Google Sheets to Data Studio
Course summary and next steps
1 Lecture 01:39
What you have Learned and Final words
2 Lectures 02:06
Data Studio Help Forum & Requesting Features

Tracking Usage of your Data Studio Reports
About the Instructor
Annabel Lyle
4.8 Average rating
18 Reviews
255 Students
1 Course
Data Analyst - Data Studio & Google Analytics

My name is Annabel and I have over 5 years of experience as a Data Analyst within Marketing and Product Teams. I have also mentored and taught individuals  and teams how to get the most out of a range of data visualisation tools, to ensure they have the greatest impact. My expertise is in storytelling with data, data visualisation and data analysis. Key tools that I teach and work with include Data Studio, Google Analytics, Google Tag Manager and R Studio.