Salesforce Certified Tableau Consultant - Analytics-Con-301 Exam Questions
QUESTION NO: 1
A client is working in Tableau Prep and has a field named Orderld that is compiled by country, year, and an order number as shown in the following table.
What should the consultant use to transform the table in the most efficient manner?
A client is working in Tableau Prep and has a field named Orderld that is compiled by country, year, and an order number as shown in the following table.
What should the consultant use to transform the table in the most efficient manner?
Correct Answer: D
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 2
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?
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?
Correct Answer: A
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 3
A client wants to report Saturday and Sunday regardless of the workbook's data source's locale settings.
Which calculation should the consultant recommend?
A client wants to report Saturday and Sunday regardless of the workbook's data source's locale settings.
Which calculation should the consultant recommend?
Correct Answer: D
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 4
A client wants to see data for only the last day in a dataset and the last day is always yesterday. The date is represented with the field Ship Date.
The client is not concerned about the daily refresh results. The volume of data is so large that performance is their priority. In the future, the client will be able to move the calculation to the underlying database, but not at this time.
The solution should offer the best performance.
Which approach should the consultant use to produce the desired results?
A client wants to see data for only the last day in a dataset and the last day is always yesterday. The date is represented with the field Ship Date.
The client is not concerned about the daily refresh results. The volume of data is so large that performance is their priority. In the future, the client will be able to move the calculation to the underlying database, but not at this time.
The solution should offer the best performance.
Which approach should the consultant use to produce the desired results?
Correct Answer: D
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 5
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.
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.
Correct Answer:
See the complete Steps below in Explanation:
Explanation:
To complete the Pareto chart in the "City Pareto" worksheet of your Tableau Desktop and add reference lines to illustrate how the data compares to the Pareto principle, 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 City Pareto worksheet by selecting its tab at the bottom of the window.
* Construct the Pareto Chart:
* Ensure that sales data is aggregated by city. If not, drag the 'City' dimension to the Columns shelf and the 'Sales' measure to the Rows shelf.
* Sort the sales data in descending order to properly align the cities according to their sales contribution.
* To create a running total of sales, right-click on the 'Sales' measure on the Rows shelf, select
'Quick Table Calculation', and choose 'Running Total'.
* Drag the 'Number of Records' field to the Rows shelf next to the Sales running total. Right-click on it, select 'Quick Table Calculation', and choose 'Running Total'. Set its calculation to 'Percent of Total' from the 'Edit Table Calculation' option to represent the percentage of cities.
* Add Reference Lines for the Pareto Principle:
* Click on the Analytics tab in the sidebar.
* Drag a 'Reference Line' element and drop it onto the chart area.
* Set the Reference Line for the Sales axis at 80% to represent the typical Pareto cutoff where 80% of effects come from 20% of causes.
* Add another Reference Line on the axis representing the percentage of cities, set at 20%, to visually assess the Pareto principle.
* Adjust the Appearance of the Chart:
* Format the reference lines by right-clicking on them, selecting 'Edit', and choosing a distinct style or color to make them stand out.
* Ensure the chart is clear and labels are appropriately adjusted for easy understanding of the data visualization.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
Tableau Help: Offers detailed guidance on creating Pareto charts and adding reference lines.
Tableau Visualization Best Practices: Provides tips on effectively displaying cumulative data and principles such as Pareto.
By following these steps, you will have successfully enhanced the City Pareto worksheet to include a complete Pareto chart with reference lines that illustrate how the sales data compares to the Pareto principle, making it easier to analyze and communicate the distribution of sales across cities.
Explanation:
To complete the Pareto chart in the "City Pareto" worksheet of your Tableau Desktop and add reference lines to illustrate how the data compares to the Pareto principle, 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 City Pareto worksheet by selecting its tab at the bottom of the window.
* Construct the Pareto Chart:
* Ensure that sales data is aggregated by city. If not, drag the 'City' dimension to the Columns shelf and the 'Sales' measure to the Rows shelf.
* Sort the sales data in descending order to properly align the cities according to their sales contribution.
* To create a running total of sales, right-click on the 'Sales' measure on the Rows shelf, select
'Quick Table Calculation', and choose 'Running Total'.
* Drag the 'Number of Records' field to the Rows shelf next to the Sales running total. Right-click on it, select 'Quick Table Calculation', and choose 'Running Total'. Set its calculation to 'Percent of Total' from the 'Edit Table Calculation' option to represent the percentage of cities.
* Add Reference Lines for the Pareto Principle:
* Click on the Analytics tab in the sidebar.
* Drag a 'Reference Line' element and drop it onto the chart area.
* Set the Reference Line for the Sales axis at 80% to represent the typical Pareto cutoff where 80% of effects come from 20% of causes.
* Add another Reference Line on the axis representing the percentage of cities, set at 20%, to visually assess the Pareto principle.
* Adjust the Appearance of the Chart:
* Format the reference lines by right-clicking on them, selecting 'Edit', and choosing a distinct style or color to make them stand out.
* Ensure the chart is clear and labels are appropriately adjusted for easy understanding of the data visualization.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
Tableau Help: Offers detailed guidance on creating Pareto charts and adding reference lines.
Tableau Visualization Best Practices: Provides tips on effectively displaying cumulative data and principles such as Pareto.
By following these steps, you will have successfully enhanced the City Pareto worksheet to include a complete Pareto chart with reference lines that illustrate how the sales data compares to the Pareto principle, making it easier to analyze and communicate the distribution of sales across cities.
QUESTION NO: 6
A client wants to provide sales users with the ability to perform the following tasks:
Access published visualizations and published data sources outside the company network.
Edit existing visualizations.
Create new visualizations based on published data sources.
. Minimize licensing costs.
Which site role should the client assign to the sales users?
A client wants to provide sales users with the ability to perform the following tasks:
Access published visualizations and published data sources outside the company network.
Edit existing visualizations.
Create new visualizations based on published data sources.
. Minimize licensing costs.
Which site role should the client assign to the sales users?
Correct Answer: D
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 7
A consultant is tasked with improving the performance of a large workbook that contains multiple dashboards, each of which leverages a separate data source. What is one way to improve performance?
A consultant is tasked with improving the performance of a large workbook that contains multiple dashboards, each of which leverages a separate data source. What is one way to improve performance?
Correct Answer: D
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 8
A client is considering migrating from Tableau Server to Tableau Cloud.
Which two elements are determining factors of whether the client should use Tableau Server or Tableau Cloud? Choose two.
A client is considering migrating from Tableau Server to Tableau Cloud.
Which two elements are determining factors of whether the client should use Tableau Server or Tableau Cloud? Choose two.
Correct Answer: B,C
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 9
A new Tableau user created a simple dashboard on Tableau Server using supply chain data. Now, the user wants to know if they created the dashboard in accordance with specific performance best practices.
Which approach should the consultant recommend for the client to make this determination?
A new Tableau user created a simple dashboard on Tableau Server using supply chain data. Now, the user wants to know if they created the dashboard in accordance with specific performance best practices.
Which approach should the consultant recommend for the client to make this determination?
Correct Answer: D
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
