Tableau Essential Training—LinkedIn

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

.pptx Select .pptx because it is the most recent version of PowerPoint

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

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

Data pivoting

A data analysis technique that rearranges rows into columns, usually aggregating multiple values into a single cell

Treemap

A data visualization format that displays hierarchical data and quantities, using nested rectangles

Histogram

A data visualization format that uses bars to represent the number of items found in every range

Calculated field

A new field created from existing data, using custom calculations

Unified Resource Locator (URL)

A reference or hyperlink to a web resource

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

A scatter plot A scatter plot presents many distinct data points on a single chart, and can be enhanced with analytics such as cluster analysis

Scatter plot

A type of chart used for visualizing the correlation between two variables

Responsive design

A visual design approach that assures proper content rendering on different screen sizes

What does displaying a visualization in a tooltip show?

A visual subset of another worksheet A visualization in a tooltip allows you to show the relevant, filtered subset of another worksheet

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

AND The AND logical operator is used when you want both conditions to be true

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 A second calculation must be added to display both the average and the sum at the same time

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

Adding a category for the color mark Stacked column charts are created by sectioning a column, using a color mark based on a category

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 The "other" group will automatically include everything not currently in a group

Which action can you perform on a color legend?

All of these answers A color legend can have its color changed, it can be reordered, and it can be hidden

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

All of these answers Monitor resolution Distance between points Map zoom level

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 Because the percentage of each item is calculated from the table, all table items will add up to 100%

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

An inner join When you use an inner join to combine tables, the result is a table containing values that have matches in both tables

How do pie charts display your data?

As several parts contributing to a total You can often gain important insights into your data by creating a pie chart that displays the contribution of several parts to a total

Which sorting options are available on the toolbar?

Ascending and Descending There are toolbar buttons for Ascending and Descending sorts

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 An automatic range excluding the zero will focus on the relevant data, and emphasize differences

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 Data sets that have many subcategories can make a treemap hard to understand

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

Banana The value "banana" does not contain "ap."

How do you connect to a data file?

By going to the navigation bar, and then selecting the type of file you want In the navigation bar's connect section, picking the type of file to connect to and identifying it in your system connects your data file

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

By identifying the fields that each sheet has in common By identifying the tables manually, you can create the join and then create your visualization

How do tree maps indicate value?

By shades of color Darker shades generally mean larger values, and lighter shades generally mean smaller values

How can you identify a field with a geographic role?

By the globe symbol next to the field name Resembling a stylized globe, symbols next to the field name allow you to identify a field with a geographic role

How do histograms summarize data?

By using a vertical bar chart Histograms summarize data with a vertical bar chart, where each bar represents counter data points that occur within a given value range

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

Categorical Column and stacked charts are best for summarizing categorical data

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 Using the parameter's down arrow and clicking Show Control displays a card that lets you change the parameter value

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 If you want to select from a range of fixed sizes, select the second controls down arrow for set options

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

Ctrl+M Ctrl+M is the Windows shortcut for creating a new worksheet

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

Ctrl+S Ctrl+S is the Windows shortcut for saving a file

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 LODs are a special type of calculation in Tableau that must include curly brackets

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

Currency (Standard) Currency (Standard) displays values in the currency associated with your computer's regional settings

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

Data Interpreter tool If Tableau detects unique formatting or extra information after you set up the data source, the Data Interpreter option becomes available

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

Data Layers

How do you remove clusters from your scatter chart?

Drag the Clusters pill off of the Marks card Dragging the Clusters pill off the Marks card will delete clusters from your chart

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

Drag the sheet tab to a different location For example, if you want to move Sheet 2 to the right of Sheet 3, select Sheet 2 and drag it to the right of Sheet 3

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

EXCLUDE The EXCLUDE keyword makes a level of detail expression ignore a field even if it is part of a visualization's outline

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

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

F12 F12 reverts the file to its last saved state

Which keyboard shortcut will take you into presentation mode?

F7 You can either select F7 for presentation mode, or you can go to the toolbar and select the Presentation Mode button

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 Since the parameter defines the top limit, reducing it will reduce the number of items shown

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 To unhide the Filters and Marks cards, go to Worksheet, point to Show Cards, and then select Reset Cards

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

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

In columns Your data set is organized into columns, which are also called fields

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

In descending order Sorting in descending order will sort from high to low, placing the highest values on top

How can you start the process of renaming a set?

