Tableau Specialist notes

Which of the following is a table calculation?

% of Total Sales along Table (Across)

How would you change the font color of the tooltip? (Select all that apply)

1)Right-click on the view, select "Format" and select the dropdown next to tooltip. Then select the color. 2)Click on the tooltip button in the Marks area, highlight the text, and select the desired color using the dropdown

Which of the following describes the Measure Names field (select all that apply)

1)When you create a view with multiple measures on a single continuous axis, Tableau will automatically add Measure Names to the view. 2)When you add Measure Names to a view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a text table that shows multiple measures.

Which of the following is true?

A dashboard cannot include a story, but a story can include a dashboard

4. This type of join will include all values from the left table:

A left join will include all values from the left table.

If you add cities to a worksheet and find that you have a map with many unknown locations, which of the following steps may help resolve the problem

Add state to the worksheet

Which of the following will result in an error?

Aggregation on a field that is already aggregated

Which of the following mark types cannot be adjusted using the Size slider?

Area

Which of the following can include multiple version of the same worksheet?

Stories but not dashboards

What steps would you take to change the following view so that Furniture is represented by the triangle symbol?

Click on shapes in the marks area. Then select furniture and the triangle icon and click okay

Which of the following will create a dashboard action?

Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter"

A color gradient is used for which of the following

Continuous measure

You would like the person using your dashboard to select the year, and based on the year to adjust the interest rate in some related calculated fields. You will like the year selection to limit the data in the view. What Tableau element should you to let the user select the interest rate?

Correct answer is parameter will allow the user to set a value which you can then use in a calculated field. You can also use a parameter in a calculation, and then use that calculated field in a filter to limit the data in the view.

Which of the following occur earlier in the order of operations than context filters?

Data source filters

Which of the following field types will create a color palette?

Discrete

Which of the following join will always include all rows from both tables?

Full Outer

Your view has the dimensions "Product Category," "Product Sub-category" and "Product Name." Which of the following would combine these dimensions to enable drill down

Hierarchy

A dashboard action can be triggered by which of the following?

Hover, Menu, Select

Which of the following is true of a live connection?

If your data source is a database, you will need to enter credentials to access the data

A blend is most similar to which type of join?

Left Join

Which of the following chart types requires at date field?

Line chart

Which describes a descending sort?

Ordered from greatest to least

Which term best describes [Year] in the calculation show below?

Parameter *(think purple)

Which type of visualization is not typically effective in showing change over time?

Scatter Plot

Which of the following action types can be used to create proportional brushing?

Set Action

Your data has a column which should be treated as a date, but when you change the data type to date you see a lot of null values or obviously incorrect dates like 12/30/1899. What can you do next since the date conversion did not work?

Set the type back to string, then try date conversion functions like DateParse and Date

Which of the following is not a default property which can be set for a measure?

Sort

Which type of filter usually works best with date fields?

The Visual Analysis Best Practices explains, "Remember that slider filters are great for date and numerical values—while list filters are better for categorical data."

A relative date filter works relative to:

The anchor date: Relative date filters work relative to the anchor date. By default this will be the current date, but this can be changed:

You connect Tableau to a Excel file which includes a column that has mostly numeric data, but has a few date and text values mixed in. Tableau set the data type for this field as Number. What happens to the date and text values when the data is imported to Tableau?

The date values are set to the number of days since 1/1/1900 and the text value is set to null. when the data type is mapped as numbers, text is treated as null while dates are treated as the number of days since 1/1/1900

Which of the following would help determine the relationship between quantity sold and profit?

Trend Line

Which of the following can be used to combine the rows from one table with the rows from a second table?

Union

How can you identify the top ten customers with the highest sales where the customers are in the corporate segment?

Use a set to identify the top 10 customers with the highest sales, and create a context filter on corporate segment.

Which feature will allow you to show more relevant or descriptive dimension values in your view than what the original data provides?

alias