Desktop-Specialist Exam Dumps - Tableau Desktop Specialist Questions and Answers

Discrete measures and discrete dimensions appear blue in Tableau. Discrete fields are those that have a finite number of distinct values, such as names, categories, or dates. Discrete fields are usually used to create headers or labels in the view. Blue fields indicate that the field is discrete. Continuous measures and continuous dimensions appear green in Tableau. Continuous fields are those that have an infinite range of possible values, such as numbers or ratios. Continuous fields are usually used to create axes or color gradients in the view. Green fields indicate that the field is continuous1

Explanation

You can create a group to combine related members in a field. The icon associated with a group is a paper clip!

To create a simple scatter plot in Tableau, you need to have a measure on Columns and a measure on Rows. A scatter plot is a type of visualization that shows the relationship between two numerical variables. In Tableau, you can create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf. The measures can be continuous or discrete, but they must be aggregated. The marks in the scatter plot represent the intersection of the values for each measure1 The other options are not valid ways to create a simple scatter plot in Tableau. A dimension on Detail and a measure on Columns will create a bar chart, not a scatter plot. A dimension on Columns and a measure on Rows will create a line chart or an area chart, depending on the mark type. A dimension on Columns and a dimension on Rows will create a text table or a heat map, depending on the mark type1

Explanation

Measures contain numeric quantitative values hence that option is incorrect.

Reference 1: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm

Reference 2: https://help.tableau.com/current/pro/desktop/en-us/dates.htm

Explanation

One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0–5, 6–10, 11–15, and so on. Then you can count the number of people in each age group.

Create a calculated field for variable bin size

Step 1

Select Analysis > Create Calculated Field.

Step 2

In the Calculated Field dialog box, complete the following steps:

By default, measures placed in a view are aggregated. Mostly you'll notice that the aggregation is SUM, but not ALWAYS.

The type of aggregation applied varies depending on the context of the view.

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.

When creating a date filter in Tableau, anchor refers to the date in a relative-date filter to which you anchor a unit of time. A relative-date filter is a type of filter that allows you to dynamically filter data based on a range of time relative to the current date or a specific date. For example, you can use a relative-date filter to show data for the last 7 days, the next 3 months, or the current quarter1 To create a relative-date filter, you need to specify the following options: The date field that you want to filter. The unit of time that you want to use for the filter, such as days, weeks, months, quarters, or years. The range of time that you want to show relative to the anchor date, such as last, next, this, or to date. The anchor date that you want to use as the reference point for the filter. You can use the current date or a custom date as the anchor date1 For example, if you want to create a relative-date filter that shows data for the last 3 months from January 1st, 2022, you would select the following options: Date field: Order Date Unit of time: Months Range of time: Last 3 Anchor date: Custom (01/01/2022) 1 The other options are not valid definitions of anchor when creating a date filter in Tableau. The mid-point in the range of displayed dates is not related to the anchor date, but rather to the center of the axis that represents the date field. The date in a range-of-dates filter to which you anchor units of time is not correct, because a range-of-dates filter does not use an anchor date, but rather a start and end date that can be fixed or dynamic. The latest date in the data source that can be found is not related to the anchor date, but rather to the maximum value of the date field in the data source2

Of course! As an example, see below:

1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:

Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.

1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.

2) Now let's add subcategory to the view as well (another dimension):

Observe that the number of marks has increased - i.e the number of Bars.

Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)

Explanation

SUM is an aggregate function, not a table calculation!

A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.

The most common Table calculations are:

Running Total

Percent Difference

Difference

Percent of Total

Rank

Percentile

These can be calculated using : Table(across), Cell, or Specific dimensions!