Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Salesforce Consultant Analytics-Con-301 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam Analytics-Con-301 Premium Access

View all detail and faqs for the Analytics-Con-301 exam

Go to Exam

642 Students Passed

91% Average Score

96% Same Questions

Viewing page 2 out of 3 pages

Viewing questions 11-20 out of questions

Questions # 11:

Question # 11

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

Options:

Answer

Answer:

See the complete Steps below in Explanation:

Explanation

To record the performance of the Property Transactions dashboard in the NYC Property Transactions.twbx workbook and analyze it using a bar chart, follow these detailed steps:

Open the NYC Property Transactions Workbook:

From the desktop, double-click the NYC Property Transactions.twbx workbook to open it in Tableau Desktop.

Start Performance Recording:

Before doing anything else, navigate to the 'Help' menu in Tableau Desktop.

Select 'Settings and Performance', then choose 'Start Performance Recording'.

Open the Property Transactions Dashboard and Reset Filters:

Navigate to the Property Transactions dashboard within the workbook.

Reset all filters to show all values. This usually involves selecting the dropdown on each filter and choosing 'All' or using a 'Reset' button if available.

Stop the Performance Recording:

Go back to the 'Help' menu.

Choose 'Settings and Performance', then select 'Stop Performance Recording'.

Tableau will automatically open a new tab displaying the performance recording results.

Save the Performance Recording:

In the performance recording results tab, go to the 'File' menu.

Click 'Save As' and navigate to the C:\CC\Data\ directory.

Save the file, ensuring it is stored in the desired location.

Create a New Worksheet for Performance Analysis:

Return to the NYC Property Transactions workbook and create a new worksheet by clicking on the 'New Worksheet' icon.

Drag the 'Command Name' field to the Columns shelf.

Drag the 'Elapsed Time' field to the Rows shelf.

Ensure that the 'Worksheet' field is also included in the analysis to break down the time by individual sheets within the dashboard.

Choose 'Bar Chart' from the 'Show Me' options to display the data as a bar chart.

Customize and Finalize the Bar Chart:

Adjust the axes and labels to clearly display the information.

Format the chart to enhance readability, applying color coding or sorting as needed to emphasize sheets with longer load times.

Save Your Work:

Once the new worksheet and the performance recording are complete, ensure all work is saved.

Navigate to the 'File' menu and click 'Save', confirming that changes are stored in the workbook.

[References:, Tableau Help Documentation: Provides guidance on how to start and stop performance recordings and analyze them., Tableau Visualization Techniques: Offers tips on creating effective bar charts for performance data., By following these steps, you have successfully recorded and analyzed the performance of the Property Transactions dashboard, providing valuable insights into how each component of the dashboard contributes to the overall load time. This analysis is crucial for optimizing dashboard performance and ensuring efficient data visualization., , , ]

Questions # 12:

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.

Options:

Answer

Answer:

See the complete Steps below in Explanation:

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.

[References:, 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., , , ]

Questions # 13:

A client creates a report and publishes it to Tableau Server where each department has its own user group set on the server. The client wants to limit visibility of

the report to the sales and marketing groups in the most efficient manner.

Which approach should the consultant recommend?

Options:

Grant access to the report on the Tableau Server only to the members of sales and marketing user groups.

Prepare a row-level security (RLS) entitlement table to define limitations of the access and use it to build user filters in the report's data

source.

Add user filters from Tableau Server to each worksheet and select only sales and marketing user groups.

Use user groups defined on Tableau Server to build user filters in the report's data source.

Questions # 14:

A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations)

is required for the files before designing the visuals. The files have the following attributes:

. All files have the same schema.

. Multiple files have something in common among their file names.

. Each file has a unique key column.

Which data transformation strategy should the consultant use to deliver the best optimized result?

Options:

Use join option to combine/merge all the files together before doing the data transformation (calculations).

Use wildcard Union option to combine/merge all the files together before doing the data transformation (calculations).

Apply the data transformation (calculations) in each require file and do the wildcard union to combine/merge before designing the visuals.

