Desktop Specialist Review 1 Flashcards
What is Tableau’s order of operations for filters?
- Extract Filters
- Data Source Filters
- Context Filters
- Dimension Filters
- Measure Filters
- Table Calc Filters
What types of information does Tableau list as necessary for connecting to a data source, and therefore is included in a .tds file?
- Data source type
- Connection information such as server address, port, location of local files, tables
- Groups, sets, calculated fields, bins
- Default field properties such as number formats, aggregation, and sort order
True or false: it is possible to blend axes for multiple measures into a single axis
True, this creates a comined-axis/blended-axis chart.
What is the minimum field requirement to create a bullet chart?
Two measures
What are the basic building blocks of a histogram?
- Mark type: automatic
- One continuous measure, aggregated by Count or Count Distinct
- Bin, continuous or discrete, created from the continuous measure, on the rows shelf
When can a bin be created on a dimension?
When the dimension is numerical
What are the ways you can create groups in Tableau?
- Select marks in the view
- Select labels in the view
- Select fields from the dimensions shelf
If you create a group by selecting marks, what will happen?
The marks will remain distinct, but will be grouped by color.
If you create a group by selecting the labels, what will happen?
The selected (grouped) marks will be consolidated into one mark.
If you create a group by selecting fields in the dimensions shelf, what will happen?
A new dimension will be created.
What are the ways you can show Mark Labels in the viz?
- Click the ‘Show Mark Labels’ icon in the Toolbar
- Drag the desired measure to the ‘Text’ icon in the Marks Card
- Click Analysis in Menu bar –> Show Mark Labels
What is the one critical difference between normal calculated fields and the calculated fields created after data blending?
Fields used in Blends must first be aggregated
What type of file does Tableau recognize a CSV file as?
a Text file
Data blending simulates a traditional _____ join.
Left
What is the best way to change the formatting at a workbook level?
Format in Menu bar –> specify formatting the new Format workbook pane
How can you format an axis as Bold in Tableau?
Right click the axis –> format –> set font to Bold
How can you gain the ability to use one sheet as a filter for another?
Combine the sheets using dashboards
How do you add a reference line to the view?
Assuming you have a continuous axis…
Analytics pane –> Drag ‘Reference Line’ into view and place on one of the destinations that appears
What are the ways we can trigger actions in a Dashboard?
- Select
- Hover
- Menu
When using a Blend, what is the color of the tick-mark on the primary and secondary data sources respectively?
Blue, Orange
What are the 5 types of trend lines available in Tableau?
- Linear
- Logarithmic
- Exponential
- Polynomial
- Power Model
What do you need to use to deploy a URL action on a dashboard object to open a Web Page within a dashboard instead of a browser?
A Web-Page object
What data combination method in Tableau is the best way to avoid duplicate rows?
relationships
Name the free desktop application that you can use to open and interact with data visualizations built in Tableau and shared locally
Tableau Reader