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