Desktop Specialist Flashcards

Earn Tableau Desktop Certification

1
Q

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

A

32

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the fields Tableau auto-generates?

A
  1. Measure names (Dimension)
  2. Latitude (Measure)
  3. Longitude (Measure)
  4. # of Records (Measure)
  5. Measure Values (Measure)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the default path for all supporting files?

A

Documents –> My Tableau Repository

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the methods for combining data tables?

A
  1. Relationships
  2. Joins
  3. Unions
  4. Blends
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the default duration for animations?

A

0.3 seconds

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How many rows will View Data display by default?

A

10,000 rows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How do you change the default Tableau repository location?

A

File –> Repository Location (choose new location)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are the permitted url prefixes?

A
  1. https
  2. http
  3. ftp
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the accepted image file formats?

A

JPEG, PNG, and BMP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the ways to group data?

A
  1. Marks
  2. Labels
  3. Dimensions Shelf
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A
  1. Analysis –> Show Mark Labels
  2. Drag measure to Text in Marks
  3. Click ‘Show mark labels’ in Toolbar
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A
  1. Filter
  2. Highlight
  3. Go to URL
  4. Go to Sheet
  5. Change Parameter
  6. Change Set Values
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

a .twb file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

a .tbm file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

a .twbx file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

a .hyper file

17
Q

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

a .tds file

18
Q

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

a .tdsx file

19
Q

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

A

Disaggregate the view

20
Q

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

A

bins

21
Q

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

A

True

22
Q

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

A

Histogram

23
Q

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

A

Stacked Bar chart

24
Q

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

A

Bullet chart

25
Q

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

A

Area chart

26
Q

What are two ways to create groups in Tableau?

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

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

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

What are the types of quick table calculations Tableau offers?

A
  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
29
Q

How do you create a hierarchy in Tableau?

A

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

30
Q

How do you create a parameter?

A

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

31
Q

Where can you go to add Totals to a view?

A
  1. Analytics pane
  2. Analysis in the menu
32
Q

When can a bin be created from a dimension?

A

When the dimension is a numerical field

33
Q

What is Tableau’s order of operations for filters?

A
  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)