Tableau SCMT 4633

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

the Data Interpreter tool

When are scatter plots typically used?

when you have two numerical measures

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

.pptx

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

in columns

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

Which keyboard shortcut will take you into presentation mode?

F7

In the Device Preview screen, what is similar between the desktop and mobile device types?

Both allow for element resizing.

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

Ctrl+M

How should you write the date April 29, 2020, to avoid sorting problems?

20200429

When is filtering your data using parameters helpful?

when you want to change a single control, instead of editing the entire filter

When is saving your workbook as a PDF file beneficial?

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

Nico created a pie chart, and now he wants to work with multiple pie charts. What will he need to do?

Add another dimension to the existing pie chart.

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

Which of the following built-in functions will round a number up to the next integer?

CEILING

Where did you go to add the information displayed in the legend and on the map?

Data Layers

How do you view the data that underlies the visualization you've created in Tableau?

Data menu > Data Source name > View Data

How do you create a selection filter to limit the data that appears in your sheet?

Data tab > click down arrow for the field you're filtering by > Show Filter

Like a pie chart, a tree map also uses shades of color to help indicate the value.

FALSE

You can't convert a stacked column chart visualization directly to a crosstab without recreating it.

FALSE

If you want to know the scale your map is showing, which option should you choose?

Map Options

How do you disable pan and zoom in maps?

Map menu > Map Options > un-check Allow Pan and Zoom

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

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

A limitation of Tableau is that if it does not recognize a location in a visualization it won't be able to map it, so you need to make sure that your data can be mapped.

TRUE

If you want to add colors to each of the vertical bars in a visualization, you need to drag the field that will be used as the base for those colors to the Marks card and, specifically, onto the Color box.

TRUE

In Tableau you can add a filter action to your dashboard.

TRUE

You created a scatter plot chart for a set of data, but you only see a single dot. What has happened, and what should you do in order to see more clusters for your data set?

The data is aggregated, and the Aggregate Measures under Analysis should be unchecked.

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

The first worksheet remains green

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

Which action can you perform on a color legend?

all of these answers

Which of the following data sources does Tableau allow you to connect to?

all of these answers

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

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

How do you edit the axes of your visualization?

right-click the axis > Edit Axis

How do you duplicate a worksheet that Tableau workbooks stores data in?

right-click the worksheet tab > Duplicate

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

the ability to export a visualization directly to PowerPoint

Why would you create a selection filter?

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

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

4

To _____ your data, is to transform your data from a text table or crosstab to a data list.

unpivot

Which scenario is not possible with a calculated field created on a shelf?

using it in other worksheets

How do histograms summarize data?

by using a vertical bar chart

What are Tableau stories used for?

to convey a persuasive narrative about the user's insights

Why would you use the new Tableau feature for creating calculations in dialog boxes?

to build formula-based filters to focus the data

How do you create a calculated field in Tableau?

Analysis menu > Create Calculated Field

How do you calculate the percentage that each cell in a column contributes to the whole?

Analysis menu > Percentage Of > Column

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

Ctrl+S

Which path would you take to add Grand Totals to this 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.

How can you quickly replace Sheet 1 with Sheet 3 in a dashboard?

Select Sheet 1, and then move your mouse pointer over Sheet 3 and click.

How do you define groups which let you combine multiple items into a single item in your visualization?

Select items to group. > Toolbar > Group Members

Can you use the "Show Me" options to change the type of an existing chart to any other type?

Sometimes. The "Show Me" list is always available, but will only allow certain chart types based on the current data.

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)

Which of the following Tableau file types stores a visualization without source data?

Tableau workbook (.twb)

How do you create a Dashboard in Tableau?

Task Bar > New Dashboard > from Dashboard Tab drag sheet onto the Dashboard sheet area

If you drag a pill on top of another pill, rather than changing the organization, what happens?

The new pill will replace the previous pill.

How do pie charts display your data?

as several parts contributing to a total

Where is every cell in a crosstab located?

at the intersection of a row and a column

Attempting a quick replacement of sheet A with sheet B will

place sheet B in sheet A's location

Saving your JSON data file as a text file allows you to

save room on your disc

In Tableau, how do you sort a column based on the values in that column?

select the Column > toolbar > click the ascending or sort ascending button

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

the Condition tab

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

AND

How can you start the process of renaming a set?

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

How can you start to add an annotation to a specific part of a visualization?

