Desktop-Specialist Exam Dumps - Tableau Desktop Specialist Exam

To create a stacked bar chart in Tableau, you can drag a second dimension to the Color shelf on the Marks card. This action will segment the bars already present in the chart by the new dimension, stacking the segments on top of each other within each bar. This is a common method to add additional layers of detail to a bar chart and effectively compare parts to a whole across categories.

Explanation

By default, measures placed in a view are aggregated by SUM, which means that the data for that field in all of the rows is combined. Measures can also be aggregated as average, median, count, or count distinct.

Explanation

For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.

From the official website:

Explanation

It is possible in Tableau to use a sheet within a story directly.

Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.

At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.

The Marks Card allows us not only to edit the Shape, Text and Colour, but also to modify the Tooltip and the level of detail of the visualisation!

The Marks card is a key element for visual analysis in Tableau. As you drag fields to different properties in the Marks card, you add context and detail to the marks in the view.

You use the Marks card to set the mark type (see Change the Type of Mark in the View), and to encode your data with color, size, shape, text, and detail. To change the mark settings, see Control the Appearance of Marks in the View.

In this example, three different fields have been dragged to different properties in the Marks card. Segment is on Color, Region is on Shape, and Quantity is on Size.

After you add a field to the Marks card, you can click the icon next to the field to change the property it is using. You can also click the property buttons in the Marks card to change those settings.

Many properties can have multiple fields. For example, you can add multiple fields to Label, Detail, Tooltip, and Color. Size and Shape can only have one field at a time. For more details, see Control the Appearance of Marks in the View.

According to the Tableau Desktop Specialist Exam Readiness, a line chart will be created whenever you place measures on one shelf, and a date dimension on the other. This is because Tableau automatically recognizes date fields and treats them as continuous dimensions.

Explanation

The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.

For example, consider the following two tables originating from a single data source:

We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis.

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!

The Tableau workspace consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets. Sheets can be worksheets, dashboards, or stories. For details on dashboard or story workspaces, see Create a Dashboard or The Story Workspace.

Graphical user interface, application Description automatically generated

The main thing you do in the workspace is to create visualisations to analyze your data.

Renaming data fields, cleaning the data, previewing the data can all be done in the Data source window.

Explanation

Follow along the steps below:

• Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below:

Date values in Tableau represent specific points in time and are typically formatted in a standard date format.

• Option A, "2020-05-01", is a standard date format representing the 1st of May, 2020.
• Option D, "January 1, 1995", is another example of a date value, representing the 1st of January, 1995. Options B ("December") and C ("Wednesday") represent a month and a day of the week, respectively, but do not specify a particular date.

Explanation

If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!

To create a dual axis chart for the problem mentioned:

1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:

3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Now the chart looks like this:

Now we change the Profit chart type to line:

5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

And, our final view and answer is:

According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:

This is a tricky question often asked in the exam.

If we drag a new measure to the row shelf, the following happens:

We now have 2 rows, and the same 7 columns for both these rows. Therefore, 2x7 = 14 marks!

Graphical user interface, chart, bar chart Description automatically generated with medium confidence

But if we drag the same measure to the column shelf, we have just 1 row and a chart created for each of the columns. So (1x7) = 7 marks!

Graphical user interface, text, application Description automatically generated

Reference and notes: https://medium.com/@justindixon91/tableau-specialist-exam-notes-part-4-understanding-tableau-concepts-f78de83fdd35

Distribution Pane

Explanation

This is the Analytics pane! Read more from the official documentation below:

You should use a union when you have two tables with similarly named columns of data that you want to combine. A union is a method for combining data by appending rows of one table onto another table. The tables that you union must have the same number of fields, the same field names, and the same data types2

Explanation

The following are 2 correct ways to copy the worksheet visualisation as an image:

AND

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.

In Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.

A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.

When you share a story —for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online—users can interact with the story to reveal new findings or ask new questions of the data.

Explanation

As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000

1) Right click on customer name --> Create --> Set

2) Let's Name the Set - Customer>30k ( you can name it anything you want :) )

Select USE ALL, and then move to the CONDITION TAB:

3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK

4) You should now have a new Set in the Data Pane as follows:

5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.

6) Click on the Show Mark Labels, and Sort ascending icons as shown:

7) Voila! We have our answer:

c

Explanation

A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.

Therefore, we need at least 2 measures for creating bullet graphs.

In Tableau, when creating a combined axis chart, after dragging the first measure to the Rows shelf, you should drag the second measure directly onto the existing axis in the view. This will combine both measures on the same axis, allowing them to share a scale and an axis, which is the essence of a combined axis chart.

Explanation