In the Side Bar, right-click the set pill you want to rename Right-clicking on the set pill that you want to rename will open a box to edit the text

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 Tableau Viewer can be downloaded for free, and allows those who do not have the full version of Tableau to view your visualization

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

What does the % operator do in a calculation?

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

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

Larger values Zero is pure white and as the numbers or values increase, so does the intensity or depth of color

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

Latitude and Longitude Tableau generates latitude and longitude values for geographic data it recognizes

Which dashboard element can also let you highlight values in a dashboard?

Legend A legend on a dashboard can also let you highlight values on the dashboard

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

MEDIAN MEDIAN finds the middle value in a list that has been sorted into either ascending or descending order

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 Selecting Measure will allow you to change the summary operation to other calculations, such as Average and Median

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 To add an annotation to a specific part of a visualization, move your mouse pointer over that part and right-click for annotation options

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

Moving side to side without changing resolution To pan within a map, point to the right-pointing arrow, select the Pan tool, and then click and drag to change the focus of the map

Can you disable map panning but keep map zooming enabled?

No Panning and zooming are enabled or disabled together

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 You can define a parameter to select values used to control a filter

Attempting a quick replacement of sheet A with sheet B will `_____`

Place sheet B in sheet A's location Quick replacement of sheets removes a sheet, and adds another sheet in its place

Which term refers to data divided into four segments?

Quartiles The term quartiles refers to data divided into four segments

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

Reversed The Reversed distribution places lower values at the top of the vertical axis

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

Right-click the vertical axis Reference lines are created, edited, and deleted by right-clicking the vertical axis and following the shortcut menu options

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 There is now a Swap Sheets button that allows you to replace sheets without deleting them in the dashboard

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

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

Shared members in both sets Limiting to members that appear in both sets is an intersection of the sets

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

Show Me The Show Me button displays (or hides) the available visualization types

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

Size card Clicking the line and then the Size card will display a slider you can use to change the thickness of the line

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 Sorting by the length of the dimension text is not on option you can use for sorting

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

Table Table calculates the percentage a value contributes to the sum of all values in a table

Which version of Tableau is used in this course?

Tableau Desktop

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

Tableau Prep Tableau Prep is used to prepare the data and clean it

In which version of Tableau is splitting text not available?

Tableau Public

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

Tableau bookmark (.tbm) This file type allows you to access another workbook within a file, so you do not need to recreate the visualization in the current file

What happens when you delete a parameter that is used in a filter?

Tableau warns you the parameter is in use, then indicates the filter is no longer valid Tableau does let you know deleting the parameter will affect the worksheet and then confirms the effect it had

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

The Analysis menu To create a calculated field, you will first go to the Analysis menu and select Create Calculated Field

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

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

The Sort By feature In the drop-down menu next to the Sort By feature, you need to select Nested to create a nested sort

Area fill charts enhance a visualization by showing _____.

The contribution of one or more categories to a total over time Area fill charts show how categories of data contribute to a total over time

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 When you switch from the active worksheet (the worksheet you changed to green) to another worksheet, the first worksheet remains green

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 The field at the bottom is the one with the minimum value, and its record will be the one shown

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

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

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 Nothing was changed on the dashboard since last save, so there is no worksheet to revert to

How do you know which visualization types are available for your data set?

They are highlighted on the Show Me panel Available visualization types are highlighted on the Show Me panel

What are line charts best used for in Tableau?

To analyze trends of time that data sets reveal Line charts are used to represent multiple data points connected together with a single line, and analyze trends that data sets reveal

What are Tableau stories used for?

To convey a persuasive narrative about the user's insights Tableau stories are used to present a predefined narrative that leads to a conclusion

Why would you create a selection filter?

To limit the data that appears in your worksheet to chosen values Limiting the data that appears in your worksheet is a reason to create a selection filter

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 The Tableau.com support page shows drivers that are available to you

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 The Radial tool marks in a circular area, and can be used to measure distance in a map view

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 Scatter plots are typically used to visualize two measure values, or similar field values, as a single dot on a graph

When is saving your workbook as a PDF file beneficial?

When you want to send your documents but not have any interaction PDF is the portable document format

Would a wildcard filter find the characters "west" in the data set NORTHWEST?

Yes A wildcard filter is not case sensitive so it will find the "west" in NORTHWEST

Can you add all subtotals to data with sets?

Yes; the subtotals will show the total of every set Subtotals for a set will add all items under it

What can you customize in the summary card?

You can select which items will appear The summary card allows you to select which items are shown