Tableau Certification

Which Marks card option is only used to create pie charts?

Angle

What is the maximum number of categories a pie chart can show effectively?

5

Which of the following is true for a computed sort? A) Computed sort organizes the data by applying rules. Correctly unselected B) Computed sort allows users to specify the sort order. Correctly unselected C) Computed sort is dynamic

A & C

What is a set in Tableau?

A custom field that defines a subset of data based on specific conditions.

What action automatically adds Measure Names and usually Measure Values to a view?

Adding two or more measures to the same same axis.

If you change the default calendar for a data sourse to ISO-8601 Week-Based, what will it apply to?

All worksheets using the data source.

You have a data source that is updated daily with new sales transactions. Which of the following is the most efficient option to refresh the extract?

An incremental extract refresh

Dynamic sets are preferable to fixed sets when you want to:

Analyze data that changes frequently.

Select the best answer for the following question. On Columns or Rows, when expanding a date field that is a discrete date part, how many levels of detail for the field can you include in the view?

As many levels of detail as there are for the date field in the data source

In the view shown below, you want to show data only for the months that have sales over 2,000 dollars. Which of the following filter types should you select?

At Least

Where on the Data Source page would you drag a table that you want to add to your visualization?

Canvas

How do you add grand totals to a text table?

Click the Analysis menu, point to Totals, and click Show Row Grand Totals or Show Column Grand Totals.

Which three areas of the Marks card do you use to build a highlight table?

Color, Text and Mark type

To connect to data with Tableau Desktop, where in the interface do you first click from?

Connect Pane

Why does Tableau create a live data connection by default?

Connecting live means that as new source data is added, it can be incorporated into your analysis.

What type of data is date value?

Continuous

What type of data is it when it is green

Continuous

You are analyzing sales of children's toys. The toy list is very long and has three spellings of Plush: Plushie Plush plush Which of the following can you do to correct this?

Create a group from the Data pane.

With the Tableau Online Explorer role, to connect to a data source, you must:

Create a new workbook.

How can you display the top 5 and bottom 5 sales in the same view?

Create the view using a combined set to include all members from the top 5 and bottom 5 sets.

Each time you add your Order Priority field to a viz, you need to change the sort order. What can you do to avoid repeating this task?

Customize the field's default properties.

Groups can be created directly from the view and the ______________?

Data Pane

Which area of the Tableau workspace displays the data source name and its available fields as dimensions and measures?

Data Pane

In date field menu what comes first, date part or date value?

Date Part

You want to view the daily profits over a continuous range of time. What option on the date field menu will show you this? More > Weekday Day (May 8, 2015) Day (8) Continuous

Day (May 8, 2015)

In a bullet graph, what's one way to increase the visibility of the distribution band?

Decrease the size of the bars

A set can be used as a:

Dimension

What type of data is date part?

Discrete

What type of data is it when it is blue?

Discrete

What types of custom date fields do you need to create custom date hierarchies?

Discrete date parts

You have created a hierarchy in the Data pane, but some of the fields are in the wrong order. What can you do to reorder the fields?

Drag the fields into the proper order in the Data pane.

To display a set control for a set, it must be

Dynamic & Used in the view

Symbol maps can show up to two quantitative values per location. Which of the following is a good way to represent those two values?

Encode the first value with size and the second value with color.

How many measures can you have in a text table.

Fifty on Rows and sixteen on Columns.

If you want to keep the map's zoom level from changing which button on the View toolbar would you click?

Fix Map

When you have a large number of fields in the Data pane, it can be helpful to organize dimensions and measures into:

Folders

Which of the terms below best completes the following sentence? By adjusting the combination of Color, ____, and Size, you can make the trends in a density map much more apparent.

Intensity

What is the Measure Names field?

It is a dimension that contains the names of the measures.

What is the Measure Values field?

It is a measure containing the values for the measures.

Why might you choose to create a text table of your data?

It's a good view type to use as a reference tool

To create a filled map, which mark type should you select on the Marks card?

Map

In the following view, you want to show sales data for customers whose names start with "Joe". Which of the following filter types would be best suited for this scenario? (Click on the image to enlarge it.)

Multiple Values (Custom List)

Which of the following statements is true for nested sorting in Tableau? Sorting from a field label gives a nested sort by default. Nested sorting considers each pane independently and sorts the rows per pane. Nested sorting conveys the aggregated information about how the values compare overall.

Nested sorting considers each pane independently and sorts the rows per pane.

Select the best answer for the following question. On Columns or Rows, when expanding a date field that is a continuous date value, how many levels of detail for the field can you include in the view?

One, a date value

The QA team in your company has shared a view that shows all the bugs logged against the new features for your next product launch. The bug review by your team only triages bugs logged in the last 30 days. Which date filter is most ideal to quickly see this data?

Relative Date

Which type of change to the source data requires you to replace references?

Renaming fields used in the view. (a structural change)

You have manually sorted several dimension fields within a visualization and would like to clear the sort. What is one way to clear it?

Right-click the drop-down menu for a field, and select Clear Sort

You work with the same dataset on a regular basis and you make the same customizations each time. What can you do to streamline this process?

Save your customizations to a Tableau data source (.tds) file and work from the .tds file in the future.

What filter is applied first?

Sets

What is an effective use of a tree map?

Showing part-to-whole comparisons of data sets with long tails in their distribution and many levels of dimensions.

What is an effective use of a pie chart?

Showing part-to-whole comparisons with a dimension that has a small number of categories

You're working with a data source with quantitative values (with a wide variation in those values) and latitude and longitude coordinates. Which would be a good map type to use to analyze this data geographically?

Symbol Map

What is the best indication that Custom Months is a custom date field?

The equal sign before the Date icon

What is required to create a dual axis chart?

Two measures and one or more dimensions.

How do you expand and contract the display of related fields in a hierarchy?

Use the [+] and [-] to drill down and up.

When does Tableau recommend using physical tables in an extract?

When the extract using logical tables is larger than expected.

In which of the following scenarios would a bar-in-bar chart be the best choice?

You want to show two measures against one another simultaneously

Which of the terms below best completes the following sentence? Density marks work best when the specific locations ____

change continuously and smoothly across a limited space.

Which of the terms below best completes the following sentence? When I drag State from the Data pane into the view, Tableau adds latitude and longitude fields to Columns and Rows. This is because Tableau ______ the State field.

geocoded