Complete Introduction to Google Data Studio 2020 Edition
4.5 (1,439 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,759 students enrolled

Complete Introduction to Google Data Studio 2020 Edition

Learn how to create POWERFUL data analysis and dashboards with Google Data Studio for your Google Sheets
Bestseller
4.5 (1,439 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,756 students enrolled
Created by Ian Littlejohn
Last updated 7/2020
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 9 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn from an Instructor with over 10 years teaching Data Analysis and Dashboard Design
  • Create POWERFUL Interactive Dashboards from Google Sheets Data in Minutes
  • Analyze Google Sheets in MINUTES using powerful visualizations
  • Create Year to Date, Month to Date, Week to Date Calculations with the click of the mouse
  • Learn to SHARE and COLLABORATE using Reports and Dashboards of data
  • Create powerful SCORECARDS displaying Key Metrics and KPIs
  • Create TIME SERIES graphs that easily display Month to Date, Previous Month and many more
  • Display COMPARISONS to Previous Periods
  • Create FILTERS to easily create interactive dashboards, graphs and reports
  • Learn powerful VISUALIZATIONS such as Column, Bar, Pie, Scatterplot
Requirements
  • You will need a Google Account
  • You will need access to Google Sheets
  • You will need access to Google Data Studio
Description

**** Updated July 2020 - this bestselling Udemy course has been updated ****

Recent reviews:

  • "Excellent systematic explanation by the instructor."

  • "I am very happy with the content and delivery of this course. Ian, you did a great job!"

  • "Very nice course, highly recommended. I passed from zero to do the most complicated dashboard at the agency I work in, involving complex filters and data consolidation of big databases. Thanks for all your support"

In this course you will learn the BEST techniques and tools for turning data into MEANINGFUL analysis using Google Data Studio

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 95 000 enrollments on Udemy and consistently high reviews.  Ian specialises in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI and Google Data Studio. 

**** Life time access to course materials and practice activities.  100% money back guarantee ****

In this course we are going to show you how to SUPERCHARGE your Google Sheets into Interactive Dashboards and INCREDIBLE reports.  Google Data Studio works seamlessly with your Google Sheets data to create amazing data analysis in minutes.

Google Data Studio is an incredibly easy to use drag and drop tool that allows a multitude of different visualizations to be created in minutes.  The addition of filtering tools produces stunning reports that will take your data analysis to the next level.

Google Data Studio is available free to people with a Google or Gmail account.  

In this course we are going to teach you the following:

  • How to connect Data Studio to Google Sheets

  • Learn how to calculate Averages, Highest values, Lowest Values and number of Unique Values

  • Create Scorecards to display key metrics and KPIs

  • Create powerful trend analysis graphs to help with forecasting

  • Create Year to Date, Month to Date and Previous Month calculations with the click of a mouse button

  • Learn to gain powerful analysis from Stacked Bar and 100% graphs

  • Create powerful Time and Category filters to easily create interactive reports

  • Learn to share your Reports and Dashboards with other users

Google Data Studio is truly an amazing product for creating insight and intelligence from your Google Sheets data.

Who this course is for:
  • Google Sheets users and Excel users who want to learn how to use Google Data Studio to analyze and report data
Course content
Expand all 69 lectures 05:34:50
+ Introduction
6 lectures 19:41
Access the Google Sheets Training Data
00:03
Loading Data into Google Sheets
02:55
Connecting to Google Data Studio
06:58
Overview of Google Data Studio
05:27
+ Tables
7 lectures 30:11
Introduction to Tables
00:48
Formatting and Sorting Tables
06:58
Multiple Measures
04:29
Conditional Formatting
06:53
Practical Activity
00:16
Completed Practical Activity
06:39
+ Methods of Aggregation
6 lectures 37:25
Practical Activity - Methods of Aggregation
00:40
Completed Practical Activity - Methods of Aggregation
06:49
Comparison Calculations
07:10
Running Total Calculations
10:13
Drill Down
05:29
+ Pivot Tables and Card Visualizations
6 lectures 25:15
Introduction to Pivot Tables and ScoreCards
00:41
Creating Pivot Tables
07:10
Comparison Calculations
05:19
Practical Activity
00:16
Completed Practical Activity
05:02
+ Slicers and Visualization Filters
7 lectures 38:57
Introduction to Slicers and Visualization Filters
01:24
Text Slicers
07:52
Date Slicers
06:26
Text Visualization Filters
05:15

Learn how to create Pivot Tables in Google Data Studio

Numeric Visualization Filters
08:43
Date Visualization Filters
02:56
Filter Date Options
06:21
+ Custom Calculations
9 lectures 44:42
Introduction to Custom Calculations
01:03
Practical Activity
00:06
Completed Practical Activity
05:55
Year Month and Day
08:45
Case Statement
06:15
Practical Activity
00:11
Completed Practical Activity
07:06
Comparisons
09:08
+ Case Study
2 lectures 08:42
Introduction to Case Study
00:51
Extract Data Case Study
07:51
+ Time Series Graphs
8 lectures 34:22
Introduction to Time Series Graphs
00:46
Create Time Series Graphs
06:54
Changing Time Periods
05:09
Styles and Formatting
05:35
Time Series Chart Options
04:17
Area Graph
06:41
Practical Activity
00:15
Completed Practical Activity
04:45
+ Other Visualizations
8 lectures 45:55
Introduction to Other Visualizations
01:37
Column and Bar Graphs
08:29
Pie Graphs
03:59
Geographical Analysis
08:20
TreeMap and Bullet Graphs
04:53
Scatterplot Graph
05:09
Custom Visualization
06:55
Reference Lines and Numeric Sliders
06:33
+ Publishing and Sharing Interactive Dashboards
4 lectures 14:53
Introduction to Dashboards
00:43
Publish and Sharing Interactive Dashboards Section
00:17
Create Dashboard
09:30
Sharing Dashboards
04:23