Google Data Studio Master The Advanced Concepts
Tags: Google Data Studio
Build on your knowledge of Data Studio to make your dashboards more impactful than ever. Connect to BigQuery and more.
Last updated 2022-01-10 | 4.6
- 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
What you'll learn
* 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
10 sections • 36 lectures
Introduction to the Course and Course Aims Preview 03:04
An introduction to the aims and content of this course.
Setting up your Data Sources Preview 03:08
EXERCISE - Setting up your Data Sources Preview 00:34
Visualising Data with Pivot Tables Preview 07:42
QUIZ - Pivot Tables
Now that you've finished learning how to create Pivot Tables, here are a few questions to make sure you understand their capabilities.
EXERCISE - Pivot Tables Preview 00:44
Combination and Dual Axis Charts to plot multiple metrics on graphs Preview 05:56
EXERCISE - Combination & Dual Axis Charts Preview 00:37
QUIZ - Combination & Dual Axis Charts
Stacked Bar and Area Charts for analysing compositions Preview 05:46
EXERCISE - Stacked Bar and Area Charts Preview 00:25
Editing Fields in Reports and Analytical Functions Preview 06:32
EXERCISE - Editing Fields in Reports and Analytical Functions Preview 00:41
Calculated Metrics - Arithmetic Preview 06:00
EXERCISE - Calculated Metrics - Arithmetic Preview 00:53
Transforming Dimensions - Concat(), Upper(), Lower(), Substr() and Date() Preview 09:53
EXERCISE - Transforming Dimensions with Calculated Fields Preview 01:07
Calculated Metrics - More Metric Functions - Avg(), Median(), Percentile() Preview 08:00
EXERCISE - More Metric Functions Preview 01:01
Calculated Fields - Case Statements Preview 09:53
EXERCISE - Case Statements Preview 00:34
Hyperlinks and Images in Data Tables Preview 12:05
EXERCISE - Hyperlinks and Images in Data Tables Preview 01:04
Dimension and Metric Filters Preview 06:10
EXERCISE - Dimension and Metric Filters Preview 00:40
Group and Page Level Filters to control how your filters are applied Preview 04:27
SUMMARY - Group and Page Level FIlter Controls Preview 00:45
Embedding your Reports in a blog or website Preview 06:29
SUMMARY - Embedding your data Studio Reports Preview 00:32
Connecting to BigQuery Preview 06:46
EXERCISE - Connecting to BigQuery Preview 00:55
Databases - Creating Views and Custom SQL Queries Preview 06:16
EXERCISE - Databases - Creating Views and Custom Queries Preview 00:55
Create a Report to explore London Crime Rates and Consolidate your new Knowledge
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.