Tableau Desktop-Specialist - Tableau Desktop Specialist Exam

In Tableau, a Fixed Level of Detail (LOD) expression calculates values at a specific level of granularity, regardless of the dimensions in the view. The computation of a fixed LOD expression can be influenced by a context filter. A context filter serves as a primary filter, setting the context for the rest of the filters in the view. When a context filter is applied, it effectively changes the level at which the fixed LOD expression is computed, thereby affecting its outcome. Other types of filters, such as table calculation, measure, and dimension filters, do not have this influence on fixed LOD expressions.

According to the Tableau Help, a highlight table is “a cross-tabulation that uses color to encode values”. The help also states that “Highlight tables use the Square mark type” (page 1).

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 :

Explanation

The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server.

These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.

Explanation

If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.

To reach the correct answer, follow the steps below:

1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!

Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!

The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

Explanation

To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.

For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.

Explanation

A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.

Explanation

For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:

When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.

When creating a group by selecting headers in a Tableau view, the newly created grouped dimension replaces the original dimension field on either the Rows or Columns shelf. This grouping action aggregates the selected headers into a single group, and this new group dimension is automatically placed in the view, replacing the original dimension. This functionality allows for more simplified and customized categorization within the data visualization, enhancing the ability to analyze and interpret data according to specific groupings.

The relative date filter can be used to select a range of dates relative to the current date, such as the past month, the current quarter, etc. This filter type dynamically adjusts the range based on the current system date, making it suitable for use with the TODAY() function.