Section 4: Connecting to Data

Question 1

What data sources is Data Interpreter available for? And what data sources is it not available for?

Answer 1

It is available for CSV/Txt files and Excel files, but not database connectors.

Question 2

Name each of the boxes in this image. There are 6 total

Answer 2

Question 3

Name all the different field types in Tableau

Answer 3

1. Number (decimal)
2. Number (whole)
3. Date & Time
4. Date
5. String
6. Boolean

Question 4

What are the five value operations?

Answer 4

1. Rename
2. Hide
3. Group
4. Pivot
5. Split

Question 5

What are the 5 reasons to use extracts?

Answer 5

1. Can improve performance
2. Additional functionality
3. Offline access
4. Supports very large datasets
5. Fast to create

Question 6

Explain the purpose of the five highlighted areas in the Extract Data options pane

Answer 6

1. Filters - limit amount of data pulled into an Extract
2. Aggregate - rolls up the level of granularity based on visible dimensions. Commonly used to reduce data size.
3. All Rows - pulls a full data extract each time a refresh is triggered (use if historical data may change)
4. Incremental Refresh - pulls in only “new” records, based on a specified date field (use when historical data doesn’t change.
5. Top/Sample pulls a specific number of rows from the source.

Question 7

WHat’s the difference between (a) relationships, (b) joins, ( c) blending

Answer 7

• 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.

Question 8

Logical layer represents the canvas for creating ___ between tables.

Physical layer represents the canvas for creating ____ between tables.

Answer 8

Logical layer represents the canvas for creating relationships between tables.

Physical layer represents the canvas for creating unions & joins between tables.

Question 9

Which layer joins tables together and which layer keeps tables separate?

Answer 9

Physical layer physically joins tables together.

Logical layer keeps them separate but defines relationships between them.

Question 10

Which layer is this?

Answer 10

Logical

Question 11

Which layer is this?

Answer 11

physical

Question 12

Logical tables are _____ for “Physical” tables

Answer 12

containers

Question 13

What are the two options when Unioning a table.

Answer 13

Specific (manual)

Wildcard (automatic)

Question 14

Can you join a live data source with an extract data source?

Answer 14

No

Question 15

______ are only based on the ____Source. Only _____ can be brought in from the ____Source.

Answer 15

Dimensions are only based on the Primary Source. Only Measures can be brought in from the Secondary Source.

Question 16

Why would an asterik appear in the tooltip?

Answer 16

You’re trying to display multiple dimensions (not possible using blending).