Pass the Tableau Tableau Desktop Specialist Desktop-Specialist Questions and answers with CertsForce

Explanation

In a box and whisker plot:

1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range

2) The median is marked by a vertical line inside the box

3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.

Explanation

You can add a reference line to any continuous axis in the view.

To add a reference line:

Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.

In a simple case, the drop target area offers three options:

You can use a story to present a data narrative to lead your audience to your conclusions, or to assemble a sequenced analysis to share with collaborators. A story is a sequence of visualizations that work together to convey information. You can create stories to tell a data story, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case4

Very important question for the exam and appears quite a lot too.

The correct answer is - By dragging another dimension to Color on the Marks card.

Chart, bar chart Description automatically generated

This is what the question says we have already created. Now to convert this into a Stacked bar chart, we will drop another dimension on Color in the Marks card.

Chart, bar chart Description automatically generated

The rest won't create stacked bar charts, and hence are incorrect choices. The best way to answer such questions on the real exam is to quickly do what the options say and see if they satisfy the requirements in the question.

We know that continuous fields will always create an axis, so options stating 'header' are automatically eliminated. For our question, see below:

Graphical user interface, text, application, email, Teams Description automatically generated

Had the question asked us to place this pill on the Rows shelf instead, we would've gotten a different answer:

Graphical user interface Description automatically generated with low confidence

a calculated field that has a formula of SUM(Sales)/SUM(Profit) is a measure, because it returns a numeric value that can be aggregated and used for analysis. A parameter is a user-defined variable that can be used in calculations or filters. A dimension is a categorical field that can be used to group or slice data. A set is a subset of data based on some condition.

Explanation

Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:

We are using BOTH the Sum of the revenue and the AVG of the revenue in the same view!

Two correct methods for creating a visual group are selecting marks in the view and right-clicking a dimension in the Data pane. A visual group is a way of combining related members in a dimension field to create categories or segments in your data. For example, you can create a visual group by selecting several states in a map view and grouping them into regions. You can create a visual group by selecting one or more marks in the view and then clicking the group icon on the tooltip or on the toolbar. This will create a new group field in the Data pane with default names for each group based on their members. You can also create a visual group by right-clicking a dimension in the Data pane and selecting Create > Group. This will open the Create Group dialog box where you can select several members and drag them into groups with custom names8 The other options are not correct methods for creating a visual group. Clicking the drop-down arrow from the top of the Data pane will open a menu with options for creating new fields, folders, sets, bins, etc., but not groups. Dragging a dimension onto another dimension in the Data pane will create a hierarchy, which is a way of organizing data into different levels of detail, not groups9

 A dual axis chart is useful for comparing two measures that have different scales. A dual axis chart is a type of visualization that shows two measures using two independent axes layered on top of one another. A dual axis chart allows you to compare and contrast two measures that have different ranges or units of measurement, such as sales and profit margin, temperature and precipitation, or population and GDP per capita. A dual axis chart can also show different mark types for each measure, such as bars and lines, circles and areas, or shapes and texts. The other options are not valid reasons for using a dual axis chart for comparing two measures. Have little in common is not correct, because a dual axis chart is meant to show some kind of relationship or correlation between two measures, not just contrast them. Are Table Calculations is not correct, because a dual axis chart can be used with any type of measure, whether it is an aggregation, a calculation, or an expression. Are aggregated Dimensions is not correct, because a dual axis chart cannot be used with dimensions, only with measures. Dimensions are fields that contain qualitative values that are used to categorize or segment data, not compare them.

Explanation

Not too tough. Follow along the steps:

Drag Color to Filter and choose Red:

3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:

And your final view will look like :