Tableau Order of Operation Flashcards

Memorize Order

1
Q

Extract Filter

A
# 1    Located on the Data Source Page (Extract or Live)
Licensed Tableau -> Change the connection from Live to Extract under the Connection section, and click on the "Edit" button Next to the word Extract.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data Source Filter

A
# 2  On the Worksheet, Upper Left Click word "Add"
Right Click, See Edit Data Source Filter.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Context Filter

A

3 Worksheet, part of the quick filters
Drag Dimension To Filter, Click Down Arrow,
Click Add to Context.

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

Sets, Conditional & Top N Filters, FIXED LOD expressions

A

4 Order of Operation (calculated)

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

Dimension Filter

A

5 Drag & Drop a Dimension to Worksheet Page Filter Shelf. A new window called Filter will be opened allowing you to select several different filter options.

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

Data Blending

A

6 Used when there is related data in multiple data sources, which you want to analyze together in a single view. As an example, consider the Sales data is present in a relational database and Sales Target data in an Excel spreadsheet.

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

Include & Exclude Level of Detail Expressions

A

7 Used to obtain values for dimensions that are not directly used in a visualization (calculated)

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

Measure Filters

A
# 8   Now if you apply a filter on measure field it will give you following options:
A slider for range of values you want to show. Example:- Which regions have total sales between 5000 to 10000?
At least option specifies at least measure should have provided values and above that. At most option specify the upper limit on measure field.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Totals

A

9 Calculated Totals

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

Forecasts & Table Calculations

A

10 Calculated

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

Trend Lines, Reference Lines

A

11 Calculated

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