Google Data Studio 2020 From Beginner To Advanced

Learn how to create interactive reports, dashboards and do data analysis with Google Data Studio for your Google sheets.

Last updated 2022-01-10 | 4.7

- Connecting Google Data Studio with Data Source
- Understanding Google Data Studio Interface
- How to create Table Visualization in Google Data Studio

What you'll learn

Connecting Google Data Studio with Data Source
Understanding Google Data Studio Interface
How to create Table Visualization in Google Data Studio
Styling
Formatting and Sorting Tables
Optional Metrics and Interactive Filters
Heat Maps
Bar and Conditional Formatting
How to change Methods of Aggregation in Google Data Studio
How to do Comparison Calculation in Google Data Studio
How to do Running Calculation in Google Data Studio
How to use Drill Down Feature in Google Data Studio
How to Create Pivot Table Visualization in Google Data Studio
How to do Calculation in Pivot Table
How to create Scorecard Visualization in Google Data Studio
How to create Filters in Google Data Studio
Working with Date Filters in Google Data Studio
How to create Filters within Visualization
How to do Calculation in Google Data Studio
How to use Case Statement in Google Data Studio
How to create Time Series Visualization in Google Data Studio
Styling and Formatting of the Time Series Graph
How to create Area Graphs in Google Data Studio
How to create Bar and Column Chart in Google Data Studio
Geo Maps and Google Maps Visualization in Google Data Studio
How to create Tree Maps and Bullet Charts in Google Data Studio
How to create Scatter Plot and Bubble Charts in Google Data Studio
How to create Custom Visualization in Google Data Studio
The Concept of Reference Lines and Numeric Sliders
Creating and Sharing Dashboards in Google Data Studio
Data Blending in Google Data Studio
How to work with Blended Data in Google Data Studio
Using Extract Data in Google Data Studio
Using Data Explorer Feature in Google Data Studio

* Requirements

* No. This course covers everything from beginner to advanced

Description

  • Connecting Google Data Studio with Data Source
  • Understanding Google Data Studio Interface
  • How to create Table Visualization in Google Data Studio
  • Styling , Formatting and Sorting Tables
  • Optional Metrics and Interactive Filters
  • Heat Maps, Bar and Conditional Formatting
  • How to change Methods of Aggregation in Google Data Studio
  • How to do Comparison Calculation in Google Data Studio
  • How to do Running Calculation in Google Data Studio
  • How to use Drill Down Feature in Google Data Studio
  • How to Create Pivot Table Visualization in Google Data Studio
  • How to do Calculation in Pivot Table
  • How to create Scorecard Visualization in Google Data Studio
  • How to create Filters in Google Data Studio
  • Working with Date Filters in Google Data Studio
  • How to create Filters within Visualization
  • How to do Calculation in Google Data Studio
  • How to use Case Statement in Google Data Studio
  • How to create Time Series Visualization in Google Data Studio
  • Styling and Formatting of the Time Series Graph
  • How to create Area Graphs in Google Data Studio
  • How to create Bar and Column Chart in Google Data Studio
  • Geo Maps and Google Maps Visualization in Google Data Studio
  • How to create Tree Maps and Bullet Charts in Google Data Studio
  • How to create Scatter Plot and Bubble Charts in Google Data Studio
  • How to create Custom Visualization in Google Data Studio
  • The Concept of Reference Lines and Numeric Sliders
  • Creating and Sharing Dashboards in Google Data Studio
  • Data Blending in Google Data Studio
  • How to work with Blended Data in Google Data Studio
  • Using Extract Data in Google Data Studio
  • Using Data Explorer Feature in Google Data Studio

Course content

17 sections • 45 lectures

How we have designed this course Preview 03:24

In this lecture students will be learning - How we have designed this course

Training Data used in the course Preview 00:03

Let's get our Data in Google Sheet Preview 01:51

In this lecture we will be uploading Data in Google Sheet

Connecting Google Data Studio with Data Source Preview 05:10

In this lecture students will learn how to connect Google Data Studio with a Data Source

Understanding Google Data Studio Interface Preview 04:54

In this lecture students will get an overview of Google Data Studio Interface

How to create Tables Preview 03:24

In this lecture students will be learning about how to create visualization in the form of Tables

Styling , Formatting and Sorting Tables Preview 05:43

Optional Metrics and Interactive Filters Preview 04:55

In this lecture students will learn how to use a feature called Optional Metrics and Interactive Filters

Heat Maps, Bar and Conditional Formatting Preview 05:42

In this lecture students will learn about features called Heat Maps, Bars and Conditional Formatting

