Test Prep Flashcards
When combining data source connections what does a “relationship” mean
It links using the noodles related fields between the tables to create contexually-appropriate joins
When combining data source connections what does a “Join” mean
It is like the venn-Diagram, it merges tables based on a join clause to create new fixed table
When combining data source connections what does a “unions” mean
It is like stacking or combining a table, used when you have the same columns and need to add more rows
When combining data source connections what does a “blending” mean
A blending visualizes data from separate sources within the same view via blended fields
What is aggregation?
The process of summarizing a list of numbers into a single value. It can impact the way your calculations function.
What are the four primary ways to combine data in Tableau Desktop
relationships, joins, unions, blending
What two types of unions are available in the physical layer of Tableau Desktop’s data model?
specific and wildcard
How does a source become the primary source in a data blend in Tableau Desktop
The primary source is the source of the first field dragged into a view.
What does the tool, Data Interpreter do?
The data interpreter dynamically cleans poorly formatted Excel/CSV files (extra rows, merged cells, etc.).
____________ are always aggregated by default
Measures are always aggregated by default
Measure can never be discrete, T or F?
Measures are usually continuous but we can change it to discrete
_____________ are used to show the relationship between two continuous measures.
Trendlines
What is the order of filters in Tableau
Extract, Data Source, Context, Dimension, Measure, Table Calc
What are examples of Context filters
Set, conditional filters, top N, Fixed LOD
What are examples of Dimension filters
Include/Exclude LOD, data blending
What are examples of Measure filters
Forecast,Table calc, cluster,totals
What are examples of Table Calc filters
Trend Lines, Reference Line
When you make a filter that shows the top 5 of a catageory what is that grouping called?
a Set
What are Measures in Tableau?
✅ Numeric values that can be measured
✅ Can be aggregated
✅ Tableau applies aggregation by default
A relationship is most similar to which type of join?
Outer
🔗 What are Combined Sets?
✅ Merges two or more sets into one
✅ Keeps all unique elements, removes duplicates
✅ Useful for data analysis and comparisons
What is the range of R
R values typically range between 0 and 1
What is a Cross-Join (Cartesian Join)?
✅ Combines every row from one table with every row from another
✅ Creates all possible row pairs
✅ Can result in a large dataset—use carefully!
📁 What is a Tableau Data Extract (.tde, .hyper) file?
✅ Optimized, aggregated subsets of data
✅ Improves performance & easy to share
✅ Used for storing extracts in Tableau
📁 What is a Tableau Packaged Workbook (.twbx) file?
✅ Contains data + visualizations
✅ Includes data sources, vizzes, calculations, formatting
✅ Ideal for sharing a complete workbook
📁 What is a Tableau Workbook (.twb) file?
✅ Contains worksheets, dashboards & data connections
✅ Does NOT store data—only references it
✅ Used for creating, editing, and sharing workbooks
📁 What is a Tableau Data Source (.tds) file?
✅ Stores connection info & metadata for a data source
✅ Does NOT contain actual data
✅ Useful for reusing & sharing data connections
📁 What is a Tableau Packaged Data Source (.tdsx) file?
✅ Contains .tds + associated data
✅ Self-contained for easy sharing & portability
✅ Includes connection info + data used
📁 What is a Tableau Bookmark (.tbm) file?
✅ Saves a specific worksheet/view
✅ Includes filters, selections, and settings
✅ Used to share & reproduce views across workbooks
📁 What is a Tableau Preference (.tps) file?
✅ Stores user settings & preferences
✅ Includes custom colors, shapes, and configurations
✅ Helps migrate settings between Tableau installs