Online Access Free Analytics-Con-301 Exam Questions

Exam Code:	Analytics-Con-301
Exam Name:	Salesforce Certified Tableau Consultant
Certification Provider:	Salesforce
Free Question Number:	102
Posted:	Sep 17, 2026

Rating

100%

Page: 1 / 21
Total 102 questions

Question 1

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.

Question 2

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.Filter MONTH/DAY/YEAR on [Ship Date] field and use an option to filter to the latest date value when the workbook opens.
B.Filter on Ship Date field using the Yesterday option.
C.Filter on calculation [Ship Date]=TODAY()-1.
D.Filter on calculation [Ship Date]={MAX([Ship Date])}.

Question 3

A client wants to use a bar chart to visualize the trend in profit per quarter for the last 5 years. They want each bar's color to be determined by whether the profit during that quarter was greater than the median profit for the past four quarters, including the current quarter.
For example, if a bar represents profit for 2020 Q4, they want to visually see whether the profit for 2020 Q4 is greater than the median profit for 2020 Q1-2020 Q4.
Which table calculation should produce the desired result?

A.SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), 3, 0)
B.SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), LAST()-3, LAST())
C.SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), FIRST(), FIRST() + 3)
D.SUM([Profit]) > WINDOW_MEDIAN(SUM([Profit]), INDEX(), INDEX() + 3)

Question 4

A multi-national company wants to have a Tableau dashboard that will provide country-level information for both its forecast summaries and year-on-year metrics. The company wants to toggle between these two views while leaving main key performance indicators (KPIs) visible on the main dashboard.
Which method is the most efficient in achieving the company's requirements?

A.Create a parameter that accepts values from a list that contains "Forecast View" and "Year-on-Year View."
. Right-click the parameter and select Add to Sheet for both worksheets.
. Navigate back to the dashboard and to the upper corner of the two worksheets.
. Enable the Use as Filter option.
B.Create a dashboard with the sheets containing the main KPIs and the forecast summary worksheet.
. Duplicate this dashboard and replace the forecast view worksheet with the year-on-year metrics worksheet.
. Add navigation buttons to both dashboards.
C.Create a single worksheet with all the measures required for both the forecast summary and the year-on- year views.
. Create a Boolean parameter and a corresponding calculated field with the following calculation: True.
. Add a blank dashboard object and in the Layout tab, check the box for "Control visibility using value" and select the parameter you created.
D.Create a Boolean parameter with the two names of the views as aliases and a corresponding calculated field with the following calculation: True.
. Add the forecast summary sheet to the dashboard and add the year-on-year metrics sheet to the same dashboard as a Floating dashboard object.
. Add the calculated fields as a Detail under the Marks card of the floating view, create a "Change Parameter" action, and set the
"Target Parameter" and "Source Fields" to the parameter and calculated field you created.
. Check the box for "Control visibility using value" in the Layout tab of the floating view and select the parameter you created.

Question 5

A client wants to grant a user access to a data source hosted on Tableau Server so that the user can create new content in Tableau Desktop. However, the user should be restricted to seeing only a subset of approved data.
How should the client set up the filter before publishing the hyper file so that the Desktop user follows the same row-level security (RLS) as viewers of the end content?

A.Context Filter
B.Data Source Filter
C.Extract Filter
D.Apply Filter to All Using Related Data Sources

Other Version: 466Salesforce.Analytics-Con-301.v2025-11-03.q25

Latest Upload: 124VMware.3V0-24.25.v2026-09-19.q35; 223IIA.IIA-CIA-Part1-CN.v2026-09-19.q369; 153Microsoft.MS-700.v2026-09-18.q195; 127Symantec.250-587.v2026-09-18.q44; 126Oracle.1Z0-1066-26.v2026-09-18.q67; 146Google.Associate-Cloud-Engineer.v2026-09-18.q160; 134Microsoft.AI-300.v2026-09-18.q53; 134SAP.C_TS452.v2026-09-18.q86; 145Salesforce.Slack-Con-201.v2026-09-17.q40; 174AAPC.CPC.v2026-09-17.q182