Tableau Desktop Specialist Questions and Answers
2022/2023 with complete solution
What can you edit from the manage metadata screen
data type and field name
what is stored in the .tds file
data connection information
renamed dimensions and measures
folders created to organize dimensions and measures
when your data is stored in tables from different databases, what method allows
you to combine the data into a single viz?
a data blend or a cross-database join
what is useful when you want to join data but the database you're using doesn't
allow joins?
a blend
what is useful when combining two tables that have the same fields (columns)
but different rows of data?
a union
on the data source page, we add a cross-database join by:
clicking "Add" next to the word connections
what requires a primary data source and at least one secondary data source
a blend
data blending
the order in which the fields are used determines which source is primary and
secondary
data blending behaves similarly to a left join which may result in missing data
data from secondary sources must always be aggregated calculations
you can ______ for members in a dimension so that their labels appear differently
in the view
create aliases
shapes
available for dimensions but not measures
if your scatter plot only has one mark, you can break this down into multiple
marks by:
dragging a dimension to color
if you use two measures in a line chart, Desktop may turn those into two separate
line charts. to merge those into one line chart with one measure on the left Y-axis
and the other measure on the right Y-axis:
right click the pill of the second measure and select Dual Axis
a single chart that shows multiple measures using multiple mark types is a
combination chart
to turn a bar chart into a stacked bar chart
drag a dimension to color
how do you create a highlight table
, by placing one or more dimensions on the columns shelf and one or more dimensions
on the rows shelf, selecting the Square as the mark type, and placing the measure of
interest on the color shelf
to create a visual group where the grouped dimension is automatically added to
the Colors shelf, create the group
using the dimension marks
when creating a group, which of the following methods automatically replaces the
original dimension with the grouped dimension in the view
using the dimension labels
what is true about sets
the members of a set can change dynamically when the underlying data changes
the members of a set can be fixed
sets appear at the bottom of the data pane
sets can display In/Out membership of the set
right-click to show the individual members included
sets can be combined with other sets
to create a custom hierarchy correctly for eventual drill down purposes, in the
Data pane:
drag the more granular (detailed) dimension onto the more aggregated (less detailed)
dimension
this type of categorical filter can be thought of as an independent filter that
narrows down the data before other dependent filters are applied. it improves
performance and can be applied from the context menu of an existing categorical
filter
context filter
this filter field dialog box options pays attention to today's data in calculating
how far back to filter. for example, it enables us to filter our workbook to show the
most recent seven days of data
relative
from left to right, your crosstab has the columns Year, Region, and Sum(Sales).
You sort based on Sum(Sales). this causes the Years to remain in chronological
order but causes the Regions to appear in a different order within each Year. This
means that ______ sorting has been applied
Nested
bullet graph
variation of a bar graph that shows whether the measure represented by the bar
reaches a target value line
trend lines can be added to a worksheet viz from the:
view, analytics pan, analysis menu
the option to add table calculations can be found when
right clicking on a measure
for table calculations, what is NOT a valid option for Compute Using?
-Table (across)
-Pane (down)
-Cell (down)
-Specific Dimensions
2022/2023 with complete solution
What can you edit from the manage metadata screen
data type and field name
what is stored in the .tds file
data connection information
renamed dimensions and measures
folders created to organize dimensions and measures
when your data is stored in tables from different databases, what method allows
you to combine the data into a single viz?
a data blend or a cross-database join
what is useful when you want to join data but the database you're using doesn't
allow joins?
a blend
what is useful when combining two tables that have the same fields (columns)
but different rows of data?
a union
on the data source page, we add a cross-database join by:
clicking "Add" next to the word connections
what requires a primary data source and at least one secondary data source
a blend
data blending
the order in which the fields are used determines which source is primary and
secondary
data blending behaves similarly to a left join which may result in missing data
data from secondary sources must always be aggregated calculations
you can ______ for members in a dimension so that their labels appear differently
in the view
create aliases
shapes
available for dimensions but not measures
if your scatter plot only has one mark, you can break this down into multiple
marks by:
dragging a dimension to color
if you use two measures in a line chart, Desktop may turn those into two separate
line charts. to merge those into one line chart with one measure on the left Y-axis
and the other measure on the right Y-axis:
right click the pill of the second measure and select Dual Axis
a single chart that shows multiple measures using multiple mark types is a
combination chart
to turn a bar chart into a stacked bar chart
drag a dimension to color
how do you create a highlight table
, by placing one or more dimensions on the columns shelf and one or more dimensions
on the rows shelf, selecting the Square as the mark type, and placing the measure of
interest on the color shelf
to create a visual group where the grouped dimension is automatically added to
the Colors shelf, create the group
using the dimension marks
when creating a group, which of the following methods automatically replaces the
original dimension with the grouped dimension in the view
using the dimension labels
what is true about sets
the members of a set can change dynamically when the underlying data changes
the members of a set can be fixed
sets appear at the bottom of the data pane
sets can display In/Out membership of the set
right-click to show the individual members included
sets can be combined with other sets
to create a custom hierarchy correctly for eventual drill down purposes, in the
Data pane:
drag the more granular (detailed) dimension onto the more aggregated (less detailed)
dimension
this type of categorical filter can be thought of as an independent filter that
narrows down the data before other dependent filters are applied. it improves
performance and can be applied from the context menu of an existing categorical
filter
context filter
this filter field dialog box options pays attention to today's data in calculating
how far back to filter. for example, it enables us to filter our workbook to show the
most recent seven days of data
relative
from left to right, your crosstab has the columns Year, Region, and Sum(Sales).
You sort based on Sum(Sales). this causes the Years to remain in chronological
order but causes the Regions to appear in a different order within each Year. This
means that ______ sorting has been applied
Nested
bullet graph
variation of a bar graph that shows whether the measure represented by the bar
reaches a target value line
trend lines can be added to a worksheet viz from the:
view, analytics pan, analysis menu
the option to add table calculations can be found when
right clicking on a measure
for table calculations, what is NOT a valid option for Compute Using?
-Table (across)
-Pane (down)
-Cell (down)
-Specific Dimensions
