Data Analysis And Dashboards With Google Data Studio

  1. Home
  2. Data-analysis
  3. Data Analysis And Dashboards With Google Data Studio

Tags: Data Analysis , Google Data Studio

Learn how to create POWERFUL data analysis and dashboards with Google Data Studio for your Google Sheets

Last updated 2022-01-10 | 4.6

- Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P
- Learn from an Instructor with over 10 years teaching Data Analysis and Dashboard Design
- Create POWERFUL Interactive Dashboards from Google Sheets Data in Minutes

What you'll learn

Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P
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 and reports
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

  • Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P
  • 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 and reports
  • 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

Course content

12 sections • 69 lectures

Introduction 6 lectures

Introduction to the Course Preview 01:49

About the Course Preview 01:55

Download the Google Sheets Training Data Preview 00:03

Loading Data into Google Sheets Preview 03:30

Connecting to Google Data Studio Preview 07:53

Overview of Google Data Studio Preview 05:36

Tables 7 lectures

Introduction to Tables Preview 00:47

Creating Tables Preview 04:58

Formatting and Sorting Tables Preview 06:21

Multiple Measures Preview 04:58

Conditional Formatting Preview 06:02

Practical Activity Preview 00:16

Completed Practical Activity Preview 04:26

Methods of Aggregation 7 lectures

Methods of Aggregation Preview 10:24

Practical Activity - Methods of Aggregation Preview 00:40

Completed Practical Activity - Methods of Aggregation Preview 06:38

Comparison Calculations Preview 06:27

Running Total Calculations Preview 05:23

Drill Down Preview 05:04

Working with Dates Preview 03:55

Pivot Tables and Card Visualizations 6 lectures

Introduction to Pivot Tables and ScoreCards Preview 00:39

Creating Pivot Tables Preview 05:38

Comparison Calculations Preview 04:45

Card Visualization Preview 05:04

Practical Activity Preview 00:09

Completed Practical Activity Preview 05:13

Slicers and Visualization Filters 7 lectures

Introduction to Slicers and Visualization Filters Preview 01:22

Text Slicers Preview 05:46

Numeric Slicers Preview 04:04

Date Slicers Preview 03:58

Text Visualization Filters Preview 04:53

Numeric Visualization Filters Preview 06:30

Learn how to create Pivot Tables in Google Data Studio

Date Visualization Filters Preview 04:26

Custom Calculations 9 lectures

Introduction to Custom Calculations Preview 01:01

Create Calculations Preview 04:02

Practical Activity Preview 00:06

Completed Practical Activity Preview 04:22

Year Month and Day Preview 05:34

Case Statement Preview 05:22

Practical Activity Preview 00:11

Completed Practical Activity Preview 05:12

Comparisons Preview 06:05

Case Study 2 lectures

Introduction to Case Study Preview 00:49

Extract Data Case Study Preview 07:43

Time Series Graphs 8 lectures

Introduction to Time Series Graphs Preview 00:44

Create Time Series Graphs Preview 08:57

Changing Time Periods Preview 04:23

Styles and Formatting Preview 04:57

Time Series Chart Options Preview 03:39

Area Graph Preview 05:15

Practical Activity Preview 00:15

Completed Practical Activity Preview 05:29

Other Visualizations 7 lectures

Introduction to Other Visualizations Preview 01:36

Column and Bar Graphs Preview 07:11

Pie Graphs Preview 04:14

Geographical Analysis Preview 08:39

TreeMap Graph Preview 02:01

Scatterplot Graph Preview 05:33

Custom Visualization Preview 03:28

Publishing and Sharing Interactive Dashboards 4 lectures

Introduction to Dashboards Preview 00:42

Publish and Sharing Interactive Dashboards Section Preview 00:17

Create Dashboard Preview 10:42

Sharing Dashboards Preview 05:34

Cases Studies 5 lectures

Download the Training Data Files Preview 00:01

Preparing Files for Data Blending Preview 06:38

Data Blending Preview 05:58

Data Explorer Preview 07:46

Google Analytics Preview 09:32

Conclusion 1 lectures

Conclusion Preview 00:25