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