Google Data Studio – Master the Advanced Concepts

Google Data Studio – Master the Advanced Concepts, available at $49.99, has an average rating of 4.05, with 33 lectures, 2 quizzes, based on 349 reviews, and has 2104 subscribers.

You will learn about 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 This course is ideal for individuals who are Users who have a knowledge of Google Data Studio and want to explore the advance topics and capabilities of the Tool or Data Analysts or Marketing Analysts or Business Intelligence Analysts or Students who have taken my course 'Build Insightful Dashboards with Google Data Studio' It is particularly useful for Users who have a knowledge of Google Data Studio and want to explore the advance topics and capabilities of the Tool or Data Analysts or Marketing Analysts or Business Intelligence Analysts or Students who have taken my course 'Build Insightful Dashboards with Google Data Studio'.

Enroll now: Google Data Studio – Master the Advanced Concepts

Summary

Title: Google Data Studio – Master the Advanced Concepts

Price: $49.99

Average Rating: 4.05

Number of Lectures: 33

Number of Quizzes: 2

Number of Published Lectures: 33

Number of Published Quizzes: 2

Number of Curriculum Items: 36

Number of Published Curriculum Objects: 36

Original Price: £24.99

Quality Status: approved

Status: Live

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

Who Should Attend

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'

Target Audiences

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'

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to the Course and Course Aims

Chapter 2: Setting up your Data Sources

Lecture 1: Setting up your Data Sources

Lecture 2: EXERCISE – Setting up your Data Sources

Chapter 3: Advance Visualisations in Google Data Studio

Lecture 1: Visualising Data with Pivot Tables

Lecture 2: EXERCISE – Pivot Tables

Lecture 3: Combination and Dual Axis Charts to plot multiple metrics on graphs

Lecture 4: EXERCISE – Combination & Dual Axis Charts

Lecture 5: Stacked Bar and Area Charts for analysing compositions

Lecture 6: EXERCISE – Stacked Bar and Area Charts

Chapter 4: Personalise your Layout in Data Studio

Lecture 1: Colour Palettes in Data Studio

Lecture 2: EXERCISE – Colour Palettes

Chapter 5: Transforming your Data Sets with Functions

Lecture 1: Editing Fields in Reports and Analytical Functions

Lecture 2: EXERCISE – Editing Fields in Reports and Analytical Functions

Lecture 3: Calculated Metrics – Arithmetic

Lecture 4: EXERCISE – Calculated Metrics – Arithmetic

Lecture 5: Transforming Dimensions – Concat(), Upper(), Lower(), Substr() and Date()

Lecture 6: EXERCISE – Transforming Dimensions with Calculated Fields

Lecture 7: Calculated Metrics – More Metric Functions – Avg(), Median(), Percentile()

Lecture 8: EXERCISE – More Metric Functions

Lecture 9: Calculated Fields – Case Statements

Lecture 10: EXERCISE – Case Statements

Chapter 6: Hyperlinks and Images in Data Tables

Lecture 1: Hyperlinks and Images in Data Tables

Lecture 2: EXERCISE – Hyperlinks and Images in Data Tables

Chapter 7: Advance Filter Options

Lecture 1: Dimension and Metric Filters

Lecture 2: EXERCISE – Dimension and Metric Filters

Lecture 3: Group and Page Level Filters to control how your filters are applied

Lecture 4: SUMMARY – Group and Page Level FIlter Controls

Chapter 8: Embedding your Data Studio Reports

Lecture 1: Embedding your Reports in a blog or website

Lecture 2: SUMMARY – Embedding your data Studio Reports

Chapter 9: Connecting to Databases with Google Data Studio

Lecture 1: Connecting to BigQuery

Lecture 2: EXERCISE – Connecting to BigQuery

Lecture 3: Databases – Creating Views and Custom SQL Queries

Lecture 4: EXERCISE – Databases – Creating Views and Custom Queries

Chapter 10: Final Assignment

Instructors

Annabel Lyle
Data Analyst – Data Studio & Google Analytics

Rating Distribution

1 stars: 7 votes
2 stars: 12 votes
3 stars: 46 votes
4 stars: 114 votes
5 stars: 170 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu