INDEX

Numbers

100% stacked bar charts, 203–204

A

actionable goals, 20

Affinity Map, 2

ages of survey responders, 182–185

Aggregate Measures option (Analysis menu), 80

alerting colors, 121

Alteryx, 165

analysis

audience, 61–63

explanatory, 56–58

exploratory, 56–58

Analysis menu commands

Aggregate Measures, 80

Create Calculated Field, 194

analytic academic program dataset, 97

Analytics tab (Data window), 47

Andrews, RJ, 230

Anscombe, Francis, 21

Anscombe’s Quartet, 21–22

anxiety about public speaking, overcoming, 64

audience analysis, 61–63

auditory cortex, 18

autumn, data visualization of, 27–29

B

background maps, 105

bar charts

100% stacked bar charts, 203–204

bar-in-bar charts, 199–201

creating, 68–70

divergent stacked bar charts

creating, 205–206

Gantt Percent Line field, 211–215

Gantt Start field, 209–211

Negative Sentiment field, 206–207

Percent of Gantt Sizing field, 210

Total Negative Sentiment field, 207–208

Total Sentiment Scores field, 209

features of, 66–68

bar-in-bar charts, 199–201

Beran, Bora, 230

blogs, 229–230

Data Revelations, 156, 229, 230

Eager Eyes, 230

Flowing Data, 230

Information is Beautiful, 230

book recommendations, 230

Bora Beran “On Anything Data” blog, 230

borders

formatting, 131–134

mark borders, 119

brain response to storytelling, 16–18

Broca’s area of the brain, 16

bubble charts

creating, 83–85

features of, 83

Burning Glass, 35

business analytics programs, 10–12

Business Intelligence Congress 3, 8

C

calculated fields

divergent stacked bar chart

creating, 205–206

Gantt Start field, 209–211

Negative Sentiment field, 206–207

Percent of Gantt Sizing field, 211–215

Total Negative Sentiment field, 207–208

Total Sentiment Scores field, 209

timeline charts, 194–195

cards, 47

Color Marks, 100

100% stacked bar charts, 203–204

bar-in-bar charts, 199–201

color legends, 124

default color, 110–111

divergent stacked bar charts, 213–214

diverging color, 112–114

mark borders, 119

mark halos, 120–121

opacity, 118–119

proportional symbol maps, 100

red/green color palettes, 121–123

reversed color, 115–117

sequential color, 111–112

stepped color, 114–115

word clouds, 223

Detail Marks, 99

proportional symbol maps, 98–99

timeline charts, 196–199

Marks

bar charts, 68–69

choropleth maps, 101–103

geodata, 92

heat maps, 89–90

line charts, 72

lollipop charts, 218

pie and donut charts, 74–78

scatter plots, 81

treemaps, 88

Shape Marks, 139–140

Show Me, 47, 74–75

expanding, 57

packed bubble charts, 83–85

pie and donut charts, 74–78

treemaps, 86–87

Size Marks, 99

bar-in-bar charts, 199–201

divergent stacked bar charts, 214

lollipop charts, 219

proportional symbol maps, 99

shapes, 139

word clouds, 221

Text Marks

borders, 133

divergent stacked bar charts, 205–206

word clouds, 221

Carlson, Chelsea, 23–25

categorical color, 115–117

Center for Disease Control, Lyme disease dataset, 93

cerebellum, 18

change over time, 59

charts, 65–66, 191–192. See also graphs; maps; visual design

100% stacked bar charts, 203–204

bar charts

creating, 68–70

features of, 66–68

bar-in-bar charts, 199–201

dessert charts, 10

creating, 74–78

features of, 73–74

divergent stacked bar charts

creating, 205–206

Gantt Percent Line field, 211–215

Gantt Start field, 209–211

Negative Sentiment field, 206–207

Percent of Gantt Sizing field, 210

Total Negative Sentiment field, 207–208

Total Sentiment Scores field, 209

donut charts

creating, 74–78

features of, 73–74

field labels, 136–138

headers, 136–138

Likert scales, 202–203

100% stacked bar charts, 203–204

divergent stacked bar charts, 205–215

line charts

creating, 72–74

features of, 70–72

lollipop charts

creating, 215–219

labeling, 219–220

packed bubble charts

creating, 83–85

features of, 83

pie charts

creating, 74–78

features of, 73–74

scatter plots

creating, 79–82

