TDS-C01 Online Practice Questions and Answers

Correct Answer: A

Correct Answer: A

Select them and then group using the "group members" (paper clip looking) icon

Correct Answer: AD

Correct Answer: C

Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.

The Data pane includes:

Dimension fields ?Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view.

Examples of dimensions include dates, customer names, and customer segments. Measure fields ?Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a

measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures:

sales, profit, number of employees, temperature, frequency. For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.

Calculated fields If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called

calculated fields. For more information on calculated fields, see Create Custom Fields with Calculations. Sets

Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets. Named sets from an MS Analysis Services server or from a Teradata OLAP connector

also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau. Parameters Values that can be used as placeholders in formulas, or replace

constant values in calculated fields and filters. For more information, see Create Parameters.

Reference: https://help.tableau.com/current/pro/desktop/en-us/datafields_understanddatawindow.htm

Correct Answer: C

By default, all of the above mentioned are stored in Documents-> My Tableau Repository Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm

Correct Answer: B

The beauty of context filters is that according to Tableau's Order of Operations, they are executed before Sets.

Diagram

This means that based on what Region's you've selected-Tableau will first only preserve the rows for those Regions. THEN, after this it will compute the Set , i.e , Bottom 10 products in each Region.

1) First let's create a set to compute the Bottom 10 Products by Profit.

2) Next, take region on the Rows Shelf followed by the Set we just created. Drag Region and the Set to the Filters Shelf as well.

3) Now, try to only visualize the data for the South Region:

4) The problem right now is that Tableau is computing the Set first (Bottom 10 Products), and then applying the Dimension Filter-South Region and hence these values are incorrect. Note how these aren't even 10 products, but rather just 8. To fix this, simply add Region to Context:

Upon doing this, we get the correct answer as :

References: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm

Correct Answer: B

You can add a reference line to any continuous axis in the view.

To add a reference line:

Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.

In a simple case, the drop target area offers three options:

Reference: https://help.tableau.com/current/pro/desktop/en-us/reference_lines.htm

Correct Answer: BCDE

Video is NOT a valid object type while creating dashboards in Tableau! All others are valid object types.

Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_create.htm

Correct Answer: A

Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf. For sales, click on the pill-> choose Quick Table calculation-> Year over Year growth.

Correct Answer: A

We can use scatter plots to visualize relationships between numerical variables!

In Tableau, you create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf (Total 2 minimum). If these shelves contain both dimensions and measures, Tableau places the measures as the innermost fields, which means that measures are always to the right of any dimensions that you have also placed on these shelves. The word "innermost" in this case refers to the table structure.

( Simple Scatter Plot)

(Matrix of Scatter Plots)

A scatter plot can use several mark types. By default, Tableau uses the shape mark type. Depending on your data, you might want to use another mark type, such as a circle or a square. For more information, see Change the Type of Mark in the View.

Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_scatter.htm