Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Tableau > Desktop Specialist Review 1 > Flashcards

Desktop Specialist Review 1 Flashcards

1
Q

What is Tableau’s order of operations for filters?

A
  1. Extract Filters
  2. Data Source Filters
  3. Context Filters
  4. Dimension Filters
  5. Measure Filters
  6. Table Calc Filters
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What types of information does Tableau list as necessary for connecting to a data source, and therefore is included in a .tds file?

A
  1. Data source type
  2. Connection information such as server address, port, location of local files, tables
  3. Groups, sets, calculated fields, bins
  4. Default field properties such as number formats, aggregation, and sort order
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

True or false: it is possible to blend axes for multiple measures into a single axis

A

True, this creates a comined-axis/blended-axis chart.

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

What is the minimum field requirement to create a bullet chart?

A

Two measures

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

What are the basic building blocks of a histogram?

A
  1. Mark type: automatic
  2. One continuous measure, aggregated by Count or Count Distinct
  3. Bin, continuous or discrete, created from the continuous measure, on the rows shelf
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

When can a bin be created on a dimension?

A

When the dimension is numerical

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

What are the ways you can create groups in Tableau?

A
  1. Select marks in the view
  2. Select labels in the view
  3. Select fields from the dimensions shelf
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

If you create a group by selecting marks, what will happen?

A

The marks will remain distinct, but will be grouped by color.

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

If you create a group by selecting the labels, what will happen?

A

The selected (grouped) marks will be consolidated into one mark.

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

If you create a group by selecting fields in the dimensions shelf, what will happen?

A

A new dimension will be created.

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

What are the ways you can show Mark Labels in the viz?

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

What is the one critical difference between normal calculated fields and the calculated fields created after data blending?

A

Fields used in Blends must first be aggregated

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

What type of file does Tableau recognize a CSV file as?

A

a Text file

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

Data blending simulates a traditional _____ join.

A

Left

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

What is the best way to change the formatting at a workbook level?

A

Format in Menu bar –> specify formatting the new Format workbook pane

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

How can you format an axis as Bold in Tableau?

A

Right click the axis –> format –> set font to Bold

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

How can you gain the ability to use one sheet as a filter for another?

A

Combine the sheets using dashboards

18
Q

How do you add a reference line to the view?

A

Assuming you have a continuous axis…

Analytics pane –> Drag ‘Reference Line’ into view and place on one of the destinations that appears

19
Q

What are the ways we can trigger actions in a Dashboard?

A
  1. Select
  2. Hover
  3. Menu
20
Q

When using a Blend, what is the color of the tick-mark on the primary and secondary data sources respectively?

A

Blue, Orange

21
Q

What are the 5 types of trend lines available in Tableau?

A
  1. Linear
  2. Logarithmic
  3. Exponential
  4. Polynomial
  5. Power Model
22
Q

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

A Web-Page object

23
Q

What data combination method in Tableau is the best way to avoid duplicate rows?

A

relationships

24
Q

Name the free desktop application that you can use to open and interact with data visualizations built in Tableau and shared locally

A

Tableau Reader

25
Q

Where can one open a Tableau Support case?

A

Tableau website –> support option

26
Q

What icon represents a grouped field?

A

paperclip

27
Q

What feature helps to fix fields that have different names (indicated by an exclamation point) when you connect to a new data source?

A

Replace References

28
Q

True or False: Sets can be created on Measures

A

False

29
Q

True or False: To concatenate fields, they must be of same data type

A

True, but we can use Type Casting to convert fields to other types as a workaround

30
Q

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?

A

Pareto chart

31
Q

How can you manually assign geographic roles to a dimension from the data pane?

A

Right click the dimension –> Geographic role –> assign role

32
Q

True or False: It is possible to change the Geographic Role of a dimension

A

True

33
Q

For a relative date filter, the default anchor is _________________

A

Today’s date

34
Q

True or False: Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.

A

True

35
Q

You can use the __________________ in Tableau to clean / organize your data.

A

Data interpreter

36
Q

Which of the following is the correct way to calculate Profit Ratio in Tableau?

A

SUM([Profit]) / SUM([Sales])

37
Q

What view includes the sections ‘Summarize’, ‘Model’, and ‘Custom’?

A

the Analytics Pane

38
Q

__________ is a technique in Tableau which will identify marks with similar characteristics

A

Clustering

39
Q

True or False:
Animations work well with maps, polygons, and density marks in web browsers

A

False

40
Q

What type of chart is ideal for showing the duration of events or activities?

A

A Gantt chart

Tableau (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions