Analytics-DA-201 Dumps with Practice Exam Questions Answers

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.

To filter the table to show the members of the Top10 set and the Bottom10 set, 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 disciplines, sales, and profit for each salesperson.

Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.

Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.

Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.

Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.

To replace the existing data source with the Netflix_2019 data source, 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 Movie Durations worksheet.

Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing data source.

Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the existing data source.

Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.

Select Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.

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.

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.