Which of the following is a valid way to create Sets in Tableau?
Correct Answer:A
There are two types of sets: dynamic sets and fixed sets. The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.
To create a dynamic set:
1) In the Data pane, right-click a dimension and select Create > Set.
2) In the Create Set dialog box, configure your set. You can configure your set using the following tabs:
General: Use the General tab to select one or more values that will be considered when computing the set.
You can alternatively select the Use all option to always consider all members even when new members are added or removed.
None of the other options exist, and therefore are incorrect answers.
Reference: https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sets_create.htm
How would you calculate GDP per capita in Tableau?
Correct Answer:D
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
When field names in the Union do not match, then:
Correct Answer:D
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
A union of these tables creates the following single table that contains all rows from all tables.
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."
Reference: https://help.tableau.com/current/pro/desktop/en-us/union.htm
True or False: Context Filters are executed after Data Source filters
Correct Answer:A
THIS IS A VERY IMPORTANT QUESTION
To answer this question, you need to understand Tableau's Order of Operations. See below and remember this always:
Reference: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm
Which of the following is a benefit of using a Tableau Data Source (.tds)?
Correct Answer:B
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.
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
Correct Answer:C
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