Charts Flashcards by Alicia Alcaraz

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.

(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?

Not at all

Perfectly

Match the image with the name and description

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

Image 2

How well did you know this?

Not at all

Perfectly

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

Box Plot

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

Waterfall (bridge) chart

How well did you know this?

Not at all

Perfectly

_____ can use color to separate + VS - values

Waterfall (bridge) chart

How well did you know this?

Not at all

Perfectly

___ works well with a limited amount of categories

Waterfall (bridge) chart

How well did you know this?

Not at all

Perfectly

____ is often used with financial values

Waterfall (bridge) chart

How well did you know this?

Not at all

Perfectly

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

Heatmap

How well did you know this?

Not at all

Perfectly

Name 2 types of Heatmaps

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?

Not at all

Perfectly

___ is hard to interpret without detailed labels

Heatmap

How well did you know this?

Not at all

Perfectly

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

Scatter plot

How well did you know this?

Not at all

Perfectly

___is often used in exploratory data analysis

Scatter plot

How well did you know this?

Not at all

Perfectly

What can make scatter plots difficult to understand?

many data marks

How well did you know this?

Not at all

Perfectly

3 Descriptions of Scatter pots

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?

Not at all

Perfectly

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

box plot

How well did you know this?

Not at all

Perfectly

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

see image in notes

see answer in notes

How well did you know this?

Not at all

Perfectly

Use ___ if you want to compare distributions among multiple categories

box plot

How well did you know this?

Not at all

Perfectly

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

mesokurtic
playkutic
leptokurtic

Which ones are +/-?

See image in notes

See image for answer

How well did you know this?

Not at all

Perfectly

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.

Left (negative) skew

How well did you know this?

Not at all

Perfectly

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.

Right (+) skew

How well did you know this?

Not at all

Perfectly

Describe a leptokuric box plot

Is it +/-?

see image 4
+

How well did you know this?

Not at all

Perfectly

Describe a mesokurtic boxplot

see image 4

How well did you know this?

Not at all

Perfectly

Describe a playkurtic boxplot

+/-?

see image 4

How well did you know this?

Not at all

Perfectly

what does a CI of 95 mean?

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

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

Waterfall Chart

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)

DNA/Dumbbell chart

What does a box plot have: Median or Average?

Median

A Waterfall chart is also called ____

Bridge chart

A DNA chart is also called a ____

Dumbbell chart

# T/F Tableau has 3 variants of heat maps

False, there are 2: heat maps & highlight tables

# T/F Highlight Tables is not a Heatmap.

False. It is a heatmap.

Create a waterfall Chart in DataCamp: Data Visualization in Tablea > 1 > Winners or lossers - a waterfall chart ## Footnote https://campus.datacamp.com/courses/data-visualization-in-tableau/start-to-visualize?ex=14

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

Find measure on row/column section > click down arrow > > 'Format...'

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 ## Footnote https://campus.datacamp.com/courses/data-visualization-in-tableau/best-practices-in-data-visualization?ex=12

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

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

Comeplete DataCamp Questions | Data Visualization > 4 > Which chart works best? ## Footnote https://campus.datacamp.com/courses/data-visualization-in-tableau/information-is-beautiful-expanding-your-charting-toolbox?ex=2

Create a Waffle Chart | Data Visualization > 4 > Eat that Waffle! ## Footnote https://campus.datacamp.com/courses/data-visualization-in-tableau/information-is-beautiful-expanding-your-charting-toolbox?ex=4

Create a DNA chart | Data Visualization > 4 > Distribution w/ DNA charts ## Footnote https://campus.datacamp.com/courses/data-visualization-in-tableau/information-is-beautiful-expanding-your-charting-toolbox?ex=5

How do you remove grid lines from the visual?

Click "Format"> Lines or Right Click visual >Format>lines icon > Next to "Grid lines" choose "none"

How can you hide the "null values indicato"?

