Desktop-Specialist Exam Dumps : Tableau Desktop Specialist Exam

The following are the official definitions from the Tableau documentation for the various file types:

1) .tds (Tableau Data Source) - To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc. (CORRECT ANSWER)

2) .twbx ( Tableau packaged workbook) - To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don’t have access to the original data.

3) Extract (.hyper or .tde) – To create 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.

3) (.twb) Workbooks – To hold one or more worksheets, plus zero or more dashboards and stories.

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:

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