Charts Flashcards

1
Q

1 - Match the image with the name:

Sankey Diagram
Tree Map
Bar Chart
DNA Chart
Non-geo Maps
Geo map
Line Chart
Heatmap
Waterfall Chart
Word Cloud
Box Plot
Waffle Chart

See note for Image.

A

(Across down)
Line Chart
bar Chart
word cloud
Heatmap

Box Plot
Tree Map
geo map
non-geo map

DNA (aka dumbbell) Chart
Waffle Chart
Sankey Diagram
Waterfall Chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Match the image with the name and description

Description:
* Density
* Distribution
* Contribution
* Correlation
* Change
* Matrix

Image 2

A

Image 2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the name of a visualization including Min, max, Q1, Q3, and Median?

A

Box Plot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the name of the 6 points in a box plot? (from top to bottom)

A

outlier, max, Q3, median, Q1, min, outlier

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

____ explains the net change in value b/t 2 pts, spit over categories.

A

Waterfall (bridge) chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

_____ can use color to separate + VS - values

A

Waterfall (bridge) chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

___ works well with a limited amount of categories

A

Waterfall (bridge) chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

____ is often used with financial values

A

Waterfall (bridge) chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

____ presents density & comparison with color, often in a matrix form

A

Heatmap

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Name 2 types of Heatmaps

A

Colored (geo-)map
E.g., density of the population

Matrix comparison (as in examples used in notes)
E.g., comparing temperatures per day and month

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

___ is hard to interpret without detailed labels

A

Heatmap

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

_____ shows the relationship bt 2 numerical variables plotted along both the X and Y axis

A

Scatter plot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

___is often used in exploratory data analysis

A

Scatter plot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What can make scatter plots difficult to understand?

A

many data marks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

3 Descriptions of Scatter pots

A

Hint: QMD
.
.
.

Hint: Quadrant - Multidimensional-Data Marks

Used to plot data on a quadrant

Can be multidimensional, with the use of color, size, and shape

Can store a relatively high number of data marks (but too many data marks can cause confusion)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Use ___ if you want to spot trends and differences bt categories

A

box plot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

3-What is the skewness of the images? (describe with +/- and L/R)

see image in notes

A

see answer in notes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Use ___ if you want to compare distributions among multiple categories

A

box plot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

4- What is the excess kurtosis of these box plots?

mesokurtic
playkutic
leptokurtic

Which ones are +/-?

See image in notes

A

See image for answer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is the skew for this box plot:

Most of the Outliers are to the left.
Box is to the right, close to the max.

A

Left (negative) skew

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is the skew for this box plot:

Most of the Outliers are to the right.
Box is to the left, close to the min.

A

Right (+) skew

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Describe a leptokuric box plot

Is it +/-?

A

see image 4
+

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Describe a mesokurtic boxplot

A

see image 4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Describe a playkurtic boxplot

+/-?

A

see image 4

-

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

what does a CI of 95 mean?

A

CI = Confidence interval

I’m 95% confident that the true population mean lies w/in the ranges of my confidence interval.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What chart would you use to analyze if you have a loss or profit in your Sales data?

A

Waterfall Chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What chart would you use to compare the difference in sales for each category by year?

(e.g. the difference between Table sales in 2005 VS 2006)

A

DNA/Dumbbell chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What does a box plot have: Median or Average?

A

Median

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

A Waterfall chart is also called ____

A

Bridge chart

30
Q

A DNA chart is also called a ____

A

Dumbbell chart

31
Q

T/F

Tableau has 3 variants of heat maps

A

False, there are 2:

heat maps & highlight tables

32
Q

T/F

Highlight Tables is not a Heatmap.

A

False. It is a heatmap.

33
Q

Create a waterfall Chart in DataCamp:

Data Visualization in Tablea > 1 > Winners or lossers - a waterfall chart

https://campus.datacamp.com/courses/data-visualization-in-tableau/start-to-visualize?ex=14

34
Q

How can you get to the format option that allows you to change the color and decimal place of a measure label?

A

Find measure on row/column section
> click down arrow
> > ‘Format…’

35
Q

How to add “Top 10” in a tooltip, the top 10 changing based on each data point that has the tooltip.

Data Visualization > 2 > Hiding extra goodies in the tooltip

https://campus.datacamp.com/courses/data-visualization-in-tableau/best-practices-in-data-visualization?ex=12

36
Q

What are the type of actions you can do in a dashboard?

A

Filter
Highlight
Go to URL
Go to Sheet
Change Parameter
Change Set Values

37
Q

Comeplete DataCamp Questions

Data Visualization > 4 > Which chart works best?

https://campus.datacamp.com/courses/data-visualization-in-tableau/information-is-beautiful-expanding-your-charting-toolbox?ex=2

