Google Data Studio - Master the Advanced Concepts
4.3 (177 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,229 students enrolled

Google Data Studio - Master the Advanced Concepts

Build on your knowledge of Data Studio to make your dashboards more impactful than ever. Connect to BigQuery and more.
4.3 (177 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,229 students enrolled
Created by Annabel Lyle
Last updated 1/2020
English
English [Auto-generated]
Current price: $20.99 Original price: $29.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 16 articles
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will be able to take your Reports to the next level by understanding the advance features in Google Data Studio
  • Transform your data sets using advance Calculated Fields (we explore a wide range of function and conditional case statements)
  • Enhance your data visualiations by using pivot charts, combination charts and hyperlinks and product images in tables
  • Learn how to embed your reports into an external application e.g website or blog
  • Connect to Databases including BigQuery - Learn how to write custom queries in Data Studio
  • Advance Filter options such as Page and Report Level Filters
Requirements
  • Existing Knowledge of Google Data Studio
  • Knowledge of Google Sheets & Google Analytics
  • Knowledge of Excel Formulas and/or Basic SQL Functions
  • Google Account
Description

In this course you'll master the advance features in Google Data Studio, so that you understand all the options available for transforming your data sets and data visualisations into the format you need.

Target Audience

This course is for people who have an intermediate knowledge of Google Data Studio and want to gain advance knowledge.

  • You already have experience with Data Studio
  • You have experience with Functions in Excel and/or Basic knowledge of SQL
  • Want to understand the full range of capabilities that Google Data Studio offers

Curriculum

In this course you will cover in detail:

Visualisations - Pivot Tables, Combination & Dual Axis Charts, Stacked Bar & Area Charts

Layout - How to set global colour palettes

Transforming Data Sets - Transforming Metrics & Dimensions with Calculated Fields and a range of functions that Data Studio supports e.g Median(), Variance(), Percentile(), Concat(), Substr() as well as Case Statements for grouping dimension values together.

Hyperlinks and Clickable images - Adding images and links to data tables to show and link through to your products in your reports

Filters - Group and Page Level filters to add more control to your reports

Embedding - How to embed your reports into an external application or website.

Databases - Connecting to SQL database tables, views and custom queries. We will connect to BigQuery.

Roles

Your role might fall into one of the following

  • Online Marketer

  • Product Analyst

  • Data Analyst

  • Finance Anayst

  • Product Owners/Manager

  • Small business Owner

Data Sources you may already use

Google Analytics,  Adwords or other Google Product

Google Sheets

Excel

SQL Database e.g MySQL, BigQuery, PostGresQL

The Power of Data Studio

  • Intuitive Design - create dashboard designs that are more intuitive than dashboards in GA & Google Sheets
  • 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 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 to master the advance concepts in Google Data Studio so  that you understand the full range of capabilities at your fingertips.

Who this course is for:
  • Users who have a knowledge of Google Data Studio and want to explore the advance topics and capabilities of the Tool
  • Data Analysts
  • Marketing Analysts
  • Business Intelligence Analysts
  • Students who have taken my course 'Build Insightful Dashboards with Google Data Studio'
Course content
Expand all 33 lectures 02:09:40
+ Advance Visualisations in Google Data Studio
6 lectures 21:11
Visualising Data with Pivot Tables
07:42

Now that you've finished learning how to create Pivot Tables, here are a few questions to make sure you understand their capabilities.

QUIZ - Pivot Tables
4 questions
EXERCISE - Pivot Tables
00:44
Combination and Dual Axis Charts to plot multiple metrics on graphs
05:56
EXERCISE - Combination & Dual Axis Charts
00:37
QUIZ - Combination & Dual Axis Charts
3 questions
EXERCISE - Stacked Bar and Area Charts
00:25
+ Personalise your Layout in Data Studio
2 lectures 10:00
Colour Palettes in Data Studio
08:51


EXERCISE - Colour Palettes
01:09
+ Transforming your Data Sets with Functions
10 lectures 44:36
Editing Fields in Reports and Analytical Functions
06:32
EXERCISE - Editing Fields in Reports and Analytical Functions
00:41
Calculated Metrics - Arithmetic
06:00
EXERCISE - Calculated Metrics - Arithmetic
00:53
Transforming Dimensions - Concat(), Upper(), Lower(), Substr() and Date()
09:53
EXERCISE - Transforming Dimensions with Calculated Fields
01:07
Calculated Metrics - More Metric Functions - Avg(), Median(), Percentile()
08:00
EXERCISE - More Metric Functions
01:01
Calculated Fields - Case Statements
09:53
EXERCISE - Case Statements
00:34
+ Hyperlinks and Images in Data Tables
2 lectures 13:09
Hyperlinks and Images in Data Tables
12:05
EXERCISE - Hyperlinks and Images in Data Tables
01:04
+ Advance Filter Options
4 lectures 12:02
Dimension and Metric Filters
06:10
EXERCISE - Dimension and Metric Filters
00:40
Group and Page Level Filters to control how your filters are applied
04:27
SUMMARY - Group and Page Level FIlter Controls
00:45
+ Embedding your Data Studio Reports
2 lectures 07:01
Embedding your Reports in a blog or website
06:29
SUMMARY - Embedding your data Studio Reports
00:32
+ Connecting to Databases with Google Data Studio
4 lectures 14:53
Connecting to BigQuery
06:46
EXERCISE - Connecting to BigQuery
00:55
Databases - Creating Views and Custom SQL Queries
06:16
EXERCISE - Databases - Creating Views and Custom Queries
00:55
+ Final Assignment
0 lectures 00:00
In this assignment you will connect to a BigQuery data set containing data about crime rates in London(UK) and create a Data Studio Report to answer questions for a case study. Your report can contain multiple pages. You should submit the url to your dashboard one you have completed your assignment.
Create a Report to explore London Crime Rates and Consolidate your new Knowledge
5 questions