Free Practice Questions for Tableau Desktop-Specialist Exam

According to the official Tableau documentation:

Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension. Extract files are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. For more information, see Extract Your Data.

Explanation

Follow along to reach the correct answer:

1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:

Click on Date in the Column shelf and convert it to continuous month :

2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

3) Finally, click on the Show mark Labels icon:

4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:

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:

Layout containers let you group related dashboard items together so you can quickly position them. As you change the size and placement of items inside a container, other container items automatically adjust

To create a simple scatter plot in Tableau, you need to have a measure on Columns and a measure on Rows. A scatter plot is a type of visualization that shows the relationship between two numerical variables. In Tableau, you can create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf. The measures can be continuous or discrete, but they must be aggregated. The marks in the scatter plot represent the intersection of the values for each measure1 The other options are not valid ways to create a simple scatter plot in Tableau. A dimension on Detail and a measure on Columns will create a bar chart, not a scatter plot. A dimension on Columns and a measure on Rows will create a line chart or an area chart, depending on the mark type. A dimension on Columns and a dimension on Rows will create a text table or a heat map, depending on the mark type1

Dragging a continuous date value to the Rows shelf in Tableau results in a green pill on the Rows shelf, indicating a continuous field. It also results in a quantitative axis being displayed on the visualization. Continuous fields are used to create axes on charts and can represent a range of values smoothly. This is opposed to discrete date values, which would be represented by a blue pill and typically show headers or labels rather than a continuous axis.

Explanation

Since Sales is a measure, it can easily be depicted via size.

To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc.

Finally, the Profit can be depicted via a color! Eg - Red for poor and green for excellent profits!

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:

There are three benefits of using an extract as compared to a live connection to a data source:

A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance. An extract is a snapshot of data that is stored locally on your computer or on Tableau Server. An extract can reduce the load on the data source and speed up queries.

Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections. When you use an extract, Tableau loads the data into memory and optimizes it for analysis. This allows Tableau to perform calculations and aggregations faster than with live connections.

Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source. Calculated fields are custom fields that you create using formulas or expressions. When you use an extract, Tableau can process calculated fields more efficiently than with live connections.

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