Analysis menu (tab) > Special Values > Hide

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

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="" >

How do you insert a chart into a tooltip.

Tooltip > Insert > Sheet

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

Right click/down arrow the dimension > "Sort..." > change AGG to Median

What statistics would you use to describe a skewed distribution? * variance * IQR * mean * median * mode * std deviation

median and IQR bc they are less effected by extreme values Think: what would I use for a box plot?

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

Image 15

Discrete or Continuous? | Image 6

Discrete or Continuous? | Image 7

Discrete or Continuous? | Image 8

Discrete or Continuous? | Image 9

# Discrete or Continuous? A daily patter of customers activity refleced with 1 axis showing the hrs of the day

discrete

# Discrete or Continuous? Date shown as an unbroken time series

continuos

# Discrete or Continuous? Year to date reflected in a timeline showing sales marked on the axis by week

continuous

# Discrete or Continuous? all months of several years combined into single iterations of the months for trend analysis

discrete

What does churn rate mean?

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

What is the Churn Rate formula?

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

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

A percentage 0-100%

What does this data point mean? | Image 11

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

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?

Edit the filter order of the "Top N" worksheet so that "Tooltip (dimension?)" is a context filter. | Image 14

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

Waterfall & DNA

# T/F You use the Gantt Bar option in the Marks card to create a DNA chart

True Use it to create the line between the 2 values

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

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 ## Footnote 2:10 in video https://campus.datacamp.com/courses/data-visualization-in-tableau/information-is-beautiful-expanding-your-charting-toolbox?ex=5

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

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

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

True

# T/F Measures can be sets

False Only dimensions can be sets.

# T/F Only dimensions can be sets

True

To ____ , you need to create a parameter, create a sheet with buttons, create a filter on calculated field containing a parameter, set parameter action 1. Swap between sheets inside a Dashboard 2. Swap between measures in a sheet

1 - Swap between **sheets inside a Dashboard** ## Footnote https://www.tableau.com/blog/lrtt-parameters-alter-your-viz-40767?_ga=2.197414312.684122406.1638104830-1312171549.1564256819&_fsi=PKQ5uOGQ

To ____ , you need to create a parameter, create a calculated field containing parameter in the view, show parameter 1. Swap between sheets inside a Dashboard 2. Swap between measures in a view

2 - Swap between **measures in a sheet**

To swap between measures in a sheet, you need to ___ 1. create a parameter, create a calculated field containing parameter in the view, show parameter 2. create a parameter, create a sheet with buttons, create a filter on calculated field containing a parameter, set parameter action

1 ## Footnote https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm

To swap between sheets inside a Dashboard, you need to ___ 1. create a parameter, create a calculated field containing parameter in the view, show parameter 2. create a parameter, create a sheet with buttons, create a filter on calculated field containing a parameter, set parameter action

What are the shelves in Tableau?

* Columns * Rows * Pages * Filters * Marks * Legend * Shape Legend Shelf

What are these called? * Columns * Rows * Pages * Filters * Marks Card * Legend

Shelves (e.g. clear shelf, edit in shelf) & Cards (e.g. Marks Card) ## Footnote https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm

When you want to edit a dimension/measure in Columns, you would say "Edit in __"

shelf

When you want to hide the Filter box, you should say "Hide _"

Card

When you want to clear the Pages, you would say "Clear ___"

Shelf

When you want to edit a dimension/measure in Columns, you would say "Edit in __"

Shelf

When you want to hide Marks, you should say "Hide _"

Card

A _ Filter is an independent filter such that all the other filters will be applied to the data that is fetched by the _ Filter. * Extract Filters. * Data Source Filters. * Context Filters. * Dimension Filters. * Measure Filters. * Table Calculation Filters.

Context

# T/F To remove grid lines from a visual, you click Dashboard Menu > "Grid options"

False, this will create grid lines as a guide for you on the dashboard tab, but it won't show up on the actual visual.