Data Visualization Midterm -- Tableau Questions
A table calculation is _______? A) A secondary calculation that is performed on top of the result set in the Viz B) A calculation done at the source level C) A calculation that is fixed regardless of the pills in the view D) B and C
A secondary calculation that is performed on top of the result set in the Viz
A "range of values" filter is not: _______? A) The most flexible if you want your end user to control both the ranges B) An interactive filter C) A special filter in tableau D) A tool to sort the data
A tool to sort the data
The purpose of using a scatterplot is to? A) Effectively display two measures B) "Slice and dice" the data in a condensed space C) Help identify patterns D) All of the above
All the above
Through which element of Tableau can you filter a visualization? A) Filter Shelf B) Interactive Filter C) View D) All of the Above
All the above
What elements of a reference line can you change in a visualization? A) The value by which the reference line aggregates B) The scope of the reference line C) The label of the reference line D) All of the Above
All the above
The reference line and trend line can be found in the? A) Marks Card B) Analytics Tab C) Measures Shelf D) Filter Shelf
Analytics tab
A Macro filter will allow you to _________? A) Filter by the most granular level of detail in a dimension and measure B) Increase the size of your data C) Apply a filter to the entire data before you create a view D) Tell on detailed story
Apply a filter to the entire data before you create a view
To transform a line chart to a stack area chart change mark type from automatic to _____? A) Shape B) Square C) Circle D) Area
Area
The purpose of filtering is to: ___________? A) Change the underlying values B) Remove outliers C) Clean up underlying data D) B and C
B and C
What type of variable, usually, is a dimension in Tableau?
Categorical and Qualitative
The Detail Shelf on the Marks Card A) Changes the granularity of the view by adding dimensions to the view B) Is used to add details to the tooltips of the marks in the view C) Changes the granularity of the view without adding dimensions to the view D) Is used to change the level of detail of a hierarchy
Changes the granularity of the view without adding dimensions to the view.
The code below would _____________ in Tableau? IF SUM([Profit]) > 0 THEN "Positive" ELSE "Negative" END A) Create a category for all Profits with above 0 labeled "Positive" B) Create a category for all Profits with above 0 labeled "Negative" C) Sum all the Profits above 0 D) Use 0 as a reference line in the visualization
Create a category for all Profits with above 0 labeled "Positive"
Using reference lines with scatter plots allows you to? A) Transform the visualization B) Create distinct quadrants to help interpret the data C) "Slice and dice" the data D) Avoid segmentation of the data
Create distinct quadrants to help interpret the data
Creating a calculated field is as easy as right clicking in the _______ and selecting calculated field. A) Data Pane B) Marks Card C) View D) Filter Shelf
Data pane
A mark is a ______ in the view.
Data point
How can you remove a filter? A) Drag the pill off the filter shelf B) Drag a pill to the color shelf C) Drag a pill to the filter shelf D) Double click the pill on the filter shelf
Drag the pill off the filter shelf
If we create a scatter plot showing SUM(Sales) on one axis, and SUM(Profit) on the other axis, Tableau will show just one point. We can add more marks to the view by doing the following, except: A) Adding a dimension to the Details Shelf B) Drilling-down to the underlying data C) Disaggregating the data
Drilling-down to the underlying data
A measure is an independent variable. (T or F)
False
Blue represents dimensions and green represents measures. (T or F)
False
Continuous Date fields can be considered individual date parts, just like any other member of a hierarchy. (T or F)
False
Continuous data can be sorted in the same way as discrete data. (T or F)
False
Continuous field can be sorted. (T or F)
False
Does the filter have to be a field in the view to filter the data? (T or F)
False
The default aggregation is AVE, and that works for most situations. (T or F)
False
The term drill "down" and drill "up" refers to? A) Scrolling through the data B) Finding a minimum and maximum of the data set C) Going further into and further out of the dimension hierarchy D) Mining the data
Going further into and further out of the dimension hierarchy
If you turn a variable from discrete to continuous the color will change to ______.
Green
Which elements can you not encode into the view to add depth to the analysis? A) Color B) Shape C) Size D) Label
Label
Highlight tables do not help the user? A) Quickly identify highs and lows or other interesting points in your data B) Enhance a cross tab C) Make one specific point D) Smooth transition from excel
Make one specific point
Similar to formulas in Excel, "calculations" in tableau allow you to ___________? A) Manipulate the data in any number of ways B) Drill up into the data C) Observe the data D) Transfer the data
Manipulate the data in any number of ways
Tableau does not allow you to ______? A) Mix aggregated and nonaggregate data within a calculated field e.g. SUM ([Profit]) / [Orders] B) Create a Fixed level of detail regardless of the pills in the view C) Create dynamic parameters that can be inputted into calculated fields D) Leverage calculated fields to color your view
Mix aggregated and nonaggregate data within a calculated field e.g. SUM ([Profit]) / [Orders]
A __________ is a slang term used for fields in the worksheet.
Pill
What type of dimension in the superstore data set has a unique filter? A) Region B) Ship Date C) Sales D) City
Ship date
Filtering cannot be done on the? A) Record or row level B) Size level C) Raw data level before the data even comes into Tableau D) Aggregated view
Size level
Bringing a measure or continuous green dimension to the filter shelf does not allow you to: _____________? A) Specify the level of aggregation to filter by B) Filter by a range of values C) Filter by a lower cut off value D) Sort by categories
Sort by categories
All are methods of sorting in Tableau, except: A) Sorting from axis B) Sorting from legend C) Sorting from data pane D) Sorting from toolbar
Sorting from data pane
What is not a type of trend line you can create in Tableau? A) Linear B) Logarithmic C) Exponential D) Squared
Sqaured
What should you convert the mark type to in the final step of a highlight table? A) Shape B) Square C) Circle D) Line
Square
In what different ways can you aggregate data in Tableau?
Sum, Avg, Max -- just some examples.
The purpose of a tree map is not to? A) Compare different dimensions across measures B) Quickly interpret respective contributions of measures to the whole C) Alternative to a pie chart D) Tell one detailed story
Tell one detailed story
What is level of detail in Tableau? A) The amount of detail in a visualization B) The amount of levels in a visualization C) A visualizations color D) The most granular level where the analysis takes place
The most granular level where the analysis takes place
What is an important distinction between a bar chart and a line graph? A) Size B) Time C) Dimensions D) Aggregation
Time
Which of these would not be a reason to use a calculated field? A) To show the highest level of detail B) To take advantage of the power of parameters C) To filter out unwanted results for better analyses D) To segment your data in new ways on the fly
To show the highest level of detail
How can you make a filter permanent? A) Drag it to the filter shelf B) Transform it to a global filter C) Drag the same filter again to the filter shelf D) Put size and color on the same field
Transform it to a global filter
A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different aggregation of the view than [Profit] / [Sales] ? (T or F)
True
A visualization in days is more granular than a visualization in months. (T or F)
True
Dates automatically receive a hierarchy in tableau (Year > Quarter > Month > Day). (T or F)
True
Dimensions define the number of marks, or the granularity of in the view. (T or F)
True
Discrete fields create headers. (T or F)
True
Duplicating a field, which is part of a hierarchy, creates a copy field without drill-down capabilities. (T or F)
True
Every visualization has a level of detail. (T or F)
True
Every worksheet in Tableau contains shelves and cards, such as Columns, Rows, Marks, Filters, Pages, Legends, and more. (T or F)
True
Hierarchies allow us to drill down to the next level of detail. (T or F)
True
In Tableau, every measure on a view is aggregated in some way by default. (T or F)
True
In Tableau, there are always multiple approaches for the same solution. (T or F)
True
Measures are automatically aggregated to the granularity of the view. (T or F)
True
The numerical value of each month in a year is a dimension. (T or F)
True
You can change measures into dimensions. (T or F)
True
What is the difference between heat maps and highlight tables? A) With a heat map you are able to encode the marks card by one less measure B) With a heat map you are able to encode the marks card by one more measure C) With a highlight table you can include one more dimension D) With a heat map you can include more colors
With a heat map you are able to encode the marks card by one more measure
The largest category in the date hierarchy in Tableau is a ______? A) Year B) Month C) Quarter D) Decade
Year