38
Q

Create a Waffle Chart

Data Visualization > 4 > Eat that Waffle!

https://campus.datacamp.com/courses/data-visualization-in-tableau/information-is-beautiful-expanding-your-charting-toolbox?ex=4

39
Q

Create a DNA chart

Data Visualization > 4 > Distribution w/ DNA charts

https://campus.datacamp.com/courses/data-visualization-in-tableau/information-is-beautiful-expanding-your-charting-toolbox?ex=5

40
Q

How do you remove grid lines from the visual?

A

Click “Format”> Lines
or
Right Click visual >Format>lines icon

> Next to “Grid lines” choose “none”

41
Q

How can you hide the “null values indicato”?

A

Analysis menu (tab) > Special Values > Hide

42
Q

How do you change the size of a chart you inserted into the tooltip?

A

Change the number in the code.

e.g. after inserting the sheet, you’ll have this code:

< Sheet name=”Sparklines” maxwidth=”300” maxheight=”300” filter=”<All>" ></All>

43
Q

How do you insert a chart into a tooltip.

A

Tooltip > Insert > Sheet

44
Q

How do you change the sorting from the SUM of the measure to the Median?

A

Right click/down arrow the dimension > “Sort…” > change AGG to Median

45
Q

What statistics would you use to describe a skewed distribution?

  • variance
  • IQR
  • mean
  • median
  • mode
  • std deviation
A

median and IQR bc they are less effected by extreme values

Think: what would I use for a box plot?

46
Q

Put these in order

https://campus.datacamp.com/courses/statistical-techniques-in-tableau/measures-of-spread-and-confidence-intervals?ex=9

47
Q

Discrete or Continuous?

Image 6

48
Q

Discrete or Continuous?

Image 7

49
Q

Discrete or Continuous?

Image 8

50
Q

Discrete or Continuous?

Image 9

51
Q

Discrete or Continuous?

A daily patter of customers activity refleced with 1 axis showing the hrs of the day

52
Q

Discrete or Continuous?

Date shown as an unbroken time series

53
Q

Discrete or Continuous?

Year to date reflected in a timeline showing sales marked on the axis by week

A

continuous

54
Q

Discrete or Continuous?

all months of several years combined into single iterations of the months for trend analysis

55
Q

What does churn rate mean?

A

The rate at which customers are leaving business/stop using services

56
Q

What is the Churn Rate formula?

A

Churn Rate = (# of lost customers)/(total # of customers)

57
Q

What is the number format of Churn Rate? What is the range?

A

A percentage

0-100%

58
Q

What does this data point mean?

Image 11

A

Customers from 60-65 have an average churn rate of 24.77%

59
Q

When placing a “Top N” chart inside the tooltip of a Word Cloud chart, what do you need to do to ensure that the “Top N” chart changes based on the Word Cloud input?

A

Edit the filter order of the “Top N” worksheet so that “Tooltip (dimension?)” is a context filter.

Image 14

60
Q

You use the Gantt Bar option in the Marks card to create a ___ chart

A

Waterfall & DNA

61
Q

T/F

You use the Gantt Bar option in the Marks card to create a DNA chart

A

True

Use it to create the line between the 2 values

62
Q

How to add 2 measures as “Measure Values” to a column/row

A
  1. Insert 1 measure to column/row as usual
  2. Insert 2nd meaure onto the visual. Place in the column/row header (not into the small box).

Image 16

2:10 in video
https://campus.datacamp.com/courses/data-visualization-in-tableau/information-is-beautiful-expanding-your-charting-toolbox?ex=5

63
Q

T/F

If a step/gradiant color scale is used, the measure is continious

A

False

“Discrete or Continuous” is not based on whether the color is a step/gradient, it’s based on the measure/dimension being used

64
Q

T/F

The “Discrete or Continuous” is based on the measure/dimension being used.

65
Q

T/F

Measures can be sets

A

False
Only dimensions can be sets.

66
Q

T/F

Only dimensions can be sets

67
Q

To __ , you need to create a filter on a calculated field containing a parameter

  • Swap between sheets inside a Dashboard
  • Swap between measures in a sheet
A

Swap between sheets inside a Dashboard

68
Q

To __ , you need to create a calculated field containing parameter in the view

  • Swap between sheets inside a Dashboard
  • Swap between measures in a sheet
A

Swap between measures in a sheet

69
Q

To swap between measures in a sheet, you need to ___

*create a filter on a calculated field containing a parameter
*create a calculated field containing parameter in the view

A

create a filter on a calculated field containing a parameter

70
Q

To swap between sheets inside a Dashboard, you need to ___

*create a filter on a calculated field containing a parameter
*create a calculated field containing parameter in the view

A

create a filter on a calculated field containing a parameter