Tableau TDA-C01 Dumps

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

To add a distribution band on Profit to show the standard deviation from -1 to 1, 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 SalesVSProfit worksheet.
• Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category.
• Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
• Drag Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category.
• Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band.
• Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average.
• Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit.

References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband_edit.htm

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.

References: 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/en-us/calculations_tablecalculations_percentoftotal.htm