Free Practice Questions for Tableau TDS-C01 Exam

Using the Sample superstore as a reference:

1) Let's plot a bar chart showing SUM(Quantity) for each Segment:

2) Right click on the x-axis (Segment):

Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.

3) Similarly, right click on the y-axis (Quantity):

Now we have the option to edit BOTH the axis and the header.

Explanation

From the official Tableau website:

In fact, the opposite of this is true.

Trick : Whenever you think of joins -> Think that after the join is created, we get 1 single flat combined (joined) table. This flat combined table is created prior to us creating our visualizations. This happens at the physical layer.

If you ever think about relationships, know that all tables will remain distinct and separate, and relationships sit at the logical layer. At run time, when you bring in the dimensions and measures to create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries to these tables to get the resultant data back in the most meaningful way possible. This allows you to focus on using your data and revealing insights from it and focus less on the data preparation aspect!

Refer to logical layer vs physical layer from the official documentation: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm

By default, measures placed in a view are aggregated. Mostly you'll notice that the aggregation is SUM, but not ALWAYS.

The type of aggregation applied varies depending on the context of the view.

Explanation

Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use - Type casting. See below:

Here, State and City are Strings, but Postal Code? Nope. It's an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!