Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with ValidTests

Tableau Prep ' s Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.

Replace Data Source

Replace Data Source is a feature that allows you to replace one data source with another one that has the same or similar fields and structure. It updates all the worksheets that use the original data source with the new one, without reloading the data. In this case, you want to replace the data source that contains order data from 2019 with the one that contains order data from 2020.

To replace the data source, you need to do the following steps:

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 original 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 the data source that contains order data from 2020 from the list of available data sources and click OK. This will replace your original data source with the new one and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.

To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace. References:

Format Dashboards - Tableau

Tableau Certified Data Analyst Study Guide

Select

Where

The correct way to complete the query is:

SELECT * FROM [dbo] . [Students]

WHERE [Students].[City] = ‘Berlin’

The SELECT statement is used to retrieve data from a table or a view. The * symbol means that all columns will be returned. The FROM clause specifies the table or view name and the schema name.

The WHERE clause is used to filter the data based on a condition. The condition is [Students].[City] = ‘Berlin’, which means that only rows where the City column of the Students table is equal to ‘Berlin’ will be returned.

The other options are not relevant for this query. CAST is a function that converts a value from one data type to another. JOIN is a clause that combines data from two or more tables based on a common field. ON is a keyword that specifies the join condition. UNION is a set operation that combines the results of two or more queries into one result 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 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.

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 split the Customer Name field into two fields named First Name and Last Name, 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.

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 Superstore data source.

Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table.

Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name.

Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name.

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 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.