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

When users connect to Tableau, the data fields in their data set are automatically assigned a role and a type.

Role can be of the following two types:

1) Dimension

2) Measure

Type can be of the following :

1) String

2) Number

3) Geographic

4) Boolean

5) Date

6) Date and Time

To access bolding options for the text in a tooltip in Tableau, you can:

Select Tooltip on the Marks card, which allows you to edit the tooltip for the specific marks.

Select Worksheet on the menu, and then Tooltip, to open the tooltip editor for the worksheet.

Right-click on the Field and select Format, which lets you format the text including bolding options in the tooltip.

According to the official Tableau documentation:

Dimensions don't have aggregation properties, and adding properties manually each time defeats the whole DEFAULT aggregation purpose. Window tab doesn't have any default aggregation option!

The LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well!

NOTE: Animations are DISABLED by default and must be manually enabled.

You can also reset all settings to default by clickin on 'Reset All'

Explanation

Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one.

1) Firstly, let's drag Country and Institution to the Rows shelf, and year (discrete) to the Columns shelf. Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view:

In Tableau, a Density map (also known as a heat map) uses automatically generated sizes for the data points that cannot be resized by using the Marks card. This chart type is designed to display density of data points on a map, where the size and color of the data points represent the concentration of data in that area.

The Shape option is available for scatter plots and packed bubbles views. The Shape option allows you to change the shape of marks in the view by selecting from a predefined set of shapes or adding custom shapes. You can access the Shape option by placing any field on Shape on the Marks card4 Scatter plots are views that show the relationship between two numerical variables by plotting them as coordinates on a Cartesian plane. You can create a scatter plot by placing at least one measure on Columns and at least one measure on Rows on the Marks card. You can then use Shape to assign different shapes to different categories or segments in your data5 Packed bubbles are views that show hierarchical data as a set of nested circles. Each circle represents a dimension member and its size is proportional to a measure value. You can create a packed bubble chart by placing one or more dimensions on Detail and one measure on Size on the Marks card. You can then use Shape to change the shape of circles to other shapes such as squares or stars6 The other options are not valid views for using the Shape option. Side-by-side circles are views that show proportions of a whole by using circles with different angles and sizes arranged horizontally or vertically. You can create a side-by-side circle chart by placing one dimension on Columns or Rows and one measure on Angle and Size on the Marks card. You cannot use Shape to change the shape of circles in this view7 Heat maps are views that show the distribution of two or more measures by using a color gradient and size. You can create a heat map by placing one or more dimensions on Columns and Rows and two measures on Color and Size on the Marks card. You cannot use Shape to change the shape of marks in this view8

You should use a relationship instead of a join for two data sets when the data sets include similar data aggregated at different levels of detail. A relationship is a way of combining data from different tables based on common fields without creating a single table with all fields. A relationship allows you to query data from multiple tables as needed and preserve the level of detail of each table. A relationship is useful when you have data sets that are aggregated at different levels of detail, such as sales by region and sales by product. A relationship can match data from different levels of detail without creating null values or duplicate rows. The other options are not valid situations for using a relationship instead of a join for two data sets. The data sets include similar data aggregated up to the highest level is not correct, because a relationship is not needed when both data sets have the same level of detail. You can use either a relationship or a join in this case, depending on your preference and performance. The data sets are in two separate tables within a single spreadsheet is not correct, because a relationship is not limited by the location or format of the data sets. You can use a relationship to combine data from different sources or connections, such as databases, files, or web services. To use both data sets across multiple sheets in a visualization is not correct, because a relationship does not affect how you use data in your visualization. You can use either a relationship or a join to create multiple sheets and dashboards with your data sets.

To make an axis bold, simply right click it, select format, and then click on Font to choose Bold:

None of the other options are valid ways to make the axis bold.

Read more about editing axis: https://help.tableau.com/current/pro/desktop/en-us/formatting_editaxes.htm

Explanation

By default, all of the above mentioned are stored in Documents -> My Tableau Repository