Tableau Desktop Specialist
Questions with complete
solutions
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
Questions with complete
solutions
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
