A. Create a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.

Answer DescriptionExplanation:
To modify the chart to show only min and max values of both measures in each region, you need to do the following steps:

• Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Line worksheet.
• Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.
• Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.
• Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.
• Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.
• Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.

References:

https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_range.htm

Answer DescriptionExplanation:

To create a filled map to show the distribution of total Sales by State across the United States, you need to do the following steps:

• Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
• Click on the Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
• Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
• Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
• Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.

References:

https://help.tableau.com/current/pro/desktop/en-us/maps.htm
https://help.tableau.com/current/pro/desktop/en-us/maps_howto_filled.htm
https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_color.htm

A. Page Setup

D. Condition filter

Answer DescriptionExplanation:

To use the City dimension to create a dynamic filter that shows the cities that have a population greater than one million, you should use a condition filter. A condition filter is a type of filter that shows only the values that meet a specified condition based on a measure or a calculation. You can create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the dialog box. Then you can enter a formula or choose an option that defines your condition.

In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.

The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as “New*” or “*ton”. A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation.

References:

https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm

D.

Answer DescriptionExplanation:

To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box. References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm

To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the 'Region' field to the 'Tooltip' shelf on the 'Marks' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.

B. From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh

Answer DescriptionExplanation:

To refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules.

References:

https://help.tableau.com/current/server/en-us/refresh_extracts.htm
https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

On Tableau Server, you can manage the scheduling of extract refreshes by selecting the specific workbook and configuring additional refresh schedules as needed. This allows for multiple refresh triggers, such as the regular Monday at 10:00 AM schedule, as well as an additional trigger for the last day of the month at 18:00.

D. 3

Answer DescriptionExplanation:

The LAST() function in Tableau returns the number of rows from the current row to the last row in the partition. When you compute using 'Order Date', it will change the partitioning of the calculation. If 'Consumer' in '2018' is the last row in its partition when computed by 'Order Date', then LAST() will return 0 for that cell.

The LAST() function in Tableau is a table calculation that returns the number of rows from the current row to the last row in the partition. The value of LAST() is 0 for the last row, increases by 1 for each row above the last row, and can be negative for rows below the current row if there are such rows in the partition.

In the provided visualization, LAST() is set to compute using Table (across). Changing the compute mode to use "Order Date" will adjust the partitioning of the data upon which the LAST() function is calculated. Since "Order Date" is likely to be a unique value per row (assuming each order has a unique date), each row becomes its own partition.

For the Consumer segment of the year 2018, if "Order Date" is unique for each row, then the last row in each partition (in this case, each individual row) will have a LAST() value of 0 because there are no other rows in the partition - it's the last row of its own partition.

Therefore, when you change the compute mode of LAST() to use "Order Date", each cell under the Consumer segment for the year 2018 will have the LAST() value of 0, because each order date creates a partition of one, making every row the last in its partition.