features of, 78–79

timeline charts, 192–199

calculated fields, 194–195

continuous dates, 193

formatting, 196

reference lines, 197–199

timeframes, 197

word clouds, 221–224

choropleth maps, 100–103

cleaning Excel survey data

with Alteryx, 165

with Data Interpreter

cautions, 149

goals of, 148–150

meta helper file, creating, 153–155

numeric copies, creating, 151–153

pivoting from wide to tall, 155

surface cleaning, 150–151

with Maestro, 145

with Tableau 10, 156

data sources, joining, 160–164

extracts, creating, 156–160

climax (narrative structure), 178

closure, storytelling and, 19

cognitive effects of storytelling, 16–18

collecting data, 226

color

alerting, 121

categorical, 115–117

chart/map types and

100% stacked bar charts, 204

bar charts, 67–68

choropleth maps, 102–103

heat maps, 89–90

line charts, 72

packed bubble charts, 83–84

pie and donut charts, 74–76

proportional symbol maps, 100

scatter plots, 81

treemaps, 85–88

color cues, 26–27

color legends, 124

color-coded pills, 49

diverging, 112–114

highlight, 120

mark borders, 119

mark halos, 120–121

opacity, 118–119

red/green color palettes, 121–123

reversed, 115–117

sequential, 111–112

stepped, 114–115

color cues, 26–27

Color Marks card, 100

100% stacked bar charts, 203–204

bar-in-bar charts, 199–201

color legends, 124

default color, 110–111

divergent stacked bar charts, 213–214

diverging color, 112–114

mark borders, 119

mark halos, 120–121

opacity, 118–119

proportional symbol maps, 100

red/green color palettes, 121–123

reversed color, 115–117

sequential color, 111–112

stepped color, 114–115

word clouds, 223

color vision deficiency (CVD), 121–123

color-coded pills, 49

columns, editing, 40

Columns shelf, 47

Communicating Data with Tableau (Jones), 34, 230

communication medium

narrated storytelling, 63

non-narrated storytelling, 63

communication skills, importance of, 8–10

Connect to Data screen, 38–39

connections, data. See data connections

content, importance of, 52

context

audience, 61–63

cautions, 53

data, 53–55

explanatory analysis, 56–58

exploratory analysis, 56–58

Harry Potter series example, 53–55

importance of, 51–52

presentation tips, 63–64

relevance of, 55–56

structure, 58

story genre, 60

story plot, 59–60

continuous dates, 193

continuous measures, 48

contrast, 60

counting, color and, 27

Coxcomb plot, 108

Create Calculated Field command (Analysis menu), 194

Create Hierarchy command (Hierarchy menu), 95–97

Crimea border, visualizing, 105

curating visuals. See visual design

custom shapes, 140–142

CVD (color vision deficiency), 121–123

D

Darwin, Charles, 19

dashboards, 45, 169–172

data collection, 226

data connections

Connect to Data screen, 38–39

Data Connections screen, 39–41

Extract connections, 41

geographic data, 92–93

joins

configuring, 42

errors in, 44

inner, 43

left, 43

outer, 43

right, 43

Live connections, 41

null fields, 43–44

tables, 39–41

Data Connections screen, 39–41

Data Interpreter, 143–145

data limits, 147

Excel survey data, cleaning

cautions, 149

goals of, 148–150

meta helper file, creating, 153–155

numeric copies, creating, 151–153

pivoting from wide to tall, 155

surface cleaning, 150–151

null values, handling, 147–148

running, 145–146

Data Interpreter, preparing data with, 44–45

data normalization, 56

Data Points (Yau), 230

data preparation, 143–144

with Alteryx, 165

with Data Interpreter, 44–45, 143–145

data limits, 147

example of, 145–146

Excel survey data, 148–155

null values, 147–148

with Maestro, 145

with Tableau 10, 156

data sources, joining, 160–164

extracts, creating, 156–160

Data Revelations blog, 156, 229, 230

data science education, 10–12

data sources, joining, 160–164

data storytelling. See storytelling

Data tab (Data window), 47

data visualization. See also storytelling

Affinity Map, 2

charts, 65–66

bar charts, 66–70

dessert charts, 10, 73–78

donut charts, 73–78

field labels, 136–138

headers, 136–138

line charts, 70–73

packed bubble charts, 83–85

pie charts, 73–78

scatter plots, 78–82

