QUESTION: 25 Exam Topic: 1, Knowledge-Based Section A

A client is using the Tableau Content Migration Tool to move content from an old Tableau Server to a new Tableau Server.

Which content will need to be moved using a different tool or process?

Published data sources that use live connections
Tableau Prep flows
Published data sources that use extracts
Workbooks

Answer(s): B

Explanation:

When migrating content between Tableau servers, certain types of content may require special consideration or different tools for migration:
Tableau Prep Flows: These are specific to Tableau Prep and are not included in the standard content migration capabilities of the Tableau Content Migration Tool. Tableau Prep flows often require separate processes for migration due to their distinct setup and integration with data sources and workflows.
Published Data Sources and Workbooks: These can typically be migrated directly using the Tableau Content Migration Tool, which supports moving published data sources (both live connections and extracts) and workbooks without requiring additional tools.

Reference:

Tableau Help and Support: Offers comprehensive tutorials and guidelines on using different tools for migrating various types of content, including the specific requirements for migrating Tableau Prep flows which are not covered by the standard content migration tool.

Reveal Solution Next Question

QUESTION: 26 Exam Topic: 2, hands-on labLab Section

Use the following login credentials to sign in to the virtual machine:

Username: Admin
Password:

The following information is for technical support purposes only:
Lab Instance: 40201223

To access Tableau Help, you can open the
Help.pdf file on the desktop.

From the desktop, open the CC workbook.
Open the Categorical Sales worksheet.

You need to use table calculations to compute the following:

. For each category and year, calculate the average sales by segment.
. Create another calculation to compute the year-over-year percentage change of the average sales by category calculation. Replace the original measure with the year-
over-year percentage change in the crosstab.

From the File menu in Tableau Desktop, click
Save.

See Explanation section for answer.

Answer(s): A

Explanation:

To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:
Compute Average Sales by Segment for Each Category and Year:
Open the CC workbook and navigate to the Categorical Sales worksheet. Drag the 'Sales' field to the Rows shelf if it's not already there. Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'. Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'. This will compute the average sales for each segment within each category and year. Create a Calculation for Year-over-Year Percentage Change:
Right-click in the data pane and select 'Create Calculated Field'. Name the calculated field something descriptive, e.g., "YoY Sales Change". Enter the formula to calculate the year-over-year percentage change:
(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1)) Click 'OK' to save the calculated field.
Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:
Remove the original 'Sales' measure from the view by dragging it off the Rows shelf. Drag the newly created "YoY Sales Change" calculated field to the Rows shelf where the 'Sales' field was originally.
Format the "YoY Sales Change" field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage.
Save Your Changes:
From the File menu, click 'Save' to ensure all your changes are stored.

Reference:

Tableau Help: Offers guidance on creating calculated fields and using table calculations. Tableau Desktop User Guide: Provides instructions on formatting and saving worksheets. These steps allow you to manipulate data within Tableau effectively, using table calculations to analyze trends and changes in sales data by category and segment over years.

Reveal Solution Next Question

QUESTION: 27 Exam Topic: 2, hands-on labLab Section

From the desktop, open the CC workbook.
Open the Incremental worksheet.

You need to add a line to the chart that shows the cumulative percentage of sales contributed by each product to the incremental sales.

From the File menu in Tableau Desktop, click
Save.

See Explanation section for answer.

Answer(s): A

Explanation:

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.

Reference:

Tableau Help: Provides additional details on creating calculated fields and customizing line charts. Tableau User Guide: Offers extensive instructions on formatting charts, including line types and axis synchronization.
By following these steps, you will successfully add a cumulative sales percentage line to your chart, enhancing the visualization to reflect the incremental contribution of each product to the overall sales in a dynamic and informative manner.

Reveal Solution Next Question

QUESTION: 28 Exam Topic: 2, hands-on labLab Section

From the desktop, open the CC workbook.
Open the Manufacturers worksheet.

The Manufacturers worksheet is used to analyze the quantity of items contributed by each manufacturer.

You need to modify the Percent
Contribution calculated field to use a Level of Detail (LOD) expression that calculates the percentage contribution of each manufacturer to the total quantity.

Enter the percentage for Newell to the nearest hundredth of a percent into the
Newell % Contribution parameter.

From the File menu in Tableau Desktop, click
Save.

See Explanation section for answer.

Answer(s): A

Explanation:

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.

Reference:

Tableau Help: Offers detailed guidance on using LOD expressions for precise and context- independent aggregations.
Tableau Desktop User Guide: Provides comprehensive instructions on managing calculated fields and parameters, ensuring accurate data analysis.

By following these steps, you will have successfully updated the calculation for percent contribution using LOD expressions, providing a more accurate analysis of each manufacturer's contribution to the total quantity. Moreover, updating the parameter with Newell's specific contribution rounds out the task by reflecting precise data inputs for reporting or further analysis.

Reveal Solution Next Question

Free TCC-C01 Exam Braindumps (page: 7)

QUESTION: 25 Exam Topic: 1, Knowledge-Based Section A

Explanation:

Reference:

QUESTION: 26 Exam Topic: 2, hands-on labLab Section

Explanation:

Reference:

QUESTION: 27 Exam Topic: 2, hands-on labLab Section

Explanation:

Reference:

QUESTION: 28 Exam Topic: 2, hands-on labLab Section

Explanation:

Reference: