Google Data Studio - Master the Advanced Concepts (Udemy.com)
Build on your knowledge of Data Studio to make your dashboards more impactful than ever. Connect to BigQuery and more.
Created by: Annabel Lyle
Last updated January 2020
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
Course 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.
Instructor Details
- 4.1 Rating
350 Reviews
Annabel Lyle
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.
More courses by Annabel Lyle
Learn SQL for Data Analysis with Google Big Query (2019)
4.3 (3,834 Reviews)
Provider: Udemy
Time: 2h
$49.99
Design Principles for Effective Dashboard Design (2018)
4.2 (3,325 Reviews)
Provider: Udemy
Time: 54 mins
$10.99
Build Insightful Dashboards with Google Data Studio (2019)
4.0 (928 Reviews)
Provider: Udemy
Time: 2.4h
$11.99
More Data Analysis courses
Complete neural signal processing and analysis: Zero to hero (2026)
4.8 (2,013 Reviews)
Provider: Udemy
Time: 46.9h
$12.99
Excel for Business Analysts Online Course (2023)
4.8 (636 Reviews)
Provider: Udemy
Time: 9.3h
$74.99
Alteryx Designer Advanced Certification Mega Bundle (2023)
4.8 (468 Reviews)
Provider: Udemy
Time: 16.9h
$69.99
The Complete SQL Bootcamp : From Beginner to Advanced (2026)
4.8 (130 Reviews)
Provider: Udemy
Time: 14.2h
$19.99
Reviews
By W Chang on 3/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.
By Ibrahim Basmer on 10/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.
By Alexis Campestre on 2/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.
By Carlos Andrés Campo González on 1/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!
By M Imran Malik on 6/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.
By Loke Seng Choe on 5/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.
By Thomas Synnott on 2/9/2020
Excellent layout, presenting and describing the various elements from the advanced POV. Having done a beginner course, this really was a step up to more utilization of the more complex GDS functionalities. One slight drawback, is the speed that is taken going through. it is quite fast. You do need to have prior knowledge of GDS before undertaking this module. Overall great job!
By António Castilho Anjos on 6/14/2019
Faz uma abordagem rápida a técnicas mais sofisticadas incluindo o uso do BigQuery o que me parece mais consentâneo com uma utilização profissional. As legendas não estão muitos corretas, havendo muitos erros relativamente ao que a instrutora diz. Em muitos momentos as legendas tornam difícil a perceção do curso, principalmente para um não nativo.
By Matias Rodriguez on 1/10/2019
Muy buen curso de Data Studio para seguir profundizando en algunas herramientas como conectar con BigQuery. Habría que seguir actualizando el curso porque van apareciendo nuevas funcionalidades dentro de las actualizaciones periódicas de Data Studio. Muchas gracias Annabel!
By Jeremy Templer on 4/30/2018
Have yet to find any other course aimed at Intermediate to Advanced Data Studio users, but Annabel's course fits the description. Good delivery, and great tips - I've used the program a lot but this course has taught me some new things.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 82 / 100