Move your mouse pointer over the part of the visualization that you want to annotate, and then right-click.

How do you connect to an Excel workbook, if you can, from Tableau?

Open Tableau > Connect panel > Excel > Select the workbook.

How do you add a text box to a chart?

Right-click anywhere on the chart where there is no data. > Annotate > Area

Petra wants to modify the appearance of her data sheet by showing seven different colors of blue, starting with the lighter shade for the highest value data point. What does she need to do?

Select the Color icon in the Marks card, choose Edit Colors, check the Stepped Color and enter 7, check the Reversed box, and select OK.

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.

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.

How can you start to determine the radius of the circle that would encompass several locations?

Under Options, point at the right-pointing triangle at the bottom, and then select the round selection tool.

You can convert a regular column chart to a stacked column chart by

adding a category for the color mark

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

banana

Creating separate legends allows you to

distinguish between your data values

Creating top and bottom filters lets you _____ the largest and smallest values within a list.

isolate

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

shared members in both sets

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

the Analysis menu

How can you start to edit or remove an existing reference line?

Right-click the vertical axis.

What is the shortcut to access the Presentation mode in Tableau?

F7

How do tree maps indicate value?

by shades of color

Mo has some irregular formatting within his data. What can he use to clean up his source data?

Data Interpreter

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.

Pablo is comparing data on bottles and cases. What is he doing that is highlighting the Bottle section in a yellow color?

He is choosing to do the computation using Pane.

Mishik created a highlight action on a dashboard. Why did he choose All Fields under the Target Highlighting?

He wanted the results of the action to appear on all the target sheets in the dashboard.

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.

Raziel needs to drill down on a specific visualization she wants to use. Which option should she select in this menu?

Open Help

What worksheet object should you create to let a user modify a visualization filter by changing a worksheet control?

Parameter

Suki has never used the Show Me feature. How would you explain Show Me to Suki?

Selecting the Show Me icon displays available visualizations, based on the type of data you want to visualize.

How can you tell whether an element is showing and not hidden?

There is a checkmark to the left of the element in the Worksheet drop-down menu

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.

How do you change the visual summary type to a pie chart type?

Toolbar > Show Me button > select pie chart

How do you connect to a data file?

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

If you cannot remember which changes you made, and you do not know how to undo the changes, how can you retrieve the most recent saved workbook?

Use Revert to Saved in the File menu.

How do you display the Summary Card of the visualized data in the worksheet?

Worksheet menu > Show Summary

Can you add all subtotals to data with sets?

Yes; the subtotals will show the total of every set.

When data clusters are identified, which type of chart or graph can be formed?

a scatter plot

Within the Describe Clusters dialog box, what does the tab "Models" display?

a statistical rundown of the data in the clusters

What does displaying a visualization in a tooltip show?

a visual subset of another worksheet

How will Tableau calculate the median if you have a data set of 20 values?

by taking the average of the tenth and eleventh value

How can you identify a field with a geographic role?

by the globe symbol next to the field name

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 do darker colors represent in a highlight table with built-in coloring?

larger values

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

move all column dimensions to row dimensions

If you are using the Pan feature in maps, what are you doing?

moving side to side without changing resolution

Can you disable map panning but keep map zooming enabled?

no

How do you create a set within your visualization sheet?

select the data in multiple rows > right-click one of them > choose Create Set

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 line charts best used for in Tableau?

to analyze trends of time that data sets reveal

You have a couple of columns in your sheet that need to be separated, one of which is the customer name. Which steps do you have to take to separate the first and last names into their own columns?

Hover your cursor over the "Cust Name" header, and then select the down arrow and choose Split.

Your data consists of values between 90 and 100, and you only want to focus on relative differences. Which axis options would work best?

automatic range, not including zero

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

the Sort By feature

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

Add a second calculation

How do you tell Tableau to recognize that the property state field contains in fact geographic information about states?

Data tab > select Property State > click down arrow> Geographic Role > click State/Province

Tableau allows you to create a visualization based on three or more link tables so you can analyze your data.

TRUE

The Show Me button on the toolbar allows you to create a horizontal or vertical bar charts for your visualization sheet.

TRUE

To make an image clickable in your dashboard, right-click the image and select Set URL, insert the URL info and click OK

TRUE

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.

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

How can you find the controls to change the size of the screen using a range of fixed sizes in Tableau?

Click the second controls down arrow.