When exporting a worksheet as an image in Tableau, which of the following file formats are available?

• A.Portable Network Graphic (.PNG)
• B.JPEG Image (.JPG, .JPEG)
• C.Tagged Image File Format (TIFF)
• D.Windows Bitmap (.BMP)

Correct Answer: A,B,D

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

Comment: *

Name: *

Email: *

Verification: *

Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through
2014, respectively?

• A.5,129 and 88,872
• B.52,678 and 311,404
• C.1,807 and 34,571
• D.4,888 and 17,817

Correct Answer: D

Explanation
To reach the correct answer, follow these steps:
1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:

2) Drag Profit to Text in the Marks Shelf as shown:

3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS
The following will be the final view:

You could also Filter by Region to only Focus on Canada, but that's your choice:

THEREFORE,
2012 = 4,888
2011 -> 2014 = 17,817

Comment: *

Name: *

Email: *

Verification: *

How would you calculate GDP per capita in Tableau?

• A.SUM([GDP]/[POPULATION])
• B.SUM([Population]/[GDP]])
• C.SUM([GDP]*[POPULATION])
• D.SUM([GDP]) / SUM([Population])

Correct Answer: D

Explanation
GDP / Population = GDP Per Capita

Here Sum is a function, / and + are operators. On the bottom there are comments.

Comment: *

Name: *

Email: *

Verification: *

Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

• A.Tom Ashbrook
• B.Sanjit Engle
• C.Penelope Sewall
• D.Tamara Chand

Correct Answer: C

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

Comment: *

Name: *

Email: *

Verification: *

_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins

• A.Union
• B.Data Joining
• C.Data segregation
• D.Data Blending

Correct Answer: D

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

Comment: *

Name: *

Email: *

Verification: *