color

alerting, 121

categorical, 115–117

color legends, 124

default color, 110–111

diverging, 112–114

highlight, 120

mark borders, 119

mark halos, 120–121

opacity, 118–119

red/green color palettes, 121–123

reversed, 115–117

sequential, 111–112

stepped, 114–115

data science education, 10–12

defined, 4

evolution to visual data storytelling, 6–7

feedback for, 228–229

graphs

heat maps, 88–90

treemaps, 85–88

lines

borders, 131–134

drop lines, 128–130

Format pane, 124–128

grid lines, 128–130

shading, 134–139

zero lines, 128–130

maps, 91–92

background maps, 105

choropleth maps, 100–103

geographic data connections, 92–93

geographic hierarchies, 95–97

geographic role assignment, 93–95

map layers, 103–105

neutrality in, 105–106

proportional symbol maps, 97–100

supported geodata, 92

null fields, 43–44

perceptual pop-out, 26–27

power of stories

Anscombe’s Quartet, 21–22

classic visualization example, 20–22

color cues, 26–27

Napoleon’s march visualization, 29–31

Netflix data visualization, 23–25

Nigel Holmes’ “Monstrous Costs,” 31–32

seasonal cycle visualization, 27–29

shapes, 139

custom shapes, 140–142

Shape Marks card, 139–140

transparent backgrounds, 141

steps to visual data storytelling, 226–228

Trendalyzer, 2

user testing, 228–229

visual revolution in, 2–6

Data Visualization Competency Center (DVCC), 228–229

Data window, 47

dates, timeline charts for, 192–199

calculated fields, 194–195

continuous dates, 193

formatting, 196

reference lines, 197–199

timeframes, 197

default color, 110–111

Degree dimension, 100

demographic data

age, 182–185

gender, 181–182

number of responses, 180–181

Descartes, René, 108

design. See visual design

dessert charts, 10

creating, 74–78

features of, 73–74

Detail Marks card, 99

proportional symbol maps, 98–99

timeline charts, 196–199

deuteranope color deficiency, 122–123

diagrams, plot, 59–60

dimensions, 48

discrete dimensions, 48

divergent stacked bar charts

creating, 205–206

Gantt Percent Line field, 211–215

Gantt Start field, 209–211

Negative Sentiment field, 206–207

Percent of Gantt Sizing field, 210

Total Negative Sentiment field, 207–208

Total Sentiment Scores field, 209

diverging color, 112–114

donut charts

creating, 74–78

features of, 73–74

drilling down, 59

drop lines, 128–130

dual-axis charts

line charts, 71–73

lollipop charts

creating, 215–219

labeling, 219–220

DVCC (Data Visualization Competency Center), 228–229

E

Eager Eyes blog, 230

Edit Colors dialog box, 89–90, 112

Edit Shape dialog box, 139–140

education, data science, 10–12

effects (color)

mark borders, 119

mark halos, 120–121

opacity, 118–119

entropy, 31, 228

errors, join, 44

Excel survey data, cleaning

with Alteryx, 165

with Data Interpreter

cautions, 149

goals of, 148–150

meta helper file, creating, 153–155

numeric copies, creating, 151–153

pivoting from wide to tall, 155

surface cleaning, 150–151

with Maestro, 145

with Tableau 10, 156

data sources, joining, 160–164

extracts, creating, 156–160

excluding null fields, 43–44

explanatory analysis, 56–58

exploratory analysis, 56–58

exposition (narrative structure), 177

external resources

blogs, 229–230

books, 230

companion materials, 231

Tableau resources, 231

Extract connections, 41

Extract dialog, 158

extracts, creating, 156–160

F

Facebook, National Geographic on, 16

factors, 60

false reveals, 227

fear of public speaking, 64

feedback, importance of, 228–229

field labels, removing, 136–138

fields, null, 43–44

files

Global Superstore Excel, 39

spatial files, 92

filters, 58

Filters shelf, 47

finding data, 226

fitness, storytelling and, 19

Flowing Data blog, 230

Format Borders pane, 127

Format pane

banding, 134–139

borders, 131–134

drop lines, 128–130

grid lines, 128–130

shading, 134–139

zero lines, 128–130

formatting

lines

borders, 131–134

drop lines, 128–130

Format pane, 124–128

grid lines, 128–130

shading, 134–139

zero lines, 128–130

shapes, 139

