Module 8 In this module we will:
• Overview of Data Visualization principles
Data Visualization
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Use visualization to clearly and concisely present insights
Visualizing a Interacting with a Deliver powerful Get scalable
dataset allows dataset visually is insights to your performance as
you to spot often faster than audience through your dataset
hidden trends writing SQL reports grows with
BigQuery-backed
visualization
tools
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Visualization Theory: Perception
Stimulus Eye Brain
Preattentive processing
Attentive processing
Sensation Perception
Physical process Cognitive process
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Visualization Theory: Count the Fives
69750429347493732418605783578
58728294974654487818676453214
24439684634233529867321903875
65878893745390932975659391732
14725920189374476564722175652
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Visualization Theory: Count the Fives
69750429347493732418605783578
58728294974654487818676453214
24439684634233529867321903875
65878893745390932975659391732
14725920189374476564722175652
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Visualization Theory: Count the Fives
69750429347493732418605783578
58728294974654487818676453214
24439684634233529867321903875
65878893745390932975659391732
14725920189374476564722175652
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Visualization Theory: Preattentive Attributes
Form
Color
Spacial Position
Orientation Shape Line Length Line Width
Motion
) ) ) ) )
) | ) ) )
Size Curvature Added Marks Enclosure
Flicker
Direction
Hue Intensity 2-D Position Motion
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
You Choose: Effective or Ineffective (or Wrong) Visuals
OR
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
You Choose: Effective or Ineffective Visuals
OR
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
The 80/20 Rule
What you spend your time on:
20% The Output
80% Getting data, analyzing it, saving it, downloading it
(Visualization)
What your audience actually cares about:
All that
stuff
you did 99% The Output (Visualization)
before
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Visualization Core Concept: Dimensions and Measures
Description Examples
1 Dimensions A field that can be considered • Name
an independent variable. • Location
• Part Number #
Usually contains qualitative, • Job Title
categorical information
2 Measures A field that is a dependent • Revenue
variable; that is, its value is a • Salary
function of one or more • Expenses
dimensions. e.g. any field • Count of Errors
containing numeric
(quantitative) information
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Class Question
Which of the below are measures?
1. Phone Number
2. Employee ID
Remember, measures are
3. Age usually quantitative fields
4. Date of Birth
5. Tenure at Work (in years)
6. Job Title
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Reports transform data into information
Tell a clear story with your data
Share and collaborate on reports
with others
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Module 8 In this module we will:
Data Visualization
• Demo: Google Data Studio UI
• Connect Google Data Studio to Google
BigQuery
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Create new reports in the Data Studio UI
Data Studio Home
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Select data sources to build your visualizations
Data source picker
Select:
Google Merchandise Store: Master View
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Connect to multiple different types of data sources
Data Studio
File upload
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Add the data source to your report
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Create charts to visualize data relationships
Click...
...and draw
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Add a descriptive name to your report
Report name
Click (click
to rename
to edit)
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
View the end-user version of the report
View toggle
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
View your report as an end-user
Users cannot edit your reports
unless you give them permission
Ta da!
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Demo: Google Data Studio Walkthrough
Ecommerce Dashboard
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Use Data Studio to explore and share your data insights
Connect to Visualize with beautiful, Share across the
all your data informative reports organization and
around the world
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Summary: GCP and
Summary: Explore offers youyour
present theinsights
abilityvisually
to:
Guide the eye of Use the right Click-and-drag
your user with visual to convey new report charts
preattentive the right message inside Data Studio
attributes
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Lab 7
Exploring a Dataset in
Google Data Studio
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.
Exploring a Dataset in Google Data Studio
In this lab, you will visually explore
Google BigQuery data tables inside of
Google Data Studio. You will look for
relationships and insights between fields
in your dataset.
© 2017 Google Inc. All rights reserved. Google and the Google logo are trademarks of Google Inc. All other
company and product names may be trademarks of the respective companies with which they are associated.