TABLEAU EXAM QUESTIONS AND
ANSWERS
What are the three different Tableau file types? Explain each one - Correct Answers -
1. .twb - You can only see the visualizations; cannot manipulate the data
2. .tbwx - This will include the data and allows for changes to be made
3. .tds - The mapping file in Tableau
What are the two kinds of connections? - Correct Answers -1. Live
2. Extract
What are the differences between the live and extract connections? - Correct Answers -
Live is slower, but if you make a change to the excel sheet it will be reflected in Tableau
Extract is quicker but it turns the original file into Tableau format
What are measures? Dimensions? - Correct Answers -Measures - Numerical, usually
the data we're looking for
Dimensions - Text-based, what we care about (what we want to "slice and dice")
What is the difference between data joining and data blending? - Correct Answers -Data
joining - It links two different tables in Tableau; can only be done on the same data
source (multiple tables in an excel file)
Data blending - Connecting multiple data sources by finding common fields between
them to join
How do you create a calculated field? What are some things to know about
calculations? - Correct Answers -You right click on either the measures or dimensions
tab OR Analysis tab -> Create calculated field
They are very specific - you want to always select the function that Tableau prompts
you to use
How do you build a parameter? - Correct Answers -1. Create parameter (right click
measures/dimensions)
2. Show parameter
3. Build parameter
ANSWERS
What are the three different Tableau file types? Explain each one - Correct Answers -
1. .twb - You can only see the visualizations; cannot manipulate the data
2. .tbwx - This will include the data and allows for changes to be made
3. .tds - The mapping file in Tableau
What are the two kinds of connections? - Correct Answers -1. Live
2. Extract
What are the differences between the live and extract connections? - Correct Answers -
Live is slower, but if you make a change to the excel sheet it will be reflected in Tableau
Extract is quicker but it turns the original file into Tableau format
What are measures? Dimensions? - Correct Answers -Measures - Numerical, usually
the data we're looking for
Dimensions - Text-based, what we care about (what we want to "slice and dice")
What is the difference between data joining and data blending? - Correct Answers -Data
joining - It links two different tables in Tableau; can only be done on the same data
source (multiple tables in an excel file)
Data blending - Connecting multiple data sources by finding common fields between
them to join
How do you create a calculated field? What are some things to know about
calculations? - Correct Answers -You right click on either the measures or dimensions
tab OR Analysis tab -> Create calculated field
They are very specific - you want to always select the function that Tableau prompts
you to use
How do you build a parameter? - Correct Answers -1. Create parameter (right click
measures/dimensions)
2. Show parameter
3. Build parameter
