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

NEW LECTURES! (SEPT 2017) 

  • 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.

NEW LECTURES (AUG 2017)

  • 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
01:47:46
+
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
+
Data Sources - Connect your Google Analytics Data
1 Lecture 03:41
Data Sources - Connect your Google Analytics Data
03:41
+
Data Sources - Connecting Google Sheets to Data Studio
2 Lectures 12:29
Preparing Data in Google Sheets
06:07

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

Tracking Usage of your Data Studio Reports
01:16
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.