Apply the data transformation (calculations) in each require file and do the join to combine/merge before designing the visuals.

Answer

Explanation

Moving calculations to the data layer and materializing them in the extract can significantly improve the performance of reports in Tableau. The calculation ZN([Sales])*(1 - ZN([Discount])) is a basic calculation that can be easily computed in advance and stored in the extract, speeding up future queries. This type of calculation is less complex than table calculations or LOD expressions, which are better suited for dynamic analysis and may not benefit as much from materialization12.

[References: The answer is based on the best practices for creating efficient calculations in Tableau, as described in Tableau’s official documentation, which suggests using basic and aggregate calculations to improve performance1. Additionally, the process of materializing calculations in extracts is detailed in Tableau’s resources2., Given that all files share the same schema and have a common element in their file names, the wildcard union is an optimal approach to combine these files before performing any transformations. This strategy offers the following advantages:, Efficient Data Combination: Wildcard union allows multiple files with a common naming scheme to be combined into a single dataset in Tableau, streamlining the data preparation process., Uniform Schema Handling: Since all files share the same schema, wildcard union ensures that the combined dataset maintains consistency in data structure, making further data manipulation more straightforward., Pre-Transformation Combination: Combining the files before applying transformations is generally more efficient as it reduces redundancy in transformation logic across multiple files. This means transformations are written and processed once on the unified dataset, rather than repeatedly for each individual file., References:, Wildcard Union in Tableau: This feature simplifies the process of combining multiple similar files into a single Tableau data source, ensuring a seamless and efficient approach to data integration and preparation., , ]

Questions # 15:

A client uses Tableau Data Management and notices that when they view a data source, they sometimes see a different count of workbooks in the Connected

Workbooks tab compared to the lineage count in Tableau Catalog.

What is the cause of this discrepancy?

Options:

Some workbooks have been connected to the data source, but do not use any fields from it.

Some workbooks have not been viewed by enough users yet.

Some of the workbooks connected to the data source are not visible to the user due to permissions.

Some Creators have connected to the data source in Tableau Desktop but have not yet published a workbook.

Questions # 16:

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?

Options:

Published data sources that use live connections

Tableau Prep flows

Published data sources that use extracts

Workbooks

Questions # 17:

A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three groups of users are organized on Tableau Server with the

following levels of data access that they can be granted.

. Group 1: Viewers who cannot see any information on profitability

. Group 2: Viewers who can see profit and profit margin

. Group 3: Viewers who can see profit margin but not the value of profit

Which approach should the consultant use to provide the required level of access?

Options:

Use user filters to access data on profitability to all groups. Then, create a calculated field that allows visibility of profit value to Group 2 and

use the calculation in the view in the report.

Specify in the row-level security (RLS) entitlement table individuals who can see profit, profit margin, or none of these. Then, use the table

data to create user filters in the report.

Use user filters to allow only Groups 2 and 3 access to data on profitability. Then, create a calculated field that limits visibility of profit value to

Group 2 and use the calculation in the view in the report.

Specify with user filters in each view individuals who can see profit, profit margin, or none of these.

Questions # 18:

A client notices that while creating calculated fields, occasionally the new fields are created as strings, integers, or Booleans. The client asks a consultant if

there is a performance difference among these three data types.

What should the consultant tell the customer?

Options:

Strings are fastest, followed by integers, and then Booleans.

Integers are fastest, followed by Booleans, and then strings.

Strings, integers, and Booleans all perform the same.

Booleans are fastest, followed by integers, and then strings.

Questions # 19:

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?

Options:

Published data sources that use live connections

Tableau Prep flows

Published data sources that use extracts

Workbooks

Questions # 20:

A client is using Tableau to visualize data by leveraging security token-based credentials. Suddenly, sales representatives in the field are reporting that they

cannot access the necessary workbooks. The client cannot recreate the error from their offices, but they have seen screenshots from the field agents. The client

wants to restore functionality for the field agents with minimal disruption.

Which step should the consultant recommend to accomplish the client's goal?