Related Certification(s):
Salesforce Consultant Certification
Salesforce Analytics-Con-301 Exam Topics - You’ll Be Tested in Actual Exam
When you prepare for this exam, start by learning how to evaluate the current state of an analytics environment in a practical way. You should be able to review existing dashboards and workbooks, identify who uses them, and spot gaps in performance, usability, and data quality. Next, spend time on designing and troubleshooting calculations and workbooks. This includes understanding how calculations behave at different levels of detail, how filters and context affect results, and how to debug issues when numbers look wrong or views load slowly. You also need to think like a consultant who can simplify a complex workbook, choose appropriate visual structures, and keep logic readable so others can maintain it. Governance and support for published content is another major pillar. Know how to keep published assets consistent, trusted, and easy to find through clear ownership, documentation, version control habits, and sensible access management. Finally, plan and prepare data connections with care. You should know how to choose the right connection approach, confirm that fields and relationships support the required analysis, and anticipate refresh behavior and permissions so users see accurate data reliably. Together these skills help you deliver work that is correct, scalable, and easy to support over time.
Salesforce Analytics-Con-301 Exam Short Quiz
Attempt this Salesforce Analytics-Con-301 exam quiz to self-assess your preparation for the actual Salesforce Certified Tableau Consultant exam. CertBoosters also provides premium Salesforce Analytics-Con-301 exam questions to pass the Salesforce Certified Tableau Consultant exam in the shortest possible time. Be sure to try our free practice exam software for the Salesforce Analytics-Con-301 exam.
A worksheet uses a LOOKUP function to display Sales by Month, Year of Order Date, and sales from the last 12 months. A consultant wants to use a Relative Date Filter to filter for data from the last 12 months. However, when the consultant does this, the prior year's data is removed from the sheet.
Which two actions should the consultant take to retain the prior year's data after applying the filter? Choose two.
☐
AReplace the LOOKUP function with a FIXED Level of Detail (LOD) expression.
☐
BSet the Relative Date filter as a Context Filter instead of Measure Filter.
☐
CCreate the following calculation: LOOKUP(MIN([Order Date]),0). Filter on that calculation instead of Order Date.
☐
DCreate the following calculation: DATEDIFF('month', [Order Date], {MAX([Order Date])}) < 12. Hide all False values.
SalesforceAnalytics-Con-301
Q2:
A shipping clerk wants to use a Sankey diagram to analyze the flow of goods between different categories, shipping modes, and locations to spot bottlenecks and optimize the most critical paths. The company uses Tableau Cloud.
How should the shipping clerk create a chart that depicts the above information?
○
ASearch and download a suitable sandboxed Viz Extension from Tableau Exchange.
○
BUse Show Me to start a view based on the fields selected.
○
CSearch and download a suitable sandboxed Accelerator from Tableau Exchange.
○
DSearch and download a suitable Connector from Tableau Exchange.
SalesforceAnalytics-Con-301
Q3:
A client wants to count all the distinct orders placed in 2010. They have written the following calculation, but the result is incorrect.
IF YEAR([Date])=2010 THEN COUNTD ([OrderID]) END
Which calculation will produce the correct result?
○
AIF MIN(YEAR([Date]))=2010 THEN WINDOW_COUNTD([OrderID]) END
○
BIF YEAR([Date])=2010 THEN {COUNTD ([OrderID])} END
○
CCOUNTD(IF YEAR([Date])=2010 THEN [OrderID] END)
○
DCOUNT(IF YEAR([Date])=2010 THEN [OrderID] END)
SalesforceAnalytics-Con-301
Q4:
A client has a pipeline dashboard that takes a long time to load. The dashboard is connected to only one large data source that is an extract.
It contains two calculated fields:
. TOTAL([Opportunities])
* SUM([Value])
It also contains two filters:
. A Relative Date filter on Created Date, a Date field containing values from 5 years ago until today
. A Multiple Values (Dropdown) filter on Account Name, a String field containing 1,000 distinct values
A consultant creates a Performance Recording to troubleshoot the issue, and finds out that the longest-running event is "Executing Query."
Which step should the consultant take to resolve this issue?
○
AReplace the Multiple Values (Dropdown) filter with a Multiple Values (Custom List) filter.
○
BReplace the Relative Date filter with a Multiple Values (Dropdown) filter on YEAR([Created Date]).
○
CReplace the TOTAL([Opportunities]) calculation with a Grand Total.
○
DReplace SUM([Value]) with WINDOW_SUM([Value]).
SalesforceAnalytics-Con-301
Q5:
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?
○
AConvert Data Source filters to Quick Filters.
○
BConvert any extracted data sources to live data sources.
