Free Tableau Desktop-Specialist Practice Exam with Questions & Answers | Set: 8

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!

To update the font of an entire workbook in Tableau, you should use the "Format Workbook" pane. This feature allows you to set and modify the default font settings for the entire workbook, ensuring consistency in font style across all sheets and dashboards. It's a global setting that applies to all visual elements in the workbook, including titles, captions, axis labels, and other text elements.

Explanation

TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn’t contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.

Create a .twbx with file-based data sources

1) Select File > Save As.

2) Specify a file name for the packaged workbook in the Save As dialog box.

3)Select Tableau Packaged Workbooks on the Save as type drop-down list.

4) Click Save.

5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.

The following files are included in packaged workbooks:

--> Background images

--> Custom geocoding

--> Custom shapes

--> Local cube files

--> Microsoft Access files

--> Microsoft Excel files

--> Tableau extract files (.hyper or .tde)

--> Text files (.csv, .txt, etc.)

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!!)

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

When dealing with a union of two tables in Tableau, using logical tables with a single table extract is the most appropriate approach. Logical tables allow for the integration of data from multiple tables in a way that is seamless and efficient for analysis. By using a single table extract, Tableau consolidates the data from the union into one extract, optimizing performance and enabling faster data processing. This approach is particularly beneficial when working with large datasets or complex unions.

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.

Upon clicking on a filter, we see the following options:

Clearly, Regex Match is not one of these options!

To create a trend line, we need:

Graphical user interface, application Description automatically generated

Explanation

You can export the data in a Tableau data source, including all or part of the records from your original data. Alternatively, you can export only the portion of data used to generate the view.

Since the question mentions the data used to build the view, we'll focus on that :

*Export data in the view to Microsoft Access or .csv*

Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).

1) In Tableau Desktop, select Worksheet > Export > Data.

2) Select a location and type a name for your Access database or .csv file.

3) Click Save.

4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.

Graphical user interface, text, application, email Description automatically generated