Charts Flashcards
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
Match the image with the name and description
Description:
* Density
* Distribution
* Contribution
* Correlation
* Change
* Matrix
Image 2
Image 2
What is the name of a visualization including Min, max, Q1, Q3, and Median?
Box Plot
What is the name of the 6 points in a box plot? (from top to bottom)
outlier, max, Q3, median, Q1, min, outlier
____ explains the net change in value b/t 2 pts, spit over categories.
Waterfall (bridge) chart
_____ can use color to separate + VS - values
Waterfall (bridge) chart
___ works well with a limited amount of categories
Waterfall (bridge) chart
____ is often used with financial values
Waterfall (bridge) chart
____ presents density & comparison with color, often in a matrix form
Heatmap
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
___ is hard to interpret without detailed labels
Heatmap
_____ shows the relationship bt 2 numerical variables plotted along both the X and Y axis
Scatter plot
___is often used in exploratory data analysis
Scatter plot
What can make scatter plots difficult to understand?
many data marks
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)
Use ___ if you want to spot trends and differences bt categories
box plot
3-What is the skewness of the images? (describe with +/- and L/R)
see image in notes
see answer in notes
Use ___ if you want to compare distributions among multiple categories
box plot
4- What is the excess kurtosis of these box plots?
mesokurtic
playkutic
leptokurtic
Which ones are +/-?
See image in notes
See image for answer
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
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
Describe a leptokuric box plot
Is it +/-?
see image 4
+
Describe a mesokurtic boxplot
see image 4
Describe a playkurtic boxplot
+/-?
see image 4
-
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
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
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?
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!
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
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=”<All>" ></All>
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
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
- Insert 1 measure to column/row as usual
- 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
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 filter on a calculated field containing a parameter
- Swap between sheets inside a Dashboard
- Swap between measures in a sheet
Swap between sheets inside a Dashboard
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
Swap between measures in a sheet
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
create a filter on a calculated field containing a parameter
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
create a filter on a calculated field containing a parameter