Ultimate Guide To Google Data Studio 2021

Learn how to analyse your data and create stunning interactive dashboards with Google's Business Intelligence tool

Last updated 2022-01-10 | 4.7

- Taught by a Business Intelligence pro with over 25 years' experience working with data
- Build stunning
- automated
- interactive dashboards and reports that effectively communicate your data
- Learn how to manage
- structure
- prepare and connect to data for analysis

What you'll learn

Taught by a Business Intelligence pro with over 25 years' experience working with data
Build stunning
automated
interactive dashboards and reports that effectively communicate your data
Learn how to manage
structure
prepare and connect to data for analysis
Construct all kinds of data queries and visualisations
from basic to advanced
Write custom calculated formulas using functions to dig deeper into your data
Learn how to master every chart
graph and table type that Google provides
Manipulate the results of queries to compare and correlate KPIs
Add conditional formatting to make your data stand out and easier to read
Apply filters and sorting to really hone in on the data you want to present
Work with date fields and apply comparison periods for trend analysis

* Requirements

* Access to a computer with a web browser
* Internet connection
* No experience working with data or analytics tools necessary
* A Google account

Description

***** Enrol now in the most comprehensive and up to date (November 2021) course available for the Google Data Studio platform! Learn how to turn your data into stunning dashboards that provide valuable insights! *****


Your Instructor

This course is taught by a Business Intelligence professional with over 25 years' experience of working with data and teaching beginners how to use data analysis tools. His career has seen him work in the UK (London), France (Montpellier) and the US (San Francisco).

He's worked on projects for some of the biggest brands on the planet and is a data visualisation expert with a sizeable online following.


What You'll Learn

In this course you'll learn everything you need to become highly proficient in using Google Data Studio. Including how to:

  • Manage, structure, prepare and connect to your data

  • Build complex data queries and manipulate query results

  • Create interactive data visualisations that professionally present your data

  • Write custom formulas to dig deeper into your data

  • Build stunning automated, interactive dashboards and reports that communicate your data effectively


A Lean, Mean Learning Machine!

  • Throughout the over 70 lessons of on-demand video, you’ll learn not only how to master Google Data Studio but you’ll also get a very solid foundation in Business Intelligence as a whole.


  • There are fun and challenging practical activities for every chapter to test yourself and put into practice everything you learn .

  • Over 50 pages of course notes as well as downloadable datasets to help facilitate your learning experience.

  • The course is 100% scripted word-for-word and beautifully edited to make sure that you're maximising you're learning time. No more "ums" and "ers", waiting for things to load or "sorry, let me just type that again". This course is a lean mean learning machine!

  • The course follow a simple, methodical structure that teaches you what you need to know only when you need to know it, to avoid overloading you with unnecessary information at the wrong time. And everything is taught with as much context as possible using concrete examples and real use cases.

  • As Google Data Studio is constantly being updated, so is this course to make sure that you'll always be up to date with the latest functionalities!

  • You're taught by an instructor who excels at making complex concepts easy to understand. The course is set up in such a way as to not overload you with information at any one time and teach you what you need to know only when you need to know it.


Why Learn Google Data Studio?

Knowing how to use Excel is all well and good, most people do. But, in today's data-driven world, it’s not just all about Excel, data is everywhere! Online and off.

Being able to go beyond Excel and produce automated interactive reports containing data from different sources is what brings the real value. Helping you to make smarter business decisions and stay ahead of the game.

The Ultimate Guide to Google Data Studio 2021 is a great place to start your Business Intelligence (the process of turning data into insights) journey. This course has been designed and built to help you to go beyond Excel and harness the power of your data. To create stunning automated and interactive dashboards that will provide the precious insights that companies love!


What are you waiting for?

There’s never been a better time to add a skill like Business Intelligence to your toolbox and Google Data Studio is the perfect tool to get started. So check out the free preview and get enrolled! You've got nothing to lose and everything to gain!

Who this course is for:

  • People who want to learn how to use Google Data Studio
  • Beginners to data analysis and Business Intelligence
  • People who want to learn how to build interactive automated dashboards

Course content

10 sections • 77 lectures

Welcome to the course Preview 03:11

Course outline Preview 04:35

Interface first look Preview 03:30

Introduction to the module Preview 00:39

Available data sources Preview 02:49

Metrics & dimensions explained Preview 03:16

How to format your spreadsheets for analysis Preview 03:13

Creating your first data source Preview 05:08

*** Improved data source collaboration *** Preview 00:18

Data Freshness Preview 03:55

Module 2 - Practical Activity Preview 01:19

Module 2 - Activity Review Preview 01:39

Introduction to the module Preview 01:36

Report Builder first look Preview 01:55

Scorecards Preview 09:17

Column & Bar Charts Preview 07:16

Time Series & Area Charts Preview 07:34

Pie Charts Preview 02:55

Geographic/Maps Preview 12:03

Line & Combo Charts Preview 02:47

Scatterplot & Bubble Charts Preview 04:02

Bullet Charts Preview 03:36

Treemaps Preview 03:20

Tables Preview 09:35

Pivot Tables Preview 04:55

Gauges Preview 02:36

Community Visualisations Preview 03:01

Module 3 - Practical Activity Preview 01:14

"Complete" list of functions available to use in formulas

https://support.google.com/datastudio/table/6379764?hl=en

Module 3 - Activity Review Preview 02:09

Introduction to the module Preview 00:59

What are filters & how do they work? Preview 02:26

Creating & applying data filters Preview 07:31

Date Range filters Preview 03:28

Sorting query results Preview 03:11

Module 4 - Practical Activity Preview 01:35

Module 4 - Activity Review Preview 02:36

Introduction to the module Preview 00:30

Aggregators Preview 05:36

Comparison calculations Preview 03:49

Running calculations Preview 04:46

Introduction to the module Preview 01:23

Basic metric calculations Preview 06:00

Row-level metric calculations Preview 03:25

Grouping values Preview 11:01

Filtered metrics Preview 02:17

Update to CASE statements Preview 00:45

Date & time calculations Preview 05:08

Parameters Preview 04:17

Module 6 - Practical Activity Preview 01:22

Module 6 - Activity Review Preview 01:45

Introduction to the module Preview 00:36

Data Explorer Preview 06:25

Extract Data Preview 04:34

Module 7 - Practical Activity Preview 00:51

Module 7 - Activity Review Preview 00:40

Introduction to the module Preview 01:20

Top tips for better dashboard design Preview 09:36

Report themes & layout Preview 05:41

Visualisation-level interactivity Preview 06:56

Report-level interactivity Preview 08:56

Data Control Preview 01:57

Additional design elements Preview 02:47

*** Update to reports in edit mode *** Preview 00:17

Updated page navigation Preview 02:47

Report publishing settings Preview 02:47

Module 8 - Practical Activity Preview 03:28

Module 8 - Activity Review Preview 16:59

Introduction to the module Preview 01:17

Relational databases explained Preview 02:56

Basic principles of joining data Preview 07:01

Blending data in Data Studio Preview 04:14

Module 9 - Practical Activity Preview 01:06

Module 9 - Activity Review Preview 03:10

Introduction to the module Preview 01:01

Setting asset permissions Preview 04:39

Export options Preview 03:32

Module 10 - Practical Activity Preview 00:29