TABLEAU DESKTOP SPECIALIST STUDY LATEST
GUIDE QUESTIONS AND ANSWERS SURE A+
✔✔Describe how an aggregated measure changes when dimensions are added to the
view - ✔✔the level of detail changes when a dimension is added, so the aggregation will
change
✔✔What do you need to create a scatter plot? - ✔✔at least two continuous measures
✔✔What do you need to create a histogram? - ✔✔one continuous measure
✔✔What do you need to create a text table/cross tab/cross table/pivot table? - ✔✔one
discrete dimension and one continuous measure
✔✔Measure - ✔✔contain numeric, quantitative values that you can measure. Measures
can be aggregated. When you drag a measure into the view, Tableau applies an
aggregation to that measure (by default).
✔✔Dimension - ✔✔contain qualitative values (such as names, dates, or geographical
data). You can use dimensions to categorize, segment, and reveal the details in your
data. Dimensions affect the level of detail in the view. Only exception is when the
column ends in "ID"
, ✔✔Discrete Field - ✔✔individually separate
This will show as a blue pull.
✔✔Continuous Field - ✔✔forming an unbroken whole, without interruption. This will
show as a green pill.
✔✔What are italic fields in Tableau? - ✔✔These are automatically created by Tableau
✔✔Marks - ✔✔these are the data points you have in your current view.
✔✔What are the differences between .twb and .twbx - ✔✔.twb = without data
.twbx = with data
✔✔How is the filtering different for discrete and continuous fields? - ✔✔discrete are
filtered individually while continuous is filtered as a range (continuous measures will ask
you to define the aggregation)
✔✔What do discrete and continuous fields add to the view? - ✔✔discrete will add the
header to the view
continuous will add axes to the view
✔✔What do discrete and continuous fields "bring" - ✔✔discrete brings a level of detail
continuous brings and aggregated number
✔✔Most of the time what will measure and dimension values be categorized as? -
✔✔measure = continuous
dimension = discrete
*note* - it can also go the other way
✔✔Which data types can NOT be continuous? - ✔✔string and boolean
✔✔Granularity - ✔✔level of detail
✔✔Do you use dimensions or measures to bring the level of detail in your data? -
✔✔dimensions
✔✔What is the default connection type? - ✔✔live
✔✔How do you refresh an extract? - ✔✔Right click on data source
Go to extract
Refresh extract
GUIDE QUESTIONS AND ANSWERS SURE A+
✔✔Describe how an aggregated measure changes when dimensions are added to the
view - ✔✔the level of detail changes when a dimension is added, so the aggregation will
change
✔✔What do you need to create a scatter plot? - ✔✔at least two continuous measures
✔✔What do you need to create a histogram? - ✔✔one continuous measure
✔✔What do you need to create a text table/cross tab/cross table/pivot table? - ✔✔one
discrete dimension and one continuous measure
✔✔Measure - ✔✔contain numeric, quantitative values that you can measure. Measures
can be aggregated. When you drag a measure into the view, Tableau applies an
aggregation to that measure (by default).
✔✔Dimension - ✔✔contain qualitative values (such as names, dates, or geographical
data). You can use dimensions to categorize, segment, and reveal the details in your
data. Dimensions affect the level of detail in the view. Only exception is when the
column ends in "ID"
, ✔✔Discrete Field - ✔✔individually separate
This will show as a blue pull.
✔✔Continuous Field - ✔✔forming an unbroken whole, without interruption. This will
show as a green pill.
✔✔What are italic fields in Tableau? - ✔✔These are automatically created by Tableau
✔✔Marks - ✔✔these are the data points you have in your current view.
✔✔What are the differences between .twb and .twbx - ✔✔.twb = without data
.twbx = with data
✔✔How is the filtering different for discrete and continuous fields? - ✔✔discrete are
filtered individually while continuous is filtered as a range (continuous measures will ask
you to define the aggregation)
✔✔What do discrete and continuous fields add to the view? - ✔✔discrete will add the
header to the view
continuous will add axes to the view
✔✔What do discrete and continuous fields "bring" - ✔✔discrete brings a level of detail
continuous brings and aggregated number
✔✔Most of the time what will measure and dimension values be categorized as? -
✔✔measure = continuous
dimension = discrete
*note* - it can also go the other way
✔✔Which data types can NOT be continuous? - ✔✔string and boolean
✔✔Granularity - ✔✔level of detail
✔✔Do you use dimensions or measures to bring the level of detail in your data? -
✔✔dimensions
✔✔What is the default connection type? - ✔✔live
✔✔How do you refresh an extract? - ✔✔Right click on data source
Go to extract
Refresh extract
