Here you can find all the free questions related with Salesforce Certified Tableau Consultant (Analytics-Con-301) exam. You can also find on this page links to recently updated premium files with which you can practice for actual Salesforce Certified Tableau Consultant Exam. These premium versions are provided as Analytics-Con-301 exam practice tests, both as desktop software and browser based application, you can use whatever suits your style. Feel free to try the Salesforce Certified Tableau Consultant Exam premium files for free, Good luck with your Salesforce Certified Tableau Consultant Exam.
Question No: 1
MultipleChoice
SIMULATION
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\.
Options
Answer AExplanation
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.
Topic 3, Knowledge-Based Section B
Question No: 2
MultipleChoice
A client wants to flag orders that have sales higher than the regional average.
Which calculated field will produce the required result?
A.
[Sales]
>
{ FIXED [Order ID] : SUM([Sales]) }
Options
Answer CExplanation
To flag orders with sales higher than the regional average, the correct calculated field would compare the sum of sales for each order against the average sales of all orders within the same region:
This calculation uses a Level of Detail (LOD) expression:
The left part of the formula { FIXED [Order ID] : SUM([Sales]) } calculates the total sales for each individual order.
The right part { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) } calculates the average sales per order within each region.
The > operator is used to compare these two values to determine if the sales for each order exceed the regional average.
References
This formula utilizes Tableau's LOD expressions to perform complex comparisons across different dimensions of the data, as explained in Tableau's official training materials on LOD calculations.
MENU
