Analytics-DA-201 Exam Dumps - Salesforce Tableau Data Analyst Questions and Answers

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.

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

Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.

In Tableau dashboards, floating elements are those that can be freely moved over the dashboard canvas without being snapped into the tiled layout. The floating elements are often indicated by their standalone frames and the ability to overlap with other dashboard items. From the provided image, the state filter and the Rate of Obesity chart can be identified as floating if they can be moved independently of the tiled grid layout that constrains other elements.

To ensure that the data is updated every hour, you need to select Extract Refreshes from the data source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an existing one. You can specify the frequency and time of the refresh, as well as any custom options or credentials. New will create a new data source, Connected Workbooks will show you which workbooks use this data source, and Connections will show you which tables or files are connected to this data source. References: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

To ensure that the data is updated every hour on Tableau Server, you would need to go to the " Extract Refreshes " option. Here, you can schedule the data extracts to refresh at the desired frequency, which in this case would be every hour.