claw 2017 tableau slides (buhler, magnus) (read-only) · outline •...
TRANSCRIPT
![Page 1: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/1.jpg)
Purposeful Data Visualization with Tableau
Jeremy Buhler, Assessment Librarian, UBC | [email protected]
Ebony Magnus, Assessment & User Experience Librarian, SAIT | [email protected]
Workshop material and data files athttp://bit.ly/claw-‐tableau
Please download copy of Excel files
![Page 2: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/2.jpg)
Outline
• what we mean by “purposeful”• preparing your data• introducing the Tableau interface• exercise/practice
break, 10:30-‐11:00
• creating dashboards• exercise/practice• refining the visual presentation• exercise/practice
![Page 3: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/3.jpg)
Goals
• not intimidated by the software• curious about what more it can do• prepared to tackle your own datasets
![Page 4: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/4.jpg)
![Page 5: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/5.jpg)
data visualization
“all types of visual representation that support the exploration, examination, and
communication of data” (Few, 2009)
![Page 6: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/6.jpg)
objects
pointslinesbars
relationships
time-‐seriesnominal comparisonrankingpart-‐to-‐wholedeviationcorrelationgeospatial
![Page 7: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/7.jpg)
pre-‐attentive processing
the perception of basic attributes “prior to and without the need for conscious awareness” (Few, 2009)
![Page 8: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/8.jpg)
Attentive processing
Preattentive processing
From Stephen Few, Tapping the Power of Visual Perceptionhttp://www.perceptualedge.com/articles/ie/visual_perception.pdf
![Page 9: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/9.jpg)
form
length width orientation
shape
size
blurcurvature enclosure
![Page 10: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/10.jpg)
colour position motion
hue
intensity
2-‐D position direction of motion
spatial grouping
![Page 11: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/11.jpg)
data cleaning & prep
![Page 12: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/12.jpg)
more polished =more true?
![Page 13: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/13.jpg)
more polished =more true?
faster = better?
![Page 14: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/14.jpg)
more polished =more true?
faster = better?
understand your data, understand your tools
![Page 15: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/15.jpg)
Choosing and preparing your data
• level of detail or aggregation• format• privacy• description• quality
![Page 16: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/16.jpg)
Choosing and preparing your data
• choose raw over aggregated data• normalize cross-‐tabulated datasets
![Page 17: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/17.jpg)
Choosing and preparing your data
• choose raw over aggregated data• normalize cross-‐tabulated datasets
Related resource: Preparing Excel files for analysis [in Tableau]. http://kb.tableau.com/articles/knowledgebase/preparing-‐excel-‐files-‐analysis
Tall data, not wide
![Page 18: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/18.jpg)
raw vs aggregated data
![Page 19: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/19.jpg)
raw vs aggregated data
![Page 20: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/20.jpg)
tall vs cross-‐tabulated (wide) data
![Page 21: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/21.jpg)
tall vs cross-‐tabulated (wide) data
![Page 22: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/22.jpg)
tall vs cross-‐tabulated (wide) data
Like with like, in the same column
![Page 23: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/23.jpg)
<software demo and hands-‐on practice>
![Page 24: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/24.jpg)
Junk drawer, tickle trunkTry to break your viz. Throw everything at it, try things you don’t understand, create a mess and see what you find.
![Page 25: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/25.jpg)
<software demo and hands-‐on practice>
Participants encouraged to share examples athttps://public.tableau.com/profile/claw.2017
![Page 26: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/26.jpg)
Explore your chosen data set. Try to identify one pattern, one outlier, and one relationship. Consider how this changes your initial assumptions about the service or product represented in the data set.
![Page 27: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/27.jpg)
<software demo and hands-‐on practice>
![Page 28: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/28.jpg)
Communicate something of import about your data set. Consider who you’re speaking to and what you hope to accomplish. Use Tableau’s features strategically to highlight aspects of your data that are most important to your message.
![Page 29: CLAW 2017 Tableau slides (Buhler, Magnus) (Read-Only) · Outline • whatwe*mean*by*“purposeful” • preparingyourdata • introducing*the*Tableau*interface • exercise/practice](https://reader034.vdocuments.us/reader034/viewer/2022050205/5f588a2607951e41df314e33/html5/thumbnails/29.jpg)
<hands-‐on practice>