.

Explanation:

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.

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

To add a column that shows the day of the week for each row, you should complete the formula as

follows:

DATENAME

(

‘weekday’

, [Order Date])

The DATENAME function in Tableau returns the name of a specified part of a date or datetime value,

such as the year, month, or day. It takes two arguments: the date part and the date. In this question,

you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each

order date. Therefore, you need to use ‘weekday’ as the date part and [Order Date] as the date. The

formula will return a string value that represents the name of the weekday for each order date.

Reference:

Tableau Help: DATENAME Function

Tableau Help: Date Functions

To add a column that shows the day of the week for each row, you should complete the formula as

follows:

DATENAME

(

‘weekday’

, [Order Date])

The DATENAME function in Tableau returns the name of a specified part of a date or datetime value,

such as the year, month, or day. It takes two arguments: the date part and the date. In this question,

you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each

order date. Therefore, you need to use ‘weekday’ as the date part and [Order Date] as the date. The

formula will return a string value that represents the name of the weekday for each order date.

Reference:

Tableau Help: DATENAME Function

Tableau Help: Date Functions

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_72_img_2.jpg

To add two sheets to the dashboard that support the Show/Hide button, you can add them to either

a horizontal or a vertical container. A container is an object that can hold one or more sheets or other

objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide

or show a container and its contents on the dashboard. You can add a Show/Hide button to any

container, whether it is tiled or floating, by using the drop-down menu of the container and selecting

“Add Show/Hide Button.” You can also customize the appearance and behavior of the button.

To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects

pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a

vertical container will arrange them vertically. You can then drag the sheets you want to add from the

Sheets pane to the container. You can resize and reorder the sheets or objects within the container by

using the handles and arrows.

The other objects in the Answer Area, such as text, image, web page, blank, navigation, download,

and extension, do not support the Show/Hide button. They are either static elements that cannot

hold other objects, or dynamic elements that require user interaction or external sources. You can

add them to the dashboard as well, but they will not have the same functionality as a container with

a Show/Hide button.

Reference:

Add Show/Hide Buttons - Tableau

Layout Containers - Tableau

.

Explanation:

To modify the bar chart to show the percentage of sales for each Subcategory within every Category,

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

CategoryPercentage worksheet.

Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will

see a bar chart that shows the total sales for each Subcategory across all Categories.

Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will

open a dialog box that allows you to apply a calculation to your measure.

Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of

sales for each Subcategory out of the total sales for all Subcategories.

Select Category from the Compute Using drop-down list. This will calculate the percentage of sales

for each Subcategory within every Category, instead of across all Categories. The total percentage for

every Category will be 100%.

Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of

sales for each Subcategory within every Category.

Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm

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

https://help.tableau.com/current/pro/desktop/enus/calculations_tablecalculations_percentoftotal.htm

To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text

file in Tableau Desktop. This option will allow you to browse and select the file from your local or

network drive and connect to it as a data source. You can then specify the text file properties, such as

the delimiter, the text qualifier, and whether the first row contains column names. You can also join,

union, or blend the data with other data sources if needed. Reference:

Text File - Tableau

Tableau Certified Data Analyst Study Guide

To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which

returns the unique rank of each value in a partition. You need to specify the expression as

SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as

descending, which means that the highest sales will have the lowest rank. Finally, you need to

specify the restart as every [Category], which means that the ranking will reset for each category.

Reference: https://help.tableau.com/current/pro/desktop/enus/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro/desktop/en-

us/calculations_calculatedfields_lod_rank.htm

The object that you should add to the dashboard to allow users to switch to a different dashboard in

the workbook is Navigation.

Navigation objects are used to create links between dashboards or sheets in a workbook. You can

add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the

dashboard. You can then configure the navigation object to specify the destination dashboard or

sheet that you want users to navigate to when they click on it.

You can learn more about navigation objects and how to use them in this article:

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

To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and [Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.

Finding the Month-to-Date Values for the Prior Year [DATEADD Function] [DATETRUNC Function]

The first action is to connect to both data sources from the connections pane in Tableau Prep. The connections pane is where you can access and add data sources to your flow. You can connect to various types of data sources, such as Excel, SQL Server, or Tableau Server. In this case, you want to connect to an Excel worksheet and a SQL Server table. The second action is to join both datasets and select the join type. A join is a way of combining data from two or more tables based on a common field. You can join datasets by dragging one table to the canvas and dropping it on top of another table. This will create a join step in your flow. You can select the join type from the drop-down list on the join step. The join type determines which rows are returned from the tables. The third action is to specify Employee Name as the join key. A join key is a field that is used to match rows from different tables. You can specify the join key by clicking on the field name in each table and dragging it to the center of the join step. This will create a join clause that shows the field name and the operator. In this case, you want to use Employee Name as the join key, because it is a common field between the two datasets. The other options are not relevant for this scenario. Specifying Department and Team Size as a join condition will not work, because they are not common fields between the two datasets. Opening both data sources in Tableau Desktop will not help you join them in Tableau Prep. Adding a step to aggregate the data in the SQL Server table will not affect the join, but it may change the level of detail of your dat a.

https://help.tableau.com/current/prep/en-us/prep_connect.htm https://help.tableau.com/current/prep/en-us/prep_join.htm https://help.tableau.com/current/prep/en-us/prep_join_types.htm

The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default. The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month. The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card. The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.

https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro/desktop/enus/functions_functions_statistical.htm#MODEL_QUANTILE