Tableau Essential Training

When exporting visualizations to PowerPoint, which extension should you select?

.pptx

If you want to sort a list of sales values from highest to lowest, how should you sort your list?

in descending order

If you create a packaged workbook and want to share it with others who do not have the full version of Tableau, where can they view it?

in the Tableau Viewer

To unpivot a crosstab and show it as a list, you can _____.

move all column dimensions to row dimensions

What is the keyboard shortcut to save a file in Tableau?

Ctrl+S

When is saving your workbook as a PDF file beneficial?

when you want to send your documents but not have any interaction

What is the keyboard shortcut to create a new worksheet in Tableau?

Ctrl+M

To create a calculated field, which menu do you use?

the Analysis menu

What will the calculation ABS(10 % 6) produce?

4

If you want to see the average and sum at the same time, what will you need to do?

A second calculation must be added to display both the average and the sum at the same time

If you want two tests to both be true, which logical operator should you use?

AND

You want the rows in your dashboard to show fields A, B, and C, in this order. How should you arrange them?

Add fields A, B, and C to the Rows shelf in this order.

To create calculations in dialog boxes, which tab do you select in the Filter dialog box?

Condition tab

How can you move a sheet to a different position within a workbook?

Drag the sheet tab to a different location

You have a top filter that limits the number of items shown, and this limit is set by a parameter. What happens when you decrease this parameter?

Fewer top items will show

Which path would you take to add Grand Totals to a data sheet?

Go to Analysis, choose Totals, and then select Show Row Grand Totals

If you hide the Filters and Marks cards to make more room for your visualization, how can you unhide them?

Go to Worksheet, point to Show Cards, and then select Reset Cards

You do not want viewers of your datasheet to sort your data. What can you do to prevent this?

Go to the Worksheet menu, and then select Show Sort Controls to clear it.

How can you start the process of renaming a set?

In the Side Bar, right-click the set pill you want to rename

You have a data set of six values but want to show more. Which parameter do you need to change in order to display additional values?

Increase the Maximum Range of values.

If you want to change the summary operation, what should you select from the menu that appears when you click the down arrow of a field positioned on a shelf?

Measure

Nasim exported data to a .csv file and then displayed it in Excel. However, now there is data loss. What should he do next?

Select the Don't show again button to have all the data visible

Thai has created this Prod Category data chart. He uses the function COUNTD, but the data is not showing. What should he do to make the data show?

Select the icon next to the pill on the Marks card, and then select Text.

Which sorting option is not directly available to choose in the Sort dialog box?

Sort by the dimension text length.

Which Tableau product can you use to clean and prepare data?

Tableau Prep

Which Tableau file type stores a connection to a worksheet in another Tableau workbook?

Tableau bookmark (.tbm)

If you set a worksheet's tab color to green, what will happen when you switch to another worksheet?

The first worksheet remains green

Your dashboard includes a certain worksheet. You delete this worksheet, then save the dashboard. What will happen if you then use the Revert to Saved action?

There is actually no worksheet to revert to since last save

Can you add all subtotals to data with sets?

Yes; the subtotals will show the total of every set

What can you customize in the summary card?

You can select which items will appear.

You already have two groups for your data. What will be included in an "other" group, if you create one?

all items not currently in any group

You have a table consisting of two columns, and you convert it to show the percentage of the table. What will add up to 100 percent?

all the items in the table

Where is every cell in a crosstab located?

at the intersection of a row and a column

Which value will not match a wildcard filter set to match on anything containing "ap"?

banana

How do you connect to a data file?

by going to the navigation bar, and then selecting the type of file you want

How does Tableau let users join data sources with inconsistent field names?

by identifying the fields that each sheet has in common

How do you unpivot the data in a crosstab to create a list?

by rearranging the pills on the column's row shelves

When implementing a Level of Detail (LOD) expression, what do you use to indicate the calculation that is occurring at the different level of detail?

curly brackets { }

What scenarios are possible with a calculated field created on a shelf?

editing after it was created using it as a text mark converting it to a measure

When you examine your data source, how is the data set organized?

in columns

When combining two sets, which combining option results in an intersection between sets?

shared members in both sets

Which tool is used to clean up source data in Tableau?

the Data Interpreter tool

To create a nested sort, which feature should you change in the Sort dialog box?

the Sort By feature

Which Tableau feature introduce in 2019 helps users include visualizations in presentations?

the ability to export a visualization directly to PowerPoint

When you select the Manage Metadata button, the remote field name is displayed. What does this name tell you?

the field name from the original data source

What will the data display if you apply a filter to show the one field with the bottom value?

the record with the minimum value of this field

What are Tableau stories used for?

to convey a persuasive narrative about the user's insights

Why would you create a selection filter?

to limit the data that appears in your worksheet to chosen values

You want to install a driver that would connect to other data sources outside of Tableau. Where would you go to install such a driver?

to the Tableau.com support page

Halavani combined two customer names, currently called Boulder Oil Group. Now she wants to ungroup them. Which step should Halavani take?

Select the paperclip with the X on the top ribbon panel