Tableau Updated TDS-C01 Exam Questions and Answers by coby

According to the official documentation:

Joins are a more static way to combine data. Joins must be defined between physical tables up front, before analysis, and can’t be changed without impacting all sheets using that data source. Joined tables are always merged into a single table. As a result, sometimes joined data is missing unmatched values, or duplicates aggregated values.

Joins -

1) Are displayed with Venn diagram icons between physical tables

2) Require you to select join types and join clauses

3) Joined physical tables are merged into a single logical table with a fixed combination of data

4) May drop unmatched measure values

5) May duplicate aggregate values when fields are at different levels of detail

6) Support scenarios that require a single table of data, such as extract filters and aggregation

Using the Sample superstore as a reference, click on the manage metadata icon as follows:

We can rename a particular column name to make it easier to remember and use in Tableau. Let's change Order ID to oID as shown:

Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source. The remote field name let's us see what the name of the column is in the ORIGINAL Data source.

According to the Tableau Desktop Specialist Exam Readiness, to create a calculation that returns a customer name followed by a comma, a space, and then the customer’s age, you should use the formula [Customer Name] + “,” + STR([Age]). This is because you need to concatenate strings using the + operator, and convert the numeric field [Age] to a string using the STR() function.

Explanation

After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

Graphical user interface, chart, line chart Description automatically generated

To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.

In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.

If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.

In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.