What data sources is Data Interpreter available for? And what data sources is it not available for?
It is available for CSV/Txt files and Excel files, but not database connectors.
Name each of the boxes in this image. There are 6 total
Name all the different field types in Tableau
- Number (decimal)
- Number (whole)
- Date & Time
- Date
- String
- Boolean
What are the five value operations?
- Rename
- Hide
- Group
- Pivot
- Split
What are the 5 reasons to use extracts?
- Can improve performance
- Additional functionality
- Offline access
- Supports very large datasets
- Fast to create
Explain the purpose of the five highlighted areas in the Extract Data options pane
- Filters - limit amount of data pulled into an Extract
- Aggregate - rolls up the level of granularity based on visible dimensions. Commonly used to reduce data size.
- All Rows - pulls a full data extract each time a refresh is triggered (use if historical data may change)
- Incremental Refresh - pulls in only “new” records, based on a specified date field (use when historical data doesn’t change.
- Top/Sample pulls a specific number of rows from the source.
WHat’s the difference between (a) relationships, (b) joins, ( c) blending
- a - relationships leverage related fields to create contextually appropriate joins on the fly. Optimal performance.
- b - joins merge multiple tables based on join clause to create new fixed table.
- c - blending visualizes data from separate sources within the same view. Used at the sheet-level.
Logical layer represents the canvas for creating ___ between tables.
Physical layer represents the canvas for creating ____ between tables.
Logical layer represents the canvas for creating relationships between tables.
Physical layer represents the canvas for creating unions & joins between tables.
Which layer joins tables together and which layer keeps tables separate?
Physical layer physically joins tables together.
Logical layer keeps them separate but defines relationships between them.
Which layer is this?
Logical
Which layer is this?
physical
Logical tables are _____ for “Physical” tables
containers
What are the two options when Unioning a table.
Specific (manual)
Wildcard (automatic)
Can you join a live data source with an extract data source?
No
______ are only based on the ____Source. Only _____ can be brought in from the ____Source.
Dimensions are only based on the Primary Source. Only Measures can be brought in from the Secondary Source.
Why would an asterik appear in the tooltip?
You’re trying to display multiple dimensions (not possible using blending).
