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
English
Current price: $10 Original price: $60 Discount: 83% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • A google or gmail account
  • Any experience with Google Analytics, Google Sheets or Excel will be helpful
Description

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
01:30:23
+
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
02:15

EXERCISE - More about Data Sources
00:35

Connecting to Google Analytics
03:05

EXERCISE - Connecting your own Google Analytics Data
00:59

The Reporting Interface
06:23

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

EXERCISE - Additional Scorecard Customisations
00:46

Time Series Charts for Analysing Trends
05:18

EXERCISE - More Options for Time Series Charts
00:39

Bar Charts for making Comparisons
03:52

EXERCISE - Bar Chart Options
00:33

Tables for Presenting Detail
04:50

EXERCISE - Customise your Tables
00:45

Add new pages to your Report
02:14

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

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
00:39

Add an Area Chart to segment your data
02:16

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

EXERCISE - Date Range Filters
00:51

Filtering by Dimensions
03:16

EXERCISE - Dimension Filters
00:39
+
Advance Data Visualisations
7 Lectures 22:31
The Map Visualisation
04:57

EXERCISE - More about Maps
00:38

Exploring Data with Scatter Charts
05:26

EXERCISE - Scatter Charts
00:50


EXERCISE - Everything to know about Bullet Charts
00:18

Adding Heatmaps and Bar Charts to Tables
05:40
+
Sharing your dashboard
2 Lectures 03:35
Sharing your Reports
02:23

Exercise - Accessing your Dashboards in Google Drive
01:12
+
Course summary and next steps
1 Lecture 01:39
What you have Learned and Final words
01:39
+
BONUS
1 Lecture 00:49
Data Studio Help Forum & Requesting Features
00:49
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.