Desktop Specialist

Question 1

What is the max # of tables you can join in Tableau?

Answer 1

32

Question 2

What are the fields Tableau auto-generates?

Answer 2

1. Measure names (Dimension)
2. Latitude (Measure)
3. Longitude (Measure)
4. # of Records (Measure)
5. Measure Values (Measure)

Question 3

What is the default path for all supporting files?

Answer 3

Documents –> My Tableau Repository

Question 4

What are the methods for combining data tables?

Answer 4

1. Relationships
2. Joins
3. Unions
4. Blends

Question 5

What is the default duration for animations?

Answer 5

0.3 seconds

Question 6

How many rows will View Data display by default?

Answer 6

10,000 rows

Question 7

How do you change the default Tableau repository location?

Answer 7

File –> Repository Location (choose new location)

Question 8

What are the permitted url prefixes?

Answer 8

1. https
2. http
3. ftp

Question 9

What are the accepted image file formats?

Answer 9

JPEG, PNG, and BMP

Question 10

What are the ways to group data?

Answer 10

1. Marks
2. Labels
3. Dimensions Shelf

Question 11

What are the ways to show Mark Labels in a viz?

Answer 11

1. Analysis –> Show Mark Labels
2. Drag measure to Text in Marks
3. Click ‘Show mark labels’ in Toolbar

Question 12

What are the types of actions you can create in Tableau?

Answer 12

1. Filter
2. Highlight
3. Go to URL
4. Go to Sheet
5. Change Parameter
6. Change Set Values

Question 13

What type of file contains one or more workbooks, zero or more dashboards and stories, and no data?

Answer 13

a .twb file

Question 14

Which type of file contains one worksheet, to quickly share work?

Answer 14

a .tbm file

Question 15

Which file contains a single zip file with a workbook and all its supporting data and images?

Answer 15

a .twbx file

Question 16

Which file was formerly called .tde, and is an extract file, a copy of subsets or entire sets of data

Answer 16

a .hyper file

Question 17

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?

Answer 17

a .tds file

Question 18

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?

Answer 18

a .tdsx file

Question 19

How do you show all marks in the view at the most detailed level of granularity?

Answer 19

Disaggregate the view

Question 20

What are containers of equal size that store data values called?

Answer 20

bins

Question 21

True or False: trend lines can only be used with numeric or date fields

Answer 21

True

Question 22

Which chart type displays the shape of a distribution, grouping values of a continuous measure into ranges called bins?

Answer 22

Histogram

Question 23

Which chart type is ideal for portraying comparisons of total values across several categories?

Answer 23

Stacked Bar chart

Question 24

Which chart type is marked with extra encodings to show progress towards a goal or other reference point?

Answer 24

Bullet chart

Question 25

Which type of chart uses lines and filled areas to show how one or more groups' numeric values change over time?

Answer 25

Area chart

Question 26

What are two ways to create groups in Tableau?

Answer 26

1. Select the data in the view, click paper clip icon 2. Right-click a field in the data pane, select Create > Group

Question 27

What are the essential steps in creating a cross-tab?

Answer 27

1. Add a dimension to Rows 2. Add a dimension to Columns 3. Add a measure to Text in Marks

Question 28

What are the types of quick table calculations Tableau offers?

Answer 28

1. Running total 2. Difference 3. Percent difference 4. Percent of total 5. Rank 6. Percentile 7. Moving average 8. YTD total 9. Compound growth rate 10. Year of year growth 11. YTD growth

Question 29

How do you create a hierarchy in Tableau?

Answer 29

In the data pane, drag a field and drop it directly on top of another field

Question 30

How do you create a parameter?

Answer 30

Click the drop down arrow in the Data pane and select "Create Parameter"

Question 31

Where can you go to add Totals to a view?

Answer 31

1. Analytics pane 2. Analysis in the menu

Question 32

When can a bin be created from a dimension?

Answer 32

When the dimension is a numerical field

Question 33

What is Tableau's order of operations for filters?

Answer 33

1. Extract Filters 2. Data Source Filters 3. Context Filters (sets, conditional filters, top N, Fixed LOD) 4. Dimension Filters (Include/Exclude LOD, data blending) 5. Measure Filters (Forecasts, table calcs, clusters, totals) 6. Table Calc Filters (Trend lines, reference lines)