Tableau TCC-C01 Practice Test - Questions Answers, Page 4

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.

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.

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.

From the desktop, open the CC workbook. Use the US Population Estimates data source.

You need to shape the data in US Population Estimates by using Tableau Desktop. The data must be formatted as shown in the following table.

Open the Population worksheet. Enter the total number of records contained in the data set into the Total Records parameter.

From the File menu in Tableau Desktop, click Save.

From the desktop, open the CC workbook.

Open the City Pareto worksheet.

You need to complete the Pareto chart to show the percentage of sales compared to the percentage of cities. The chart must show references lines to visualize how the data compares to the Pareto principle.

From the File menu in Tableau Desktop, click Save.

Refer to the exhibit.

From the desktop, open the NYC Property Transactions workbook.

You need to record the performance of the Property Transactions dashboard in the NYC Property Transactions.twbx workbook. Ensure that you start the recording as soon as you open the workbook. Open the Property

Transactions dashboard, reset the filters on the dashboard to show all values, and stop the recording. Save the recording in

C:\CC\Data\.

Create a new worksheet in the performance recording. In the worksheet,

create a bar chart to show the elapsed time of each command name by worksheet, to show how each sheet in the Property Transactions dashboard contributes to the overall load time.

From the File menu in Tableau Desktop,

click Save. Save the performance recording in C:\CC\Data\.

A consultant migrated a data source to improve performance. The consultant wants to identify which workbooks need to be updated to point to the new data source.

Which Tableau tool should the consultant use?

A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data provided below.

Which set of charts should the consultant use to meet the client's requirements?

A client requests a published Tableau data source that is connected to SQL Server. The client needs to leverage the multiple tables option to create an extract. The extract will include partial data from the SQL Server data source.

Which action will reduce the amount of data in the extract?