Build Insightful Dashboards with Google Data Studio
4.8 (8 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.
155 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 (8 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.
155 students enrolled
Created by Annabel Lyle
Last updated 8/2017
Current price: $10 Original price: $60 Discount: 83% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 17 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

The Power of Data Studio

  • Automate all of those gnarly reports you have in excel (with broken formulas) that you've been manually updating
  • Scale your insights, by answering questions once through dashboards and reports that can be shared with others and will automatically update
  • Speed up time to insight, by building reports and data visualisations to answer your questions within minutes
  • Build user friendly Templates and Layouts that will make it easier for users to interpret the data.

Data Studio is a new Data Visualisation Tool created by Google that is now 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, and create powerful and interactive dashboards for you to explore your underlying data.

It's an incredible tool for helping communicate trends and insights in your 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 create meaning from the data they have available by communicating insights through great dashboards.

And 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

  • Or maybe a type of Relational databases e.g SQL, BigQuery

Data Studio is built on 3 Key Pillars which are;

1. Connecting to multiple data sources

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

3. Sharing dashboards for collaboration and communicating insights.

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 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
Course summary and next steps
1 Lecture 01:39
What you have Learned and Final words
1 Lecture 00:49
Data Studio Help Forum & Requesting Features
About the Instructor
Annabel Lyle
4.8 Average rating
8 Reviews
155 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.