Desktop Specialist Flashcards
Earn Tableau Desktop Certification
What is the max # of tables you can join in Tableau?
32
What are the fields Tableau auto-generates?
- Measure names (Dimension)
- Latitude (Measure)
- Longitude (Measure)
- # of Records (Measure)
- Measure Values (Measure)
What is the default path for all supporting files?
Documents –> My Tableau Repository
What are the methods for combining data tables?
- Relationships
- Joins
- Unions
- Blends
What is the default duration for animations?
0.3 seconds
How many rows will View Data display by default?
10,000 rows
How do you change the default Tableau repository location?
File –> Repository Location (choose new location)
What are the permitted url prefixes?
- https
- http
- ftp
What are the accepted image file formats?
JPEG, PNG, and BMP
What are the ways to group data?
- Marks
- Labels
- Dimensions Shelf
What are the ways to show Mark Labels in a viz?
- Analysis –> Show Mark Labels
- Drag measure to Text in Marks
- Click ‘Show mark labels’ in Toolbar
What are the types of actions you can create in Tableau?
- Filter
- Highlight
- Go to URL
- Go to Sheet
- Change Parameter
- Change Set Values
What type of file contains one or more workbooks, zero or more dashboards and stories, and no data?
a .twb file
Which type of file contains one worksheet, to quickly share work?
a .tbm file
Which file contains a single zip file with a workbook and all its supporting data and images?
a .twbx file
Which file was formerly called .tde, and is an extract file, a copy of subsets or entire sets of data
a .hyper file
Which file type is a shortcut to frequently used original data, and doesn’t contain the actual data, but modifications such as default properties, calculated fields, groups, etc?
a .tds file
Which file type is a zip file that includes the .tds and .hyper files, as well as any text, Excel, Access, and local cube files?
a .tdsx file
How do you show all marks in the view at the most detailed level of granularity?
Disaggregate the view
What are containers of equal size that store data values called?
bins
True or False: trend lines can only be used with numeric or date fields
True
Which chart type displays the shape of a distribution, grouping values of a continuous measure into ranges called bins?
Histogram
Which chart type is ideal for portraying comparisons of total values across several categories?
Stacked Bar chart
Which chart type is marked with extra encodings to show progress towards a goal or other reference point?
Bullet chart
Which type of chart uses lines and filled areas to show how one or more groups’ numeric values change over time?
Area chart
What are two ways to create groups in Tableau?
- Select the data in the view, click paper clip icon
- Right-click a field in the data pane, select Create > Group
What are the essential steps in creating a cross-tab?
- Add a dimension to Rows
- Add a dimension to Columns
- Add a measure to Text in Marks
What are the types of quick table calculations Tableau offers?
- Running total
- Difference
- Percent difference
- Percent of total
- Rank
- Percentile
- Moving average
- YTD total
- Compound growth rate
- Year of year growth
- YTD growth
How do you create a hierarchy in Tableau?
In the data pane, drag a field and drop it directly on top of another field
How do you create a parameter?
Click the drop down arrow in the Data pane and select “Create Parameter”
Where can you go to add Totals to a view?
- Analytics pane
- Analysis in the menu
When can a bin be created from a dimension?
When the dimension is a numerical field
What is Tableau’s order of operations for filters?
- Extract Filters
- Data Source Filters
- Context Filters
(sets, conditional filters, top N, Fixed LOD) - Dimension Filters
(Include/Exclude LOD, data blending) - Measure Filters
(Forecasts, table calcs, clusters, totals) - Table Calc Filters
(Trend lines, reference lines)