You can union your data to combine two or more tables by appending values (rows) from one table to another. To union your data in Tableau data source, the tables must come from the same connection.

For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."

A union of these tables creates the following single table that contains all rows from all tables.

Exporting the visualisation gives us a static view of the visualisation.

It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF.

In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.

When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT)

Explanation

According to Tableau's official documentation -

By default, both field names are present in the Union, but contain several null values!

When field names in the union do not match, fields in the union contain null values. You can merge the non-matching fields into a single field using the merge option to remove the null values. When you use the merge option, the original fields are replaced by a new field that displays the first non-null value for each row in the non-matching fields.

You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.

For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."

Table Description automatically generated

A union of these tables creates the following single table that contains all rows from all tables.

Table Description automatically generated

Now suppose a fourth table, "August2016", is added to the underlying data. Instead of the standard "Customer" field name, it contains an abbreviated version called "Cust."

Table Description automatically generated

Table Description automatically generated

An Individual Axis in Tableau is obtained by adding a continuous into Rows or Columns Shelf.

Example:

In order to show Individual Axis in Tableau First, we drag and drop the Color from Dimension shelf to Column Shelf. Next, we drag and drop the Sales Amount from measures shelf to Rows Shelf. Since it is a continuous value, the Sales Amount will be aggregated to default Sum. Once you drag them, following Chart report will be generated.

Next, we drag and Drop one more measure value, i.e., Total Product Cost from Measures Region to Rows Shelf. Because it is a Measure value, Total Product Cost is aggregated to default Sum. From the below screenshot, you can observe that Tableau has created an individual axis for each measure (continuous field).

 You can share a dashboard as an image file by using one of the following methods: Export Image on the Dashboard menu, or a dashboard export button. Export Image on the Dashboard menu allows you to export the dashboard as an image file in BMP, JPEG, PNG, or SVG format. A dashboard export button is a custom button that you can create on your dashboard to export it as an image file using a URL action

To visually group marks in Tableau, you typically start by selecting the marks directly in the view. Once the desired marks are selected, you can then create a group from them. This will visually group the selected marks, as indicated by the blue color in the example provided.

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

To apply bold text formatting to rows or columns independently in Tableau, you should use the Rows tab or the Columns tab on the Format Font pane. This approach provides control over the formatting of text within individual rows or columns. By selecting the appropriate tab (Rows or Columns), you can apply formatting settings, including bold text, to only the selected rows or columns. This is a crucial feature for enhancing the readability and visual appeal of specific parts of a Tableau worksheet, allowing for emphasis on particular data points or categories.

We can use scatter plots to visualize relationships between numerical variables!

In Tableau, you create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf (Total 2 minimum). If these shelves contain both dimensions and measures, Tableau places the measures as the innermost fields, which means that measures are always to the right of any dimensions that you have also placed on these shelves. The word "innermost" in this case refers to the table structure.

 ( Simple Scatter Plot)

 (Matrix of Scatter Plots)

A scatter plot can use several mark types. By default, Tableau uses the shape mark type. Depending on your data, you might want to use another mark type, such as a circle or a square. For more information, see Change the Type of Mark in the View.

To create a scatter plot, follow the steps below:

Explanation

A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.

On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.

On the secondary axis, a line graph is used to show the cumulative total in percent format.

To perform a union in Tableau, the tables must have a related field with matching data types, and they must have the same number of fields. This allows the tables to be appended vertically in the data source. Different names or tables from different connections do not affect the ability to union the tables.

Important question! You cannot use a context filter to replace a data source filter since each filter type has its own use case. Also, a content filter is an Independent filter and all other filters are called dependent since they only process the data that passes through a context filter.

According to the official documentation : 

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.

Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map )

From the official documentation:

Yes! We get different options for filtering depending on whether we use a categorical data (think dimension) or quantitative data (think measure).

Important Note: Each tab adds additional definitions to your filter. For example, you can select to exclude values under the General tab, and also add limits under the Top tab. Selections and configurations from both tabs are applied to your filter.At any time, you can see the definitions of your filter under Summary on the General tab.

Note: If you have a large data source, filtering measures can lead to a significant degradation in performance. It is sometimes much more efficient to filter by creating a set containing the measure and then apply a filter to the set. For more information about creating sets, see Create Sets

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

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, when you initially add a measure to the rows shelf, you create one mark in the view that represents the aggregate value of that measure. When you then add a dimension with 11 members to the columns shelf, the view is subdivided into 11 separate marks, each representing the measure for one of the dimension members. This results in a total of 11 marks in the view after the dimension is added, one for each member of the dimension.