How to change Methods of Aggregation in Google Data Studio Preview 04:21

In this lecture students will learn how to change the methods within Google Data Studio

How to do Comparison Calculation in Google Data Studio Preview 02:45

In this lecture students will learn how to do Comparison Calculation in Google Data Studio

How to do Running Calculation in Google Data Studio Preview 03:44

In this lecture students will learn how to do Running Calculation in Google Data studio

How to use Drill Down Feature in Google Data Studio Preview 03:29

In this lecture students will learn how to use the Drill Down Feature in Google Data Studio

Let's Create Pivot Tables in Google Data Studio Preview 03:54

In this lecture students will learn how to create Pivot Table in Google Data Studio

Calculation in Pivot Table Preview 01:58

In this lecture students will learn how to do Calculations in Pivot Table

Scorecards Preview 03:28

In this lecture students will learn about Scorecard Visualization in Google Data Studio

How to create Filters in Google Data Studio Preview 07:11

In this lecture students will learn how to create Filters in Google Data Studio

Date Filters Preview 02:17

In this lecture students will learn how to create Date Filters in Google Data Studio

Creating Filters within Visualization - Part 1 Preview 03:35

In this lecture students will learn how to create Filters with Visualization

Creating Filters within Visualization - Part 2 Preview 03:34

In this lecture we will continue with our learning of how to create Filters with Visualization

Creating Filters within Visualization - Part 3 Preview 02:14

In this lecture we will continue to learn how to create Filters with Visualization

Diving more into the Date Option Preview 02:41

In this lecture we will be diving more into the date feature in Google Data Studio

How to do Calculation in Google Data Studio Preview 04:20

In this lecture students will learn how to do Calculations in Google Data Studio

Visualizing Data through Year/Month/Day Preview 05:56

In this lecture students will learn how to visualize Data through Year/Month/Day

How to use the Case Statement in Google Data Studio Preview 01:39

In this lecture students will learn how to use the Case Statement in Google Data Studio

Previous Period Vs Previous Year- Know the Difference Preview 03:29

In this lecture students will learn that while comparing - What is the Difference between Previous Period and Previous Year

How to create Time Series Graph in Google Data Studio Preview 05:43

In this lecture students will learn how to create a Time Series Graph in Google Data Studio

Modifying Time Periods in the Time Series Graph Preview 02:57

In this lecture students will learn how to change the Time Periods in a Time Series Graph

Styling and Formatting of the Time Series Graph Preview 04:49

In this lecture students will learn about the different styling and Formatting Options in the Time Series Graph

Diving more into the Time Series Chart Preview 03:16

In this lecture we will further dive deep into the Time Series Chart

Area Graph in Google Data Studio Preview 03:14

In this lecture students will learn about the Area Graphs in Google Data Studio

How to create Bar Chart and Column Chart in Google Data Studio Preview 08:24

In this lecture students will learn about the Bar and Column Charts in Google Data Studio

How to create Pie Charts in Google Data Studio Preview 03:11

In this lecture students will learn about the Pie Charts in Google Data Studio

How to create Geo Maps and Google Maps Visualization in Google Data Studio Preview 09:44

In this lecture students will learn how to create Geo Maps and Google Maps in Google Data Studio

How to create Treemap and Bullet Chart in Google Data studio Preview 04:05

In this lecture students will learn about how to create Treemaps and Bullet Charts in Google Data Studio

How to create Scatter Plot and Bubble Chart in Google Data Studio Preview 06:19

In this lecture students will learn how to create Scatter Plot and Bubble Chart in Google Data Studio

Creating Custom Visualization in Google Data Studio Preview 06:34

In this lecture Students will learn how to create Custom Visualization in Google Data Studio

The Concept of Reference Lines and Numeric Sliders Preview 05:11

In this lecture students will learn about the concept of Reference Lines and Numeric Sliders in Google Data Studio

Creating Dashboards in Google Data Studio Preview 06:34

In this lecture students will learn how to create Dashboards in Google Data Studio

How to share Dashboards Preview 04:35

In this lecture students will learn how to share Dashboards

Training Files for Data Blending Preview 00:03

Getting Files Ready for Data Blending Preview 05:32

In this lecture students will learn how to get the files prepared for Data Blending

Working with Blended Data in Google Data Studio Preview 02:44

In this lecture students will learn how to work with Blended Data in Google Data Studio

Using Extract Data feature in Google Data Studio Preview 03:19

In this lecture students will learn how to use the Extract Data feature in Google Data Studio

Using Data Explorer feature in Google Data Studio Preview 06:29

In this lecture students will learn how to use Data Explorer feature in Google Data Studio