![Page 1: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/1.jpg)
Five Things I Wish I Knew theFirst Day I Used Tableau
Presented by:Ryan SleeperDirector, Data VisualizationEvolytics
![Page 2: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/2.jpg)
2
What to Expect
• Introduction
• Purpose
• Audience
• Five Things
• Q&A
![Page 3: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/3.jpg)
3
Ryan SleeperDirector, Data VisualizationEvolytics
![Page 4: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/4.jpg)
4
My Learning Curve
![Page 5: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/5.jpg)
5
If I had only known…
![Page 6: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/6.jpg)
1. Tableau Licenses
![Page 7: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/7.jpg)
7
Tableau Licenses
Which Tableau license is best for me?(and why is this so confusing?!)
Your choice depends on:(1) Connectivity(2) Distribution(3) Automation
(4) Security
![Page 8: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/8.jpg)
8
Tableau Public
Connectivity• TDE, Access, Excel, Text File
Distribution• Cloud
Automation• Not available
Security• None – your data is accessible by anyone on the Internet
Price: Free
![Page 9: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/9.jpg)
9
Tableau Public
Best for• Journalists• Sharing publicly available data (and Tableau know-how) with
the world• Practicing Tableau for free• Trying the software
![Page 10: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/10.jpg)
Tableau Desktop: Personal
10
Connectivity• TDE, Access, Excel, Text File
Distribution• Offline or Tableau Public
Automation• Not available
Security• As good as your personal computer / server’s security
Price: $1000 for year one; $200 for year two+
![Page 11: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/11.jpg)
Tableau Desktop: Personal
11
Best for• Those that only need to connect to flat data files• Those that need the most cost-effective version that will keep
their data private
![Page 12: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/12.jpg)
Tableau Desktop: Professional
12
Connectivity• All possible connections in Tableau
Distribution• Offline, Tableau Server, or Tableau Public (all possible
distribution options in Tableau)
Automation• Not available
Security• As good as your personal computer / server’s security
Price: $2000 for year one; $400 for year two+
![Page 13: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/13.jpg)
Tableau Desktop: Professional
13
Best for• Those that need to connect to data in databases• Those that need the capability to publish to Tableau Server
![Page 14: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/14.jpg)
Tableau Server (Interactor)
14
Connectivity• Workbooks that have been published to Tableau Server and
that you have been granted access to
Distribution• Tableau Server (cloud)
Automation• Available on schedules or intervals
Security• As good as your hosting provider’s
Price: $1000 for year one; $200 for year two+; 10 license minimum
![Page 15: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/15.jpg)
Tableau Server (Interactor)
15
Best for• Those that need to access / distribute workbooks in the cloud• Those that want to automate workbook refreshes• Those that want to edit workbooks in the cloud (limited
capability)
![Page 16: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/16.jpg)
2. Shaping Data
![Page 17: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/17.jpg)
Shaping Data
17
Sweet Excel Table
Q1 Q2 Q3 Q4 Total
Sales $ $ $ $ $$$
Profit $ $ $ $ $$$
Orders # # # # ###
Common Data Layout
![Page 18: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/18.jpg)
Shaping Data
18
Google: “Preparing Excel Files for Analysis”
Quarter Sales Profit Orders
Q1 $ $ #
Q2 $ $ #
Q3 $ $ #
Q4 $ $ #
Ideal Data Layout
![Page 19: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/19.jpg)
Shaping Data
19
Date Quarter Sales Profit Orders
1/1/2014 Q1 $ $ #
4/1/2014 Q2 $ $ #
7/1/2014 Q3 $ $ #
10/1/2014 Q4 $ $ #
Ideal Data Layout
Google: “Preparing Excel Files for Analysis”
![Page 20: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/20.jpg)
3. Dimension vs. Measure
![Page 21: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/21.jpg)
Dimension vs. Measure
21
Measure: A measure is a field that is a dependent variable; that is, its value is a function of one or more dimensions.
Tableau treats any field containing numeric (quantitative) information as a measure.
Sales
Source: Tableau Knowledge Base
![Page 22: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/22.jpg)
Dimension vs. Measure
22
Dimension: A dimension is a field that can be considered an independent variable.
By default, Tableau treats any field containing qualitative, categorical information as a dimension.
Sales
Source: Tableau Knowledge Base
![Page 23: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/23.jpg)
4. Discrete vs. Continuous
![Page 24: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/24.jpg)
Discrete vs. Continuous
24
![Page 25: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/25.jpg)
Discrete vs. Continuous
25
Discrete draws headers.
Continuous draws axes.
![Page 26: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/26.jpg)
Discrete vs. Continuous
26
Sales by Month: Discrete
![Page 27: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/27.jpg)
Discrete vs. Continuous
27
Sales by Month: Continuous
![Page 28: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/28.jpg)
5. Corporate Chart Types
![Page 29: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/29.jpg)
Sparklines
29
![Page 30: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/30.jpg)
Small Multiples
30
![Page 31: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/31.jpg)
Bullet Graphs
31
![Page 32: Five Things I Wish I Knew the First Day I Used Tableau](https://reader036.vdocuments.us/reader036/viewer/2022062419/5592878c1a28ab5e468b46de/html5/thumbnails/32.jpg)
Thank You and Q&A
32
Slides:Evolytics.com/5Things
Resources:Evolytics.com/Tableau201Google: “Tableau 201”
Ryan Sleeper@[email protected]