When exporting a view as an image in Tableau, the default export includes everything that is currently displayed in the view, with Tableau applying its own styling, including fonts. The default format for an exported image is PNG, which is a raster-based file format that captures all visual elements as pixels. PNG is widely used for its lossless compression and is suitable for detailed images like those produced by Tableau. Unlike vector-based images, PNGs do not embed fonts, and the image quality remains consistent when the image is viewed on different platforms, which makes it ideal for inserting into documents like Microsoft Word.

February is a discrete date part, because it is a specific value that can be used to group or filter data by month. 07Mar2017, 20Sep2016:9:8:8:6546, and 01/23/2021 are continuous date values, because they represent points along a continuous timeline that can be used for analysis.

Explanation

Pretty common question on the Tableau Desktop Specialist exam.

1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:

2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.

NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:

3) Now, let's create a dashboard, and use both these sheets in it:

4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:

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.

When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field.

When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.

Web version:

Desktop Version:

For more information about color palettes, see Color Palettes and Effects.

 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.

Three statements that accurately describe dimensions are: Contain qualitative values Affect the level of detail in the view Can be continuous or discrete Dimensions are fields that contain qualitative values, such as names, dates, or geographical data. You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view by creating headers or labels for marks or by defining how data is partitioned for table calculations. Dimensions can be continuous or discrete depending on their data type and format. Continuous dimensions are those that have an infinite range of possible values, such as numbers or ratios. Discrete dimensions are those that have a finite number of distinct values, such as names, categories, or dates3 The other options are not accurate statements about dimensions. Contain numeric, quantitative values is not correct, because fields that contain numeric, quantitative values are measures, not dimensions. Measures are fields that contain numeric values that you can measure and aggregate. Affect the formatting options in the view is not correct, because formatting options are not determined by dimensions, but rather by user preferences and choices. Formatting options allow you to change the appearance of various elements in the workbook, such as fonts, borders, shading, alignment, etc3

Explanation

Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source.

When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.

Extracts are advantageous for several reasons:

1) Supports large data sets: You can create extracts that contain billions of rows of data.

2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.

3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.

4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.

5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.

Explanation

The word 'static tool' gives it away.

According to the official website :

Explanation

A geographic role associates each value in a field with a latitude and longitude value.

Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.

To assign a geographic role to a field:

In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.

When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane: Latitude (generated) and Longitude (generated).

These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles. If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.

To show how Internet Usage values change from year to year as a percentage, you should apply the "Percent Difference" quick table calculation to the Internet Usage field. This calculation compares each value to the previous value and computes the difference as a percentage, which is ideal for analyzing the rate of change over a sequential time period such as consecutive years.

Explanation

By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.

You may create a context filter to:

1) Improve performance – If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.

2) Create a dependent numerical or top N filter – You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

You should save a workbook as a PDF document if you need paper copies of the workbook. A PDF document preserves the layout and formatting of the workbook, and can be easily printed or shared. Saving a workbook as a PDF document is not necessary or useful in the other situations1

With dimension filters in Tableau, you can use several filter modes, including "Multiple Values (drop-down)" which allows users to select one or more values from a drop-down list of all the dimension's members. Another mode is "Wildcard Match," which lets users filter the view by typing in a text box to match dimension members that contain the typed string. These filter types are particularly useful for string or categorical dimensions where users need to search or select specific members to display in the view.

Explanation

Tableau auto-generates :

1 Dimension - Measure Names

4 Measures - Latitude, Longitude, Number of records, Measure Values

Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)

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:

It is clear that October with -55.3% had the lowest Year on Year growth.

Two use cases for creating hierarchies from the Data pane are to add drilldown functionality for fields and to organize related fields together. A hierarchy is a way of organizing data into different levels of detail. For example, a date hierarchy can have year, quarter, month, and day levels. A geographic hierarchy can have country, state, city, and zip code levels. By creating hierarchies from the Data pane, you can quickly drill down or up in a hierarchy to add or subtract more levels of detail in the view. You can also use hierarchies to group related fields together in the Data pane, making it easier to find and use them14 The other options are not valid use cases for creating hierarchies from the Data pane. To concatenate all fields into a single field, you need to use a calculated field or a join, not a hierarchy. To create faster-performing queries, you need to optimize your data source, filters, calculations, or extracts, not create hierarchies

According to the official Tableau documentation:

Graphical user interface, text, application Description automatically generated

Explanation

You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.

Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.

To create an alias:

1) In the Data pane, right-click a dimension and select Aliases.

2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.

• To submit your changes: In Tableau Desktop, click OK.

On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.

When you add the field to the view, the alias names appear as labels in the view. For example:

Explanation

Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.

Explanation

Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.

Inner join

Left Join

Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.

Explanation

When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.

When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That’s where Data Interpreter can help.

Explanation

Whenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu.

