Tableau Cert prep

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

AND

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

.pptx

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

20200429

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

4 --The remainder of 10 divided by 6 is 4, and its absolute value remains 4.

Which function finds the average of values in a visualization?

AVG

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

Add a second calculation

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

What can prevent distance measurements from appearing on your map when you use the radial selection tool?

All of the listed factors can prevent distance measurements from appearing

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

Which sorting options are available on the toolbar?

Ascending and Descending

When might it not be a good idea to create a treemap visualization?

Avoid treemaps when your data has many subcategories and the regions are too small to be read easily.

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

Both allow for element resizing.

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

CEILING

If you want to create a selection filter that only displays three values out of the twenty available, how could you start the process in the Filter dialog to minimize the number of actions you must perform?

Click None to remove all check marks.

How can you add a worksheet element to change the value of a parameter?

Click the parameter's down arrow and then click Show Control.

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.

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

Ctrl+M

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

Ctrl+S

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

Data Interpreter

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

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

How do you remove clusters from your scatter chart?

Drag the Clusters pill off of the Marks card

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

Drag the sheet tab to a different location.

Which Tableau keyword makes a level of detail expression ignore a field even if it is part of a visualization's outline?

EXCLUDE

What is the keyboard shortcut to revert a file to its last saved state?

F12 reverts the file to its last saved state

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

F7

Which keyboard shortcut will take you into presentation mode?

F7

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

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 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.

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.

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 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.

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.

Which type of join is created when two files are combined by a field that they have in common?

Inner

What fields are generated when Tableau identifies geographic data in a workbook?

Latitude and Longitude

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

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.

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

Open Help

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

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

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

Parameter

Which distribution would you use for the vertical axis of a chart when lower values are more important than higher values?

Reversed

How do you add a text box to a chart?

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

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

Right-click the vertical axis.

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

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.

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

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.

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.

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

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

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

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)

What information about your data source does Tableau display when you view the underlying data?

Tableau displays the source file, table structure, and a data sample

In which version of Tableau is splitting text not available?

Tableau public

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

What does the % operator do in a calculation?

The % operator has Tableau perform modular division, which returns the remainder.

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

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 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 know which visualization types are available for your data set?

They are highlighted on the Show Me panel.

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

Toolbar > Show Me button > select pie chart

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.

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.

What can you customize in the summary card?

You can select which items will appear

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

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

adding a category for the color mark

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 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

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

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

How do tree maps indicate value?

by shades of color

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

How do histograms summarize data?

by using a vertical bar chart

Column and stacked column charts are best used for _____ data.

categorical

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

Which default format would you use to represent sales totals in your country's currency

currency standard

Creating separate legends allows you to

distinguish between your data values

If you open the Worksheet menu, point to Clear, and then click Sheet, what does Tableau remove from your worksheet's visualization?

everything except the connection to the data source Tableau removes all elements from the worksheet but keeps the connection to the data source.

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

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

isolate

What do darker colors represent in a highlight table with built-in coloring?

larger values

Which built-in function finds the middle value in a list that has been sorted into either ascending or descending order?

median

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

Attempting a quick replacement of sheet A with sheet B will

place sheet B in sheet A's location

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

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

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 combining two sets, which combining option results in an intersection between sets?

shared members in both sets

Which Tableau interface object do you click to display the available visualization types for a data set?

show me

If you create a line chart, which interface element would you use to make the line thicker?

size card

To find the percentage a value contributes to the sum of all values in a visualization, create a table calculation that summarizes by _____.

table

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

the Analysis menu

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

the Condition tab There are four tabs in the dialog box in Tableau Desktop, and the Condition tab is used to define rules to filter by.

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

Area fill charts enhance a visualization by showing

the contribution of one or more categories to a total over time

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

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

to build formula-based filters to focus the data

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

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 Calculated fields can only be used locally within their worksheet.

When are scatter plots typically used?

when you have two numerical measures

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