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.15 (347 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
2,092
students
2 hours
content
Jan 2020
last update
$49.99
regular price

What you will 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

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.

Content

Introduction

Introduction to the Course and Course Aims

Setting up your Data Sources

Setting up your Data Sources
EXERCISE - Setting up your Data Sources

Advance Visualisations in Google Data Studio

Visualising Data with Pivot Tables
QUIZ - Pivot Tables
EXERCISE - Pivot Tables
Combination and Dual Axis Charts to plot multiple metrics on graphs
EXERCISE - Combination & Dual Axis Charts
QUIZ - Combination & Dual Axis Charts
Stacked Bar and Area Charts for analysing compositions
EXERCISE - Stacked Bar and Area Charts

Personalise your Layout in Data Studio

Colour Palettes in Data Studio
EXERCISE - Colour Palettes

Transforming your Data Sets with Functions

Editing Fields in Reports and Analytical Functions
EXERCISE - Editing Fields in Reports and Analytical Functions
Calculated Metrics - Arithmetic
EXERCISE - Calculated Metrics - Arithmetic
Transforming Dimensions - Concat(), Upper(), Lower(), Substr() and Date()
EXERCISE - Transforming Dimensions with Calculated Fields
Calculated Metrics - More Metric Functions - Avg(), Median(), Percentile()
EXERCISE - More Metric Functions
Calculated Fields - Case Statements
EXERCISE - Case Statements

Hyperlinks and Images in Data Tables

Hyperlinks and Images in Data Tables
EXERCISE - Hyperlinks and Images in Data Tables

Advance Filter Options

Dimension and Metric Filters
EXERCISE - Dimension and Metric Filters
Group and Page Level Filters to control how your filters are applied
SUMMARY - Group and Page Level FIlter Controls

Embedding your Data Studio Reports

Embedding your Reports in a blog or website
SUMMARY - Embedding your data Studio Reports

Connecting to Databases with Google Data Studio

Connecting to BigQuery
EXERCISE - Connecting to BigQuery
Databases - Creating Views and Custom SQL Queries
EXERCISE - Databases - Creating Views and Custom Queries
Final Assignment

Screenshots

Google Data Studio - Master the Advanced Concepts - Screenshot_01Google Data Studio - Master the Advanced Concepts - Screenshot_02Google Data Studio - Master the Advanced Concepts - Screenshot_03Google Data Studio - Master the Advanced Concepts - Screenshot_04

Reviews

W
March 22, 2023
Perhaps it's a bit relative, but I was not expecting this level of content for "advanced" data studio. But maybe times have changed since four years ago. This content largely is covered by most courses at the introductory level.
Rita
January 30, 2023
Not so advanced as I thought, I really knew almost everything. Also, it is not updated and seems to be recorded a lot of years ago!
Rajiba
August 24, 2022
This Course is not advanced. there are a lot of things missing. This course focus for basic overview of google data studio.
Marianne
June 3, 2022
It was great up until the connect to external DB module. Here, my interface Google Cloud Platform did not align with the instructor. Consequently, I was not able to follow along and missed all of the learning there.
Tarak
February 1, 2022
it was a good course i was happy to learn to formulas and queries i can add to my reports to make my data analysis more in depth. overall i got what i paid for :)
Ibrahim
October 13, 2021
Very good chapter on Pivot tables and great start to the course so far. However, a bit more context was needed to know which Google Analytics data set to connect to i.e. G4 - Google merchandising or UA Google merchandising.
Ravi
June 30, 2021
I had learnt, Basics of Google studio. I was eagerly waiting for advanced skills in google studio. Ultimately I got it here. Thanks a lot
Christopher
April 22, 2021
Course work is outdated. It was difficult to follow along with it due to this. Some sections were impossible to follow.
Agnieszka
March 30, 2021
Świetnie pokazujący wiele użytecznych funkcji, brakowało mi jedynie rozbudowanej sekcji o blended data, gdzie jest to czasem trochę tricky.
Alexis
February 7, 2021
Overall the information provided throughout the course was helpful. There are times when I felt the level of detail/depth regarding how to do a something, or what the variations of how to do something might look. I highly recommend to anyone looking to further their Data Studio skillset.
Carlos
January 10, 2021
Well explained, detailed, step by step usecases with real life reports. With a good UI in each report, which is something lacking in similar courses. After going through several other SQL and Data Studio courses, I like this course very much, I'm impressed and look forward to other classes by this teacher. I would probably focus more on the CASE statement and other SQL uses within Data Studio (with the respective table for each), as this course is not intended for people with knowledge in SQL and I believe is what would be "the most advanced" use of the tool. Great Job!
Bent
November 2, 2020
I could expand my knowledge and i found out how to use many of the great possibilities that Data Studios offers for Visualisations!
M
June 27, 2020
Very good course. Though the layout for GDS is old but still the content is relevant. Most importantly, it is only course which talks about advanced concepts while all others start and end the course by telling basic stuff.
Loke
May 14, 2020
Learned a few things in this course. However the lecturer voice a bit too soft. And the Google Data Studio is 2 years old UI - different from current, so need to adjust. Not to mention the web site's thumbnail URL already changed to Custom Field formulas issues mentioned (Aggregated Functions) are not an issue, however not have different issues.
Kaustubh
March 1, 2020
Data Blending was completely missing. It is a very important part of Data Studio that isnt covered here.

Charts

Price

Google Data Studio - Master the Advanced Concepts - Price chart

Rating

Google Data Studio - Master the Advanced Concepts - Ratings chart

Enrollment distribution

Google Data Studio - Master the Advanced Concepts - Distribution chart
1604286
udemy ID
3/18/2018
course created date
7/14/2019
course indexed date
Bot
course submited by