If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.

To disaggregate all measures in the view:

Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.

The following options are available when an image is Exported:

NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image.

Explanation

Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.

Please refer to the images below:

Explanation

This is true, indeed!

The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

Yes, due to the nature of blends, there are some conditions as follows from the official documentation that must be kept in mind while working with blends:

In addition to handling calculations slightly differently, there are some limitations on secondary data sources. You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data. For more information, see Other data blending issues.

You should select Size on the Marks card and use the slider to adjust the size to uniformly change the size for all marks in a view. The Size property on the Marks card allows you to control the size of marks in the view by moving the slider to the left or right. The Size slider affects different marks in different ways, such as making them bigger or smaller, wider or narrower, or thicker or thinner1 The other options are not valid ways to uniformly change the size for all marks in a view. Selecting Label on the Marks card and then selecting Alignment will allow you to change the position of labels on marks, not the size of marks2 Using the Fit dropdown menu on the toolbar will allow you to change how the view fits within the worksheet, not the size of marks3 Selecting Format on the menu, and then selecting Cell Size will allow you to change the height and width of cells in a text table, not the size of marks in other types of views4

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:

All are correct, except - Copy of any local file-based data. This is contained in a .tdsx file (Tableau Packaged Data Source)!

According to the official documentation -

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

Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.

Step 1: Drag a date field to the filter shelf

Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.

Step 2: Select a time unit

In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.

Here, you can clearly see that the default date is TODAY

Only 1 option is correct -

Click on Dashboard in the Menu bar followed by Copy Image

Right click on the dashboard, and choose Copy, then image - Try doing this, you will end up copying just one of the worksheets not the entire dashboard

Click on Worksheet in the Menu bar followed by Export, then choose Image - Again, try doing this. You will end up copying just one of the worksheets not the entire dashboard

Using the floating export worksheet option on the Dashboard - No such option exists

Explanation

Here's how to add image files to your repository:

1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.

2) Download the image to your computer.

3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.

4) Open Tableau and your new shapes will automatically be included in your "edit shapes" menu.

Explanation

Since we need to focus on 1 country -> Japan, let's filter on it first as follows:

1) Drag Country to the filter shelf, and choose only Japan. Click OK.

2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:

Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.

Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.

The following is our visualisation:

Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME. Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)

According to the Tableau Help, there are two filter modes for continuous filters: Range of Values and Single Value. The help also states that “Range of Values lets you specify a minimum and maximum value for the filter using sliders or input fields” and “Single Value lets you select one value on a slider for the filter” (page 1).

When the Physical Tables option is selected for an extract in Tableau, an individual table is created for each physical table in the extract. This means that the extract will include a separate table for each underlying table in your database, maintaining the database's structure within the extract. This can be useful when you need to preserve the original granularity of the data or when working with certain database optimizations.

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.

A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.

We can create a Bullet graph with just 2 measures! This method requires the LEAST number of fields possible to create this type of chart.

The best way to tackle such questions in the exam is to click the "SHOW ME" button on top right, and hover over the chart we want to create.

In our case, it is a Bullet graph.

Therefore, we need 2 measures at least to create this chart, and 0 or more dimensions.

You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:

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.

In Tableau, you can rename a field directly in the Data pane by clicking and holding on the field name until it becomes editable, allowing you to type a new name. Alternatively, you can use the drop-down menu associated with the field in the Data pane and select the "Rename" option. Both methods provide a quick and easy way to change the name of a field without affecting the underlying data structure. The "Format menu" and "Replace References" option do not apply to renaming fields.

Explanation

When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

1) Right click on Rows or Columns, and choose format. In the Font option click on Bold. (CORRECT) - this will modify only the selected axis (row or column)

2) Choose Format then Font from the Menu bar, and select Bold under the Header option (INCORRECT) - this modifies both rows and columns at the same time

3) Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option (CORRECT) -  this will modify only the selected axis (row or column)

4) Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold. (INCORRECT) - no such option exists

In Tableau, the two elements that can have their values changed by using a dashboard action are Sets and Parameters. Dashboard actions can be configured to modify the values within a set or a parameter, allowing for interactive and dynamic changes in the visualization based on user interactions. For example, selecting a specific data point in a dashboard can trigger an action that updates a set or changes the value of a parameter, which in turn can alter the displayed data or the appearance of visualizations within the dashboard.

According to the official Tableau documentation:

An example of an area chart is shown below:

From the official documentation, the following are the major advantages of using Tableau Data Extracts:

From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!

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

Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet—it becomes the primary data source.

Switch to the other data source and use a field on the same sheet—it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.

According to the official Tableau Documentation:

To read more about Data Blending, click on THIS link.

View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.

The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.

From the official website: