Data Analysis and Dashboards with Google Data Studio

Data Analysis and Dashboards with Google Data Studio

image description

What you will 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


Section 1: Introduction

Section 2: Setting Up Google Data Studio

Section 3: The First Report

Section 4: The Scorecard Visualization

Section 5: Creating Dynamic Tables in Data Studio

Section 6: Time Series Graphs to learn about Trends

Section 7: Column and Bar Graphs

Section 8: Using Pie Graphs with Google Data Studio

Section 9: Mapping and Geographic Analysis

Section 10: Scatterplot

Section 11: Publishing and Sharing Interactive Dashboards

Section 12: Conclusion

Course Description

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


  • You will need a Google Account
  • You will need access to Google Sheets
  • You will need access to Google Data Studio


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

This course is presented by Ian Littlejohn - who with over 23000 students is one of the most popular instructors on Udemy. Ian provides world leading courses on Excel, Power Pivot, Power BI and Google Data Studio.

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.

Who this course is for:

  • Google Sheets users and Excel users who want to learn how to use Data Studio to analyze and report data