tableau part 2

How can you remove an element from a group?

right-click to the group field in data pane, click to edit and unselect the element

What does Tableau do if you drop a date field into the filter shelf? A. Asks for a selection between discrete or continuous B. automatically filters the date for the current date C. asks for a date to filter D. creates a range for all available days

A. Asks for a selection between discrete or continuous

Select all correct statements A. Changing the order of elements in color legend is a type of manual sort B. you can use a field for sorting even if that field is not in the current view C. You can set a default sort order for the values within a categorical field D. aliases are like alternative names for the members in a dimension

All are correct

A dimension is a field that typically holds Select one: a. numerical data b. discrete qualitative data

B. discrete qualitative data

Select all correct statements A. Groups have In/Out feature B. Once you group the elements, you cannot ungroup C. You can create combined groups D. You can't edit a statics set because static sets are fixed E. You can create dynamic groups and sets F. Sets are more advanced than groups

F. Sets are more advanced than groups

Which of the following is true? a. A dashboard cannot include a story, but a story can include a dashboard b. A dashboard can include a story, but a story cannot include a dashboard c. A dashboard can include a story, and a story can include a dashboard d. A dashboard cannot include a story, and a story cannot include a dashboard

a. A dashboard cannot include a story, but a story can include a dashboard

Which of the following will increase the granularity of the view? a. Adding a dimension to the marks area b. Adding a measure to the marks area c. Adding a dimension as a filter d. Adding a measures as a filter

a. Adding a dimension to the marks area

A histogram must include which of the following? (select all that Apply) a. Bin b. Dimension c. Count d. Count Distinct

a. Bin c. Count

Which of the following will create a dashboard action? a. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter" b. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "Filter" and the field you wish to use in the filter action c. Right-click on a header value shown in the worksheet in the dashboard layout and select "exclude" or "keep only" d. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "action," add action, and Filter

a. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter"

Which type of filter usually works best with date fields? a. Slider filters b. List filters c. Checkboxes d. Text search

a. Slider filters

Which file type can include an extract? Select all that apply. a. Data Source (.tds) b. Packaged Data Source (.tdsx) c. Packaged Workbooks (.twbx) d. Workbooks (.twb)

b. Packaged Data Source (.tdsx) c. Packaged Workbooks (.twbx)

Which visualization always represents a measure using color? a. Pie chart b. Scatter plot c. Combo chart d. Highlight table

d. Highlight table

Which of the following is most likely to reduce the size of the extract? a. Selecting "Multiple Table" rather than "Single Tables" b. Using the incremental refresh option c. Materialize calculations with the "Compute Calculations Now" option d. Removing an filter

a. Selecting "Multiple Table" rather than "Single Tables"

Which of the following is the best reason to use an extract instead of a live connection? Select one: a. You need to apply an aggregation that takes too long when using a live connection b. Your data source only supports a live connection via ODBC c. You need to join tables that are in the data source d. You need the freshest possible data at all times

a. You need to apply an aggregation that takes too long when using a live connection

How would you change the font color of the tooltip? (Select all that apply) a. Click on "color" in the marks area, select "tooltip" in the dropdown, and select the desired color. b. Right-click on the view, select "Format" and select the dropdown next to tooltip. Then select the color. c. Click on the tooltip button in the Marks area, highlight the text, and select the desired color using the dropdown d. Right-click on the view, select "Format" and you will see several tabs in the formatting menu - "Sheets," "Rows," Columns" and "Tooltip." Select the tootip tab and then use the formatting menu to select the color.

b. Right-click on the view, select "Format" and select the dropdown next to tooltip. Then select the color. c. Click on the tooltip button in the Marks area, highlight the text, and select the desired color using the dropdown

Your view has a numeric field set as a discrete measure and a dimension. Which of the following visualizations can you create with these fields? (select all that apply) a. Line chart b. Text tables c. Highlight table d. Histogram

b. Text tables

A relative date filter works relative to: a. A parameter or field you select when creating the filter b. The anchor date c. The data the workbook was created or updated d. The current date when the workbook is viewed

b. The anchor date

For which of the following is it not possible to adjust the size of the marks? a. Bar chart b. Tree map c. Pie chart d. Heat maps

b. Tree map

Which of the following describes the Measure Names field (select all that apply) a. It is a Measure automatically created by Tableau b. When you create a view with multiple measures on a single continuous axis, Tableau will automatically add Measure Names to the view. c. When you add Measure Names to a view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a text table that shows multiple measures. d. Measure Names is a system-generated field that contains the names of all the measures in your Tableau workbook, including the system-generated measures such as Latitude and Longitude.

b. When you create a view with multiple measures on a single continuous axis, Tableau will automatically add Measure Names to the view. c. When you add Measure Names to a view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a text table that shows multiple measures.

Which of the following is an example of metadata that can be managed in Tableau? Select all that apply. a. The data type of the data in the source database b. Which fields are hidden c. The number of rows in the data d. The default aggregation for a field

b. Which fields are hidden d. The default aggregation for a field

Which of the following can you use to create a calculated field that returns data independent of the data granularity in a view? Select one: a. An INCLUDE LOD calculation b. A basic calculation c. A FIXED LOD calculation d. A table calculation

c. A FIXED LOD calculation

Your view has a histogram showing the distribution of Sales. You'd like to use a color gradient to shade the bars according to the value of Profit. You drag profit to the color mark. How would you adjust the colors so that all negative values are shown in one color and all positive values are shown in a second color? a. Click the colors mark, select edit colors, and check center on zero and switch the dropdown from continuous to discrete color gradient. b. Click on the quantitative legend and select format legend. Select a diverging palette and stepped color. c. Click the arrow on the colors mark, select edit colors, select a diverging palette from the dropdown and check stepped color with 2 steps and check center on zero. d. Click the colors mark, switch to a palette with two colors and check discrete color.

c. Click the arrow on the colors mark, select edit colors, select a diverging palette from the dropdown and check stepped color with 2 steps and check center on zero.

You would like the person using your dashboard to select the year, and based on the year to adjust the interest rate in some related calculated fields. You will like the year selection to limit the data in the view. What Tableau element should you to let the user select the interest rate? a. Dimension Filter b. Context Filter c. Parameter d. Change Set values Dashboard Action

c. Parameter

You would like to divide your customers into two categories - those with sales above a certain threshold and those with sales below that threshold. Which of the following tools will allow you to do this? Select all that apply. a. Hierarchy b. Parameter c. Set d. Calculation

c. Set d. Calculation

Your data has a column which should be treated as a date, but when you change the data type to date you see a lot of null values or obviously incorrect dates like 12/30/1899. What can you do next since the date conversion did not work? a. Edit your computer's date settings to that they correspond to the format of the date you're trying to use in Tableau b. Instead of setting the field to Date, set to Date & Time c. Set the type back to string, then try date conversion functions like DateParse and Date d. Switch the metadata grid, then right click the field and select "date format settings"

c. Set the type back to string, then try date conversion functions like DateParse and Date

You connect Tableau to an Excel file which includes a column that has mostly numeric data, but has a few date and text values mixed in. Tableau set the data type for this field as Number. What happens to the date and text values when the data is imported to Tableau? a. The date and text values are both set to null b. The date and text values are both set to zero c. The date values are set to the number of days since 1/1/1900 and the text value is set to null. d. The date values are set to the number of days since 1/1/1900 and the text value is set to zero.

c. The date values are set to the number of days since 1/1/1900 and the text value is set to null.

You add two fields to your Tableau view, "Profit" and "Average Profit." When you add Profit to the view, you see a pill with the label, "SUM(Profit)" but when you add Average Profit to the view, you see a pill with the label, "AGG(Average Profit)." Why does one field have SUM and another AGG? a. Each field has default properties, including default aggregation. Profit had SUM set as its default aggregation, while Average Profit had AGG set as its default. b. AGG is applied by default to discrete fields, while SUM is applied to continuous fields. Average Profit was set to discrete, while Profit was set to continuous. c. AGG is applied by default to dimensions, while SUM is applied to measures. Average Profit is a dimension, while Profit is a measure. d. AGG indicates that the "Average Profit" already includes some type of aggregation. "Profit" does not include aggregation, so an aggregate function is applied when the field is added to the view.

d. AGG indicates that the "Average Profit" already includes some type of aggregation. "Profit" does not include aggregation, so an aggregate function is applied when the field is added to the view.

You want to create a dual axis chart showing the monthly average "Open" and "Close" values for a stock. The y-axis shows the opening stock price and the x-axis shows the date. What steps should you take? a. Drag and drop the field "Close" to the x-axis. b. Drag and drop the field "Close" to the y-axis. c. Drag the field "Close" to the path mark. d. Drag the field "Close" to the row shelf, then select dual lines on the show me menu.

d. Drag the field "Close" to the row shelf, then select dual lines on the show me menu.

10. Which type of visualization is not typically effective in showing change over time? a. Bar Chart b. Line Chart c. Area Chart d. Scatter Plot

d. Scatter Plot

A line chart is broken into separate sections by year. What does this indicate about the date used in the line chart? a. The date is a continuous dimension b. The date is a continuous measure c. The date is a discrete measure d. The date is a discrete dimension

d. The date is a discrete dimension

Editing the font at the worksheet level applies the changes you make to all text fields in view except for which of the following? (select all that apply) a. Header b. Axis c. Caption d. Tooltip

d. Tooltip

Which of the following is not a default property which can be set for a measure? a. Number Format b. Color c. Aggregation d. Sort

d. sort