custom shapes, 140–142

Shape Marks card, 139–140

transparent backgrounds, 141

The Functional Art (Cairo), 230

functions

IFNULL, 147–148

IIF, 147–148

ISNULL, 147–148

ZN, 147–148

G

Gantt Percent Line field (divergent stacked bar chart), 211–215

Gantt Start field (divergent stacked bar chart), 209–211

Gapminder Foundation, 2

Gartner, 8

Gates, Bill, 52

gender of survey responders, 181–182

genre, 60

geodata, support for, 92

geographic data connections, 92–93

geographic hierarchies, 95–97

geographic maps, 91–92

choropleth maps, 100–103

geographic data connections, 92–93

geographic hierarchies, 95–97

geographic role assignment, 93–95

map layers, 103–105

neutrality in, 105–106

proportional symbol maps, 97–100

supported geodata, 92

geographic role assignment, 93–95

geoJSON files, 92

Global Superstore Excel training file, 39

goals of storytelling, 26

Goldberg, Susan, 16

graphs. See also charts; maps

heat maps

creating, 89–90

features of, 88

treemaps

creating, 86–88

features of, 85–86

green/red color palettes, 121–123

grid lines, 128–130

groups, creating, 183–185

H

halos (mark), 120–121

Hannibal’s journey visualization, 31

Harry Potter Conference, 178

Harry Potter series visualizations

context in, 53–55

custom shapes, 141

dataset, cleaning, 148–150

meta helper file, creating, 153–155

numeric copy, creating, 151–153

surface cleaning, 150–151

divergent stacked bar chart, 205–206

creating, 205–206

Gantt Percent Line field, 211–215

Gantt Start field, 209–211

Negative Sentiment field, 206–207

Percent of Gantt Sizing field, 210

Total Negative Sentiment field, 207–208

Total Sentiment Scores field, 209

Harry Potter Conference, 178

heat map, 88

Likert visualization, 202

story plot, 59

storyboarding, 185–190

character aggression, questioning, 187–188

demographic dashboard and key question, 185–186

reveal, 188–190

headers, removing, 136–138

heat maps

creating, 89–90

features of, 88

hierarchies, geographic, 95–97

Hierarchy menu, Create Hierarchy command, 96–97

highlight colors, 120

Holmes, Nigel, 31–32

I

IFNULL function, 147–148

IIF function, 147–148

Info We Trust, 230

Information is Beautiful blog, 230

information layering, 227

inner joins, 43

intersections, 60

interval measures, 48

ISNULL function, 147–148

J

joining data sources, 160–164

joins

configuring, 42

errors in, 44

inner, 43

left, 43

outer, 43

right, 43

Jones, Ben, 34, 230

K

A Kid’s Guide to Delicious Data Stories (Pi), 85

Knaflic, Cole Nussbaumer, 230

Kosara, Robert, 230

L

labels

field labels, removing, 136–138

lollipop charts, 219–220

Labor Insight, 35, 36

latitude coordinates, 98

layers

layering information, 227

map layers, 103–105

learning, ongoing, 229

left joins, 43

legends, 47–48, 124

Likert scales, 202–203

100% stacked bar charts, 203–204

divergent stacked bar charts

creating, 205–206

Gantt Percent Line field, 211–215

Gantt Start field, 209–211

Negative Sentiment field, 206–207

Percent of Gantt Sizing field, 210

Total Negative Sentiment field, 207–208

Total Sentiment Scores field, 209

line charts

creating, 72–74

features of, 70–72

lines

borders, 131–134

drop lines, 128–130

Format pane, 124–128

grid lines, 128–130

shading, 134–139

zero lines, 128–130

Live connections, 41

live presentations, 64

narrated, 63

non-narrated, 63

logo button, 46

lollipop charts

creating, 215–219

labeling, 219–220

longitude coordinates, 98

Lyme disease dataset, 93

Lyme disease visualization

choropleth maps, 100–103

dataset, 93

geographic hierarchies, 95–97

geographic role assignment, 93–95

Lyme disease dataset, 93

proportional symbol maps, 97–100

M

Maestro, 145

Map Layers box, 104

Map Layers command (Map menu), 104

Map menu commands, Map Layers, 104

maps, 91–92. See also charts; graphs

background maps, 105

geographic data connections, 92–93

geographic hierarchies, 95–97

geographic role assignment, 93–95

heat maps

creating, 89–90

features of, 88

supported geodata, 92

treemaps

creating, 86–88

features of, 85–86

mark borders, 119

mark halos, 120–121

Marks card. See also charts; maps

bar charts, 68–69

choropleth maps, 101–103

geodata, 92

heat maps, 89–90

line charts, 72

lollipop charts, 218

pie and donut charts, 74–78

scatter plots, 81

treemaps, 88

matrix scatter pots, 79–82

McCandless, David, 230

McKinsey Global Institute, 11

measures

defined, 48

types of, 48

Medina, John, 109

menus, 46–47

meta helper file, creating, 153–155

Minard, Charles Joseph

Hannibal’s journey visualization, 31

Napoleon’s march visualization, 29–31

“Monstrous Costs” (Holmes), 31–32

motor cortex, 18

multiple tables

joins

configuring, 42

errors in, 44

inner, 43

left, 43

outer, 43

right, 43

Murray, Daniel, 230

My Tableau Repository, adding custom shapes to, 140–142

N

Napoleon’s march visualization, 29–31

narrated storytelling, 63

narrative structures, 177–178

National Geographic, 16

natural selection, theory of, 19

navigating user interface, 45–46

Negative Sentiment field (divergent stacked bar chart), 206–207

“The Nerdist” podcast, 168

Netflix data visualization, 23–25

neutrality in maps, 105–106

Nightingale, Florence, 108

nominal measures, 48

non-narrated storytelling, 63

normalizing data, 56

null values, handling, 43–44, 147–148

Number of Records Dimension, 99

numbers, discrete versus continuous, 48

numeric copies of worksheets, creating, 151–153

numerosity, 27

O

olfactory cortex, 18

opacity, 118–119

ordinal measures, 48

outer joins, 43

outliers, 60

P

pace of storytelling, 228

packed bubble charts

creating, 83–85

features of, 83

Pages shelf, 47

Percent of Gantt Sizing field (divergent stacked bar chart), 210

perceptual pop-out, 26–27

personal Netflix data visualization, 23–25

Pi, Wake, 85

picture superiority effect, 109

pie charts

creating, 74–78

features of, 73–74

pills, color-coded, 49

pivoting data from wide to tall, 155

planning story purpose, 176–177

Playfair, William, 10, 108

plot, 59–60

Polygraph, 230

power of stories, 20

Anscombe’s Quartet, 21

classic visualization example, 20–22

color cues, 26–27

Napoleon’s march visualization, 29–31

Netflix data visualization, 23–25

Nigel Holmes’ “Monstrous Costs,” 31–32

seasonal cycle visualization, 27–29

pre-attentive features, perceptual pop-out, 26–27

preparing data. See data preparation

presentations

narrated, 63

non-narrated, 63

tips for, 64

pricing models for Tableau, 37

proportional symbol maps, 97–100

psychology of storytelling, 18–19

closure, 19

fitness, 19

Ptolemy, Claudius, 108

The Pudding, 230

purpose of stories, 176–177

Q-R

QuestionID, 205–206

Radiant Advisors, DVCC (Data Visualization Competency Center), 228–229

ratio measures, 48

red/green color palettes, 121–123

reference lines, adding to timeline charts, 197–199

relevant context, 55–56

removing

field labels, 136–138

headers, 136–138

renaming columns, 40

resources

blogs, 229–230

books, 230

companion materials, 231

Tableau resources, 231

reveals

designing to, 227

false reveals, 227

reversed color, 115–117

right joins, 43

rising action (narrative structure), 177–178

Roddenberry, Gene, 2

roles, geographic, 93–95

Rosling, Hans, 2

Rowling, JK, 53. See also Harry Potter series visualizations

Rows shelf, 47

Ryan, Lindy, 230

S

Salesforce, 34

Save button, 46

scatter plots

creating, 79–82

features of, 78–79

science of storytelling, 16

cognitive effects, 16–18

power of stories, 20

storytelling psychology, 18–19

closure, 19

fitness, 19

seasonal cycle visualization, 27–29

Seinfeld, Jerry, 64

sensory cortex, 18

sequential color, 111–112

setup (narrative structure), 177

shading lines, 134–139

Shape Marks card, 139–140

shapefiles, 92

shapes, 139

custom shapes, 140–142

Shape Marks card, 139–140

transparent backgrounds, 141

sheets, 40, 45, 169

shelves, 47

Show Me card, 47, 74–75

expanding, 57

packed bubble charts, 83–85

pie and donut charts, 74–78

treemaps, 86–87

SIG DSS (Special Interest Group on Decision Support, Knowledge, and Data Management Systems), 8

Significant Volcanic Eruptions dataset, 144

simple scatter plots, 79–82

Size Marks card, 99

bar-in-bar charts, 199–201

divergent stacked bar charts, 214

lollipop charts, 219

proportional symbol maps, 99

shapes, 139

word clouds, 221

sketching stories, 78

Snapchat, National Geographic on, 16

Snow, John, 108

spatial files, 92

Special Interest Group on Decision Support, Knowledge, and Data Management Systems (SIG DSS), 8

speed of storytelling, 228

spread, 60

spring, data visualization of, 27–29

stacked bar charts

100% stacked bar charts, 203–204

divergent stacked bar charts

creating, 205–206

Gantt Percent Line field, 211–215

Gantt Start field, 209–211

Negative Sentiment field, 206–207

Percent of Gantt Sizing field, 210

Total Negative Sentiment field, 207–208

Total Sentiment Scores field, 209

Star Trek, 2

Statistical Breviary (Playfair), 10

stepped color, 114–115

steps to visual data storytelling, 226–228

sticky notes, storyboarding with, 178

stories. See also storyboarding; storytelling

building

dashboards, 169–172

sheets, 167–168, 169

Story Points, 172–175

defined, 45

genre, 60

plot, 59–60

power of

Anscombe’s Quartet, 21–22

classic visualization example, 20–22

color cues, 26–27

Napoleon’s march visualization, 29–31

Netflix data visualization, 23–25

Nigel Holmes’ “Monstrous Costs,” 31–32

seasonal cycle visualization, 27–29

purpose, 176–177

sketching, 78

storyline, 59–60

structure of, 58

genre, 60

plot, 59–60

Story Points, 172–175

storyboarding, 167–168

demographic data

age, 182–185

gender, 181–182

number of responses, 180–181

Harry Potter example, 185–190

character aggression, questioning, 187–188

demographic dashboard and key question, 185–186

reveal, 188–190

Meta worksheets, 179

narrative structures, 177–178

sticky note approach, 178

story building, 178

dashboards, 169–172

sheets, 167–168, 169

Story Points, 172–175

story purpose, planning, 176–177

survey demographics

age, 182–185

gender, 181–182

story-building mechanisms

dashboards, 169–172

sheets, 167–168, 169

Story Points, 172–175

storyline, 59–60

storytelling. See also data visualization

audience analysis for, 61–63

checklist for, 175

collecting data for, 226

communication skills in, 8–10

context

audience analysis, 61–63

cautions, 53

data, 53–55

explanatory analysis, 56–58

exploratory analysis, 56–58

Harry Potter series example, 53–55

importance of, 51–52

presentation tips, 63–64

relevance of, 55–56

role of story structure in, 58–60

entropy in, 31, 228

evolution from data visualization to, 6–7

external resources

blogs, 229–230

books, 230

companion materials, 231

Tableau resources, 231

feedback for, 228–229

goals, 26

information layering, 227

narrated, 63

non-narrated, 63

ongoing learning for, 229

pace of, 228

power of stories

Anscombe’s Quartet, 21–22

classic visualization example, 20–22

color cues, 26–27

Napoleon’s march visualization, 29–31

Netflix data visualization, 23–25

Nigel Holmes’ “Monstrous Costs,” 31–32

seasonal cycle visualization, 27–29

presentation tips, 64

reveals

designing to, 227

false reveals, 227

science of, 16

cognitive effects, 16–18

storytelling psychology, 18–19

sketching stories, 78

steps to visual data storytelling, 226–228

story structure, 58

genre, 60

plot, 59–60

storyboarding, 167–168

demographic data, 179–185

Harry Potter example, 185–190

Meta worksheets, 179

narrative structures, 177–178

sticky note approach, 178

story building, 178

story purpose, planning, 176–177

story-building mechanisms

dashboards, 169–172

sheets, 167–168

Story Points, 172–175

visual revolution in, 2–6

Storytelling with Data (Knaflic), 230

streaming visualizations, 2

surface cleaning (survey data), 150–151

survey data, cleaning

with Alteryx, 165

with Data Interpreter

cautions, 149

goals of, 148–150

meta helper file, creating, 153–155

numeric copies, creating, 151–153

pivoting from wide to tall, 155

surface cleaning, 150–151

with Maestro, 145

with Tableau 10, 156

data sources, joining, 160–164

extracts, creating, 156–160

survey demographics

age, 182–185

gender, 181–182

number of responses, 180–181

survival of the fittest, 19

Swanstrom, Ryan, 12

Swiss Federal Institute of Technology, 2

T

Tableau 10, shaping survey data with, 156

data sources, joining, 160–164

extracts, creating, 156–160

Tableau product portfolio

advantages of, 34–36

mission of, 34

pricing model, 37

Tableau Desktop, 37

Tableau Online, 37

Tableau Public, 37

Tableau Server, 37

Tableau resources, 231

Tableau Your Data (Murray), 230

tables

connecting to, 39–41

joins, 42

configuring, 42

errors in, 44

inner, 43

left, 43

outer, 43

right, 43

null fields, 43–44

Teradata University Network (TUN), 8

testing, user, 228–229

Text Marks card

borders, 133

divergent stacked bar charts, 205–206

word clouds, 221

Text Value dimensions, 205–206

theory of natural selection, 19

timeframes, adding to timeline charts, 197

timeline charts, 192–199

calculated fields, 194–195

continuous dates, 193

formatting, 196

reference lines, 197–199

timeframes, 197

toolbar, 46–47

Total Negative Sentiment field (divergent stacked bar chart), 207–208

Total Sentiment Scores field (divergent stacked bar chart), 209

transparent backgrounds, 141

treemaps

creating, 86–88

features of, 85–86

trend lines, 66

Trendalyzer, 2

Tukey, John, 108

TUN (Teradata University Network), 8

Tyson, Neil DeGrasse, 168, 226

U

Undo button, 46

university data science programs, 10–12

user interface, 169–172. See also cards

cards, 47

dashboards, 45, 169–172

Data window, 47

dimensions, 48

legends, 47–48

measures

defined, 48

types of, 48

menus, 46–47

navigating, 45–46

shelves, 47

toolbar, 46–47

user testing, 228–229

V

visual cortex, 18

visual design, 110

color

100% stacked bar charts, 204

alerting, 121

categorical, 115–117

color legends, 124

default color, 110–111

diverging, 112–114

highlight, 120

mark borders, 119

mark halos, 120–121

opacity, 118–119

red/green color palettes, 121–123

reversed, 115–117

sequential, 111–112

stepped, 114–115

designing to reveal, 227

lines

borders, 131–134

drop lines, 128–130

Format pane, 124–128

grid lines, 128–130

shading, 134–139

zero lines, 128–130

picture superiority effect, 109

power of, 107–109

shapes, 139

custom shapes, 140–142

Shape Marks card, 139–140

transparent backgrounds, 141

The Visual Imperative (Ryan), 56, 109, 230

visual revolution, 2–6

visualization. See data visualization

visualization types. See also visual design

charts, 65–66, 191–192

100% stacked bar charts, 203–204

bar charts, 66–70

bar-in-bar charts, 199–201

divergent stacked bar charts, 205–215

donut charts, 73–78

field labels, 136–138

headers, 136–138

Likert scales, 202–203

line charts, 70–73

lollipop charts, 215–220

packed bubble charts, 83–85

pie charts, 73–78

scatter plots, 78–82

timeline charts, 192–199

graphs

heat maps, 88–90

treemaps, 85–88

maps, 91–92

background maps, 105

choropleth maps, 100–103

geographic data connections, 92–93

geographic hierarchies, 95–97

geographic role assignment, 93–95

map layers, 103–105

neutrality in, 105–106

proportional symbol maps, 97–100

supported geodata, 92

word clouds, 221–224

VizQL, 36

Vonnegut, Kurt, 7

W

waning summer, data visualization of, 27–29

waxing summer, data visualization of, 27–29

Wernicke’s area of the brain, 16

Wexler, Steve, 156, 229, 230

Which Chart or Graph (white paper), 91

word clouds, 221–224

workbooks, 45

worksheet survey data, cleaning. See Excel survey data, cleaning

X-Y-Z

Yau, Nathan, 230

Zeigarnik, Bluma, 19

Zeigarnik effect, 19

zero lines, 128–130

ZN function, 147–148

zooming out, 59