Test Prep Flashcards

1
Q

When combining data source connections what does a “relationship” mean

A

It links using the noodles related fields between the tables to create contexually-appropriate joins

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

When combining data source connections what does a “Join” mean

A

It is like the venn-Diagram, it merges tables based on a join clause to create new fixed table

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

When combining data source connections what does a “unions” mean

A

It is like stacking or combining a table, used when you have the same columns and need to add more rows

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

When combining data source connections what does a “blending” mean

A

A blending visualizes data from separate sources within the same view via blended fields

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

What is aggregation?

A

The process of summarizing a list of numbers into a single value. It can impact the way your calculations function.

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

What are the four primary ways to combine data in Tableau Desktop

A

relationships, joins, unions, blending

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

What two types of unions are available in the physical layer of Tableau Desktop’s data model?

A

specific and wildcard

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

How does a source become the primary source in a data blend in Tableau Desktop

A

The primary source is the source of the first field dragged into a view.

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

What does the tool, Data Interpreter do?

A

The data interpreter dynamically cleans poorly formatted Excel/CSV files (extra rows, merged cells, etc.).

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

____________ are always aggregated by default

A

Measures are always aggregated by default

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

Measure can never be discrete, T or F?

A

Measures are usually continuous but we can change it to discrete

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

_____________ are used to show the relationship between two continuous measures.

A

Trendlines

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

What is the order of filters in Tableau

A

Extract, Data Source, Context, Dimension, Measure, Table Calc

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

What are examples of Context filters

A

Set, conditional filters, top N, Fixed LOD

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

What are examples of Dimension filters

A

Include/Exclude LOD, data blending

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

What are examples of Measure filters

A

Forecast,Table calc, cluster,totals

17
Q

What are examples of Table Calc filters

A

Trend Lines, Reference Line

18
Q

When you make a filter that shows the top 5 of a catageory what is that grouping called?

19
Q

What are Measures in Tableau?

A

✅ Numeric values that can be measured
✅ Can be aggregated
✅ Tableau applies aggregation by default

20
Q

A relationship is most similar to which type of join?

21
Q

🔗 What are Combined Sets?

A

✅ Merges two or more sets into one
✅ Keeps all unique elements, removes duplicates
✅ Useful for data analysis and comparisons

22
Q

What is the range of R

A

R values typically range between 0 and 1

23
Q

What is a Cross-Join (Cartesian Join)?

A

✅ Combines every row from one table with every row from another
✅ Creates all possible row pairs
✅ Can result in a large dataset—use carefully!

24
Q

📁 What is a Tableau Data Extract (.tde, .hyper) file?

A

✅ Optimized, aggregated subsets of data
✅ Improves performance & easy to share
✅ Used for storing extracts in Tableau

25
Q

📁 What is a Tableau Packaged Workbook (.twbx) file?

A

✅ Contains data + visualizations
✅ Includes data sources, vizzes, calculations, formatting
✅ Ideal for sharing a complete workbook

26
Q

📁 What is a Tableau Workbook (.twb) file?

A

✅ Contains worksheets, dashboards & data connections
✅ Does NOT store data—only references it
✅ Used for creating, editing, and sharing workbooks

27
Q

📁 What is a Tableau Data Source (.tds) file?

A

✅ Stores connection info & metadata for a data source
✅ Does NOT contain actual data
✅ Useful for reusing & sharing data connections

28
Q

📁 What is a Tableau Packaged Data Source (.tdsx) file?

A

✅ Contains .tds + associated data
✅ Self-contained for easy sharing & portability
✅ Includes connection info + data used

29
Q

📁 What is a Tableau Bookmark (.tbm) file?

A

✅ Saves a specific worksheet/view
✅ Includes filters, selections, and settings
✅ Used to share & reproduce views across workbooks

30
Q

📁 What is a Tableau Preference (.tps) file?

A

✅ Stores user settings & preferences
✅ Includes custom colors, shapes, and configurations
✅ Helps migrate settings between Tableau installs