Certificate In Data Analysis and Dashboards with Google Data Studio Online Course

Supercharge Your Google Sheets Into Interactive Dashboards

Certificate In Data Analysis and Dashboards with Google Data Studio Online Course

NOW ONLY

US$99

Save US$500 (83%)
OFF RRP US$599
Get Info Pack

Supercharge Your Google Sheets Into Interactive Dashboards

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 for free to people with a Google or Gmail account. In addition reports and dashboards can be shared to any users whether they have a Google account or not.

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.You will need a Google Account,Google Sheets and Google Data Studio.

Course Fast Facts:

  1. Learn the fundamentals of Data Analysis and Dashboards with Google Data Studio
  2. Comprehensive 12 module Accredited Certificate In Data Analysis and Dashboards with Google Data Studio Online Course
  3. Study along with simple instructions & demonstrations
  4. Written and developed by leading Data Analysis and Dashboards with Google Data Studio experts
  5. Receive one-on-one online help & support
  6. Unlimited, lifetime access to online course
  7. Certificate of completion
  8. Study at your own pace with no rigid class timetables, 24/7 from any computer or smart device

Course Delivery

Courses are accessed online  by any device including PC, tablet or Smart Phone. Upon purchase an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. 

Recognition & Accreditation

All students who complete this course, receive a certificate of completion and will be issued a certificate via email.

Introduction

  • Introduction
  • Connect to the Google Sheets Training Data
  • Access the Learner Guide

Setting Up Google Data Studio

  • Setup Google Sheet
  • Connecting to Google Sheets

The First Report

  • First Report
  • Practical Activity

The Scorecard Visualization

  • Create a Scorecard
  • Practical Activity Scorecard
  • Method of Aggregation
  • Practical Activity Method of Aggregation
  • Custom Calculations
  • Practical Activity Custom Calculations
  • Custom Calcs with Tables
  • Practical Activity Custom Calculations Tables
  • Comparison to Previous Period
  • Practical Activity Comparison Period
  • Using Filters with Data Studio
  • Practical Activity Using Filters
  • Year to Date Month to Date
  • Practical Activity Year to Date
  • Filtering Scorecards
  • Practical Activity Filtering Scorecards

Creating Dynamic Tables in Data Studio

  • Introduction to Tables
  • Formatting Tables
  • Practical Activity Tables
  • Tables with Previous Periods
  • Practical Activity with Previous Periods
  • Year to Date, Month to Date and Similar Calculations
  • Time Intelligence for Tables
  • Practical Activity Time Intelligence

Time Series Graphs to learn about Trends

  • Time Series Graphs
  • Changing the Time Frame
  • Practical Activity Time Series
  • Styles and Formatting
  • Time Series and Custom Filters
  • Practical Activity Time Series
  • Area Graphs

Column and Bar Graphs

  • Column and Bar Graphs
  • Stacked Bar and 100 Percent Bar Graph
  • Practical Activity Column and Bar Graph

Using Pie Graphs with Google Data Studio

  • Pie Graphs
  • Practical Activity Pie Graphs

Mapping and Geographic Analysis

  • Mapping and Geographic Analysis
  • Practical Activity Geographical Analysis

Scatterplot

  • Scatterplot
  • Practical Activity Scatterplot
  • Publishing and Sharing Interactive Dashboards
  • Practical Activity Interactive Dashboards

Conclusion

  • Conclusion

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

About this Course

Supercharge Your Google Sheets Into Interactive Dashboards

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 for free to people with a Google or Gmail account. In addition reports and dashboards can be shared to any users whether they have a Google account or not.

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.You will need a Google Account,Google Sheets and Google Data Studio.

Course Fast Facts:

  1. Learn the fundamentals of Data Analysis and Dashboards with Google Data Studio
  2. Comprehensive 12 module Accredited Certificate In Data Analysis and Dashboards with Google Data Studio Online Course
  3. Study along with simple instructions & demonstrations
  4. Written and developed by leading Data Analysis and Dashboards with Google Data Studio experts
  5. Receive one-on-one online help & support
  6. Unlimited, lifetime access to online course
  7. Certificate of completion
  8. Study at your own pace with no rigid class timetables, 24/7 from any computer or smart device

Course Delivery

Courses are accessed online  by any device including PC, tablet or Smart Phone. Upon purchase an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. 

Recognition & Accreditation

All students who complete this course, receive a certificate of completion and will be issued a certificate via email.

Introduction

  • Introduction
  • Connect to the Google Sheets Training Data
  • Access the Learner Guide

Setting Up Google Data Studio

  • Setup Google Sheet
  • Connecting to Google Sheets

The First Report

  • First Report
  • Practical Activity

The Scorecard Visualization

  • Create a Scorecard
  • Practical Activity Scorecard
  • Method of Aggregation
  • Practical Activity Method of Aggregation
  • Custom Calculations
  • Practical Activity Custom Calculations
  • Custom Calcs with Tables
  • Practical Activity Custom Calculations Tables
  • Comparison to Previous Period
  • Practical Activity Comparison Period
  • Using Filters with Data Studio
  • Practical Activity Using Filters
  • Year to Date Month to Date
  • Practical Activity Year to Date
  • Filtering Scorecards
  • Practical Activity Filtering Scorecards

Creating Dynamic Tables in Data Studio

  • Introduction to Tables
  • Formatting Tables
  • Practical Activity Tables
  • Tables with Previous Periods
  • Practical Activity with Previous Periods
  • Year to Date, Month to Date and Similar Calculations
  • Time Intelligence for Tables
  • Practical Activity Time Intelligence

Time Series Graphs to learn about Trends

  • Time Series Graphs
  • Changing the Time Frame
  • Practical Activity Time Series
  • Styles and Formatting
  • Time Series and Custom Filters
  • Practical Activity Time Series
  • Area Graphs

Column and Bar Graphs

  • Column and Bar Graphs
  • Stacked Bar and 100 Percent Bar Graph
  • Practical Activity Column and Bar Graph

Using Pie Graphs with Google Data Studio

  • Pie Graphs
  • Practical Activity Pie Graphs

Mapping and Geographic Analysis

  • Mapping and Geographic Analysis
  • Practical Activity Geographical Analysis

Scatterplot

  • Scatterplot
  • Practical Activity Scatterplot
  • Publishing and Sharing Interactive Dashboards
  • Practical Activity Interactive Dashboards

Conclusion

  • Conclusion

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

We provide a 7 Day Money Back Refund on all Courses

Now Only US$99 Save US$500 (83%)
OFF RRP US$599
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value $600)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 009SRD3AG
Delivery Mode: Online
Course Access: Unlimited lifetime
Tutor Support: Yes
Time required: Study at your own pace
Course Duration: 2.5 Hours
Assessments: Yes
Qualification: Certificate of Completion

Popular Courses and Bundles

Get a FREE Career Planner