TDS-C01 Online Practice Questions and Answers

Correct Answer: CD

Correct Answer: BC

Correct Answer: B

Correct Answer: BC

Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated. Calculated Fields, and Number of records can both be deleted.

Correct Answer: B

It is possible in Tableau to use a sheet within a story directly. Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case. At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.

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

Correct Answer: C

If you chose 111,060 you were SO close to the correct answer but made a small mistake-you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.

To reach the correct answer, follow the steps below:

1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well! Although this seems enough, DON'T FORGET to change the aggregation like in the

next step, which will completely change the values!

The correct answer as you can see is 1,461-Sales for Harware Assortment in 2017 Q4, October

Correct Answer: B

Yes! We get different color palettes. They are: *From the official Tableau documentation*

To change the color for a value

1) Click on an item on the left, under Select Data Item.

2) Click a new color in the palette on the right. In Tableau Desktop you can hover over a swatch to identify the color.

3) Repeat for as many values that you want to change.

4) In Tableau Desktop, click OK to exit the Edit Colors dialog box. In Tableau Server or Tableau Online, simply close the dialog box.

AND

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

Correct Answer: D

Your Tableau Desktop Specialist exam will be based on the 2020.1 version. Set controls are a new feature introduced in the 2020.2 version, and hence is the correct answer-it is not a part of 2020.1

For the 2020.1 version the new features were:

1) Viz animations:

Viz animations help you see and understand your changing data. It's easy to track the logical steps behind data's evolution and tell powerful data stories. Sorting, filtering, adding fields, and other actions will now smoothly animate your

visualizations. Choose whether to turn Viz Animations on or off, and decide how you'd best like to apply animations to your new workbooks.

2) Dynamic Parameters:

Say goodbye to republishing workbooks with parameters every time the underlying data changes. Set your parameter once, and Tableau will automatically update the parameter's list of values every time someone opens the workbook.

3) Buffer Calculations:

Buffer calculations allow you to visualize the distance around point locations. Give Tableau three parameters--location, distance, and a unit of measure--and a buffer, or boundary is instantly created. Answering complex spatial questions becomes easier than ever before--visualize what properties are within 200 meters of a proposed transit site, or how many competitors' stores are within 1 mile of their store, and more.

Correct Answer: C

We need to use the concept of Groups for this question. Follow along:

1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation-> Percent of total:

3) Next, Select the States of New York, California and Washington-> And then click the paperclip icon:

We can see the answer already : 23.386% in the view above (even before grouping!)

4) Finally, we get the following view and our answer:

Correct Answer: D

You don't need to know ANY programming language to use quick table calculations!

Follow along with the steps below to learn how to apply a quick table calculation to a visualization:

1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.

2) Navigate to a new worksheet.

3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.

4) From the Data pane, under Dimensions, drag State to the Rows shelf.

5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.

6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.

7) On the Marks card, click the Mark Type drop-down and select Square.

The visualization updates to look like this:

Apply the quick table calculation

1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.

Note: You can only perform quick table calculations on measures in the view. A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving

average of profit across the years.

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