Salesforce Analytics-Con-301 Exam Dumps - Actual Questions Answers

To add a line showing the cumulative percentage of sales contributed by each product to the incremental sales in the Incremental worksheet of your Tableau Desktop, follow these detailed steps:

Open the CC Workbook and Access the Worksheet:

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the Incremental worksheet by clicking on its tab at the bottom of the window.

Calculate Cumulative Sales Percentage:

Create a new calculated field to compute the cumulative percentage of sales. Right-click in the Data pane and select 'Create Calculated Field'.

Name this field "Cumulative Sales Percentage".

Enter the following formula to calculate the running sum of sales as a percentage of the total sales:

(RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) [Sales]))

Click 'OK' to save the calculated field.

Add the Cumulative Sales Percentage Line to the Chart:

Drag the "Cumulative Sales Percentage" field to the Rows shelf, placing it next to the existing Sales measure.

Ensure that the cumulative line appears as a continuous line. Right-click on the "Cumulative Sales Percentage" field on the Rows shelf, select 'Change Chart Type', and choose 'Line'.

Adjust the axis to synchronize or dual-axis if necessary. Right-click on the axis of the "Cumulative Sales Percentage" and select 'Synchronize Axis' if it's on a dual-axis setup.

Format the Cumulative Sales Percentage Line:

Click on the "Cumulative Sales Percentage" line in the visualization.

Navigate to the 'Format' pane to adjust the line style, thickness, and color to make it distinct from other data in the chart.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps:

Open the CC Workbook and Access the Worksheet:

Double-click on the CC workbook from the desktop to open it in Tableau Desktop.

Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window.

Modify the Percent Contribution Calculated Field:

Navigate to the Data pane and find the "Percent Contribution" calculated field.

Right-click on the "Percent Contribution" field and select 'Edit'.

Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer:

{FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])}

This formula uses {FIXED [Manufacturer]: SUM([Quantity])} to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity {SUM([Quantity])} calculates the grand total across all manufacturers. The division calculates the percentage contribution.

Click 'OK' to save the updated calculated field.

Enter Percentage for Newell:

With the updated "Percent Contribution" field, drag it onto the view to update the chart or table.

Identify the value corresponding to 'Newell' in the updated visualization.

Round this value to the nearest hundredth of a percent as required.

Enter this value into the "Newell % Contribution" parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose 'Edit'. Enter the calculated percentage for Newell.

Save Your Changes:

From the File menu, click 'Save' to store all the modifications you have made to the workbook.

To shape the data in the "US Population Estimates" data source and enter the total number of records into the "Total Records" parameter in Tableau Desktop, follow these steps:

Open the CC Workbook and Access the Worksheet:

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the Population worksheet by selecting its tab at the bottom of the window.

Format and Shape the Data:

Ensure the data types match those specified in the requirements: Sex, Origin, Race as strings; Year, Age, Population as whole numbers.

To verify or change the data type, click on the dropdown arrow next to each field name in the Data pane and select "Change Data Type" if necessary.

Calculate Total Number of Records:

Create a new calculated field named "Total Records". To do this, right-click in the Data pane and select "Create Calculated Field".

Enter the formula COUNT([Record ID]) or SUM([Number of Records]) depending on how the data source identifies each row uniquely.

Drag this new calculated field onto the worksheet to display the total number of records.

Enter the Value into the Total Records Parameter:

Locate the "Total Records" parameter in the Data pane. Right-click on the parameter and select "Edit".

Manually enter the number displayed from the calculated field into the parameter, ensuring accuracy to meet the data shaping requirement.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.