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
Where can one open a Tableau Support case?
Tableau website –> support option
What icon represents a grouped field?
paperclip
What feature helps to fix fields that have different names (indicated by an exclamation point) when you connect to a new data source?
Replace References
True or False: Sets can be created on Measures
False
True or False: To concatenate fields, they must be of same data type
True, but we can use Type Casting to convert fields to other types as a workaround
What type of chart contains both bars and a line graph, where individual values are represented in descending order by bars and the cumulative total is represented by the line?
Pareto chart
How can you manually assign geographic roles to a dimension from the data pane?
Right click the dimension –> Geographic role –> assign role
True or False: It is possible to change the Geographic Role of a dimension
True
For a relative date filter, the default anchor is _________________
Today’s date
True or False: Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.
True
You can use the __________________ in Tableau to clean / organize your data.
Data interpreter
Which of the following is the correct way to calculate Profit Ratio in Tableau?
SUM([Profit]) / SUM([Sales])
What view includes the sections ‘Summarize’, ‘Model’, and ‘Custom’?
the Analytics Pane
__________ is a technique in Tableau which will identify marks with similar characteristics
Clustering
True or False:
Animations work well with maps, polygons, and density marks in web browsers
False
What type of chart is ideal for showing the duration of events or activities?
A Gantt chart
