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

To clear all sorting in a Tableau visualization, you would go to the Worksheet menu, select the "Clear" option, and then choose "Sorts." This action removes all sorting that has been applied to the visualization, including any custom sorting or sorting based on multiple fields. This is a quick way to reset the view to its default sorting state and is particularly useful when you have applied various sorting layers and wish to start fresh.

Explanation

We can drag fields from the Data pane to create the structure for your visualizations.

The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.

These FIELDS are also referred to as PILLS. See below:

For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:

However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.

In the context of Tableau, "Migrated Data" typically refers to data or workbooks that have been upgraded from a previous version of Tableau Desktop. When you open a workbook in a newer version of Tableau, the data sources within that workbook might be labeled as "Migrated Data," indicating that they have undergone a conversion process to be compatible with the new version's features and architecture.

From the official documentation:

The default view that you first see in the Data Source page canvas is the logical layer of the data source. You combine data in the logical layer using relationships (or noodles).

Explanation

Follow along:

1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.

For sales, click on the pill -> choose Quick Table calculation ->  Year over Year growth.

The view should now look like:

According to the Tableau Desktop Specialist Exam Readiness, to create a calculation that returns a customer name followed by a comma, a space, and then the customer’s age, you should use the formula [Customer Name] + “,” + STR([Age]). This is because you need to concatenate strings using the + operator, and convert the numeric field [Age] to a string using the STR() function.

THIS IS A VERY IMPORTANT QUESTION

Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.

If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.

In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect!

BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't!

An example:

Explanation

We can perform filter, URL and highlight actions out of the above given choices on a dashboard. Please refer to the image below:

Graphical user interface Description automatically generated

Explanation

Tableau Public is a free service that lets anyone publish interactive data visualizations to the web. Visualizations that have been published to Tableau Public (“vizzes”) can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users.

Check it out : https://public.tableau.com/en-us/s/