Data Analysis and Dashboards with Google Data Studio
4.7 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
174 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Analysis and Dashboards with Google Data Studio to your Wishlist.

Add to Wishlist

Data Analysis and Dashboards with Google Data Studio

Learn how to create powerful data analysis and dashboards with Google Data Studio for your Google Sheets
Bestselling
4.7 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
174 students enrolled
Created by Ian Littlejohn
Last updated 5/2017
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 33 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
  • Share Reports and Dashboards of Sales 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
View Curriculum
Requirements
  • You will need a Google Account
  • Google Sheets
  • Google Data Studio
Description

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 is the target audience?
  • Google Sheets users
  • Excel users
  • Data Analysts
  • Business Owners
  • Managers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
62 Lectures
02:43:34
+
Introduction
4 Lectures 02:41
Introduction Section
00:00


Access the Google Sheets Training Data
00:07

Access the Learner Guide
00:08
+
Setting Up Google Data Studio
3 Lectures 09:31
+
The First Report
3 Lectures 07:32
First Report Section
00:00

The First Data Studio Report
07:26

Practical Activity
00:06
+
The Scorecard Visualization
17 Lectures 50:54
The Scorecard Section
00:00

Creating a Scorecard
05:20

Practical Activity
00:09

Changing the Method of Aggregation
09:55

Practical Activity
00:05

Custom Calculations with Scorecards
04:19

Practical Activity
00:14

Custom Calculations with Tables
04:47

Practical Activity
00:09

Comparison to Previous Periods
07:32

Practical Activity
00:07

Using Filters with Data Studio
05:12

Practical Activity
00:22

Year to Date, Month to Date and Other Key Calculations
07:33

Practical Activity
00:14

Filtering Scorecards
04:45

Practical Activity
00:08
+
Creating Dynamic Tables in Data Studio
9 Lectures 27:38
Tables Section
00:00

Introduction to Tables
07:22

Formatting Tables
04:27

Practical Activity
00:09

Tables with Previous Periods
04:05

Practical Activity
00:09

Year to Date, Month to Date and Similar Calculations
03:13

Time Intelligence for Tables
08:01

Practical Activity
00:11
+
Time Series Graphs to learn about Trends
8 Lectures 29:39
Time Series Graphs Sections
00:00

Time Series Graphs
06:23

Changing the Time Frame for Time Series Graphs
06:16

Practical Activity
00:07

Styles and Formatting for Time Series Graphs
07:32

Time Series Graphs and Custom Filters
03:36

Practical Activity
00:08

Area Graphs
05:36
+
Column and Bar Graphs
4 Lectures 08:17
Column and Bar graph Section
00:00

Using Column and Bar graphs in Data Studio
04:02

Using the Stacked Bar and 100% Bar graph
03:58

Practical Activity
00:16
+
Using Pie Graphs with Google Data Studio
3 Lectures 03:59
Pie Graph Section
00:00

Using Pie Graphs with Google Data Studio
03:51

Practical Activity
00:07
+
Mapping and Geographic Analysis
3 Lectures 04:40
Mapping and Geographical Analysis Section
00:00

Mapping and Geographic Analysis
04:36

Practical Activity
00:04
+
Scatterplot
3 Lectures 06:32
Scatterplot Section
00:00

Using the Scatterplot to Identify Correlations
06:18

Practical Activity
00:13
2 More Sections
About the Instructor
Ian Littlejohn
4.4 Average rating
1,619 Reviews
9,978 Students
11 Courses
Excel Power Tools, Power BI and Google Data Studio Trainer

Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and Google Data Studio.  Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query,  Power BI and Google Data Studio.

Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.

Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.

Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.