Sure Pass Exam TDA-C01 PDF

To filter the table to show the Top 10 NOC based on the number of medals won, 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 Disciplines worksheet.
• Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the NOC, discipline, and medals for each country.
• Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
• Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
• Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
• Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
• Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.

References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.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 create a histogram on the Quantity field by using bin size of 3, 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 Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
• Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
• Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
• Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a # sign next to it.
• Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
• Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.

References: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm