Salesforce Certified Tableau Consultant - Analytics-Con-301 FREE EXAM DUMPS QUESTIONS & ANSWERS
A client wants to see data for only the most recent day in the dataset that is updated intermittently. The solution should offer the best caching performance.
Which approach should the consultant use to produce the desired results?
Which approach should the consultant use to produce the desired results?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
A consultant updates an IF-THEN calculation to use a newly created calculated field "Last Name" (parsed from "Full Name"). After the change, performance becomes noticeably worse.
Which two options should the consultant use to improve dashboard performance without altering functionality? Choose two.
Which two options should the consultant use to improve dashboard performance without altering functionality? Choose two.
Correct Answer: B,C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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?
Which content will need to be moved using a different tool or process?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
A consultant is creating a dashboard to report on hourly sales data. The data should be refreshed hourly and is used for timely decision-making, so it is important to alert dashboard viewers when data has not been refreshed.
Which feature of Tableau Catalog should the consultant use to ensure dashboard viewers understand this message?
Which feature of Tableau Catalog should the consultant use to ensure dashboard viewers understand this message?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
During a Tableau Cloud implementation, a Tableau consultant has been tasked with implementing row-level security (RLS). They have already invested in implementing RLS within their own database for their legacy reporting solution. The client wants to know if they will be able to leverage their existing RLS after the Tableau Cloud implementation.
Which two requirements should the Tableau consultant share with the client? Choose two.
Which two requirements should the Tableau consultant share with the client? Choose two.
Correct Answer: A,C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
A Tableau Server customer is interested in measuring content and platform usage. Which two features should the consultant use? Choose two.
Correct Answer: A,B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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?
What should the consultant tell the customer?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Use the following login credentials to sign in
to the virtual machine:
Username: Admin
Password:
The following information is for technical
support purposes only:
Lab Instance: 40201223
To access Tableau Help, you can open the
Help.pdf file on the desktop.
From the desktop, open the CC workbook.
Open the Categorical Sales worksheet.
You need to use table calculations to
compute the following:
. For each category and year, calculate
the average sales by segment.
. Create another calculation to
compute the year-over-year
percentage change of the average
sales by category calculation. Replace
the original measure with the year-
over-year percentage change in the
crosstab.
From the File menu in Tableau Desktop, click
Save.
to the virtual machine:
Username: Admin
Password:
The following information is for technical
support purposes only:
Lab Instance: 40201223
To access Tableau Help, you can open the
Help.pdf file on the desktop.
From the desktop, open the CC workbook.
Open the Categorical Sales worksheet.
You need to use table calculations to
compute the following:
. For each category and year, calculate
the average sales by segment.
. Create another calculation to
compute the year-over-year
percentage change of the average
sales by category calculation. Replace
the original measure with the year-
over-year percentage change in the
crosstab.
From the File menu in Tableau Desktop, click
Save.
Correct Answer:
See the complete Steps below in Explanation:
Explanation:
To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:
* Compute Average Sales by Segment for Each Category and Year:
* Open the CC workbook and navigate to the Categorical Sales worksheet.
* Drag the 'Sales' field to the Rows shelf if it's not already there.
* Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'.
* Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'.
This will compute the average sales for each segment within each category and year.
* Create a Calculation for Year-over-Year Percentage Change:
* Right-click in the data pane and select 'Create Calculated Field'.
* Name the calculated field something descriptive, e.g., "YoY Sales Change".
* Enter the formula to calculate the year-over-year percentage change:
(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))
* Click 'OK' to save the calculated field.
* Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:
* Remove the original 'Sales' measure from the view by dragging it off the Rows shelf.
* Drag the newly created "YoY Sales Change" calculated field to the Rows shelf where the 'Sales' field was originally.
* Format the "YoY Sales Change" field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
Tableau Help: Offers guidance on creating calculated fields and using table calculations.
Tableau Desktop User Guide: Provides instructions on formatting and saving worksheets.
These steps allow you to manipulate data within Tableau effectively, using table calculations to analyze trends and changes in sales data by category and segment over years.
Explanation:
To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:
* Compute Average Sales by Segment for Each Category and Year:
* Open the CC workbook and navigate to the Categorical Sales worksheet.
* Drag the 'Sales' field to the Rows shelf if it's not already there.
* Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'.
* Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'.
This will compute the average sales for each segment within each category and year.
* Create a Calculation for Year-over-Year Percentage Change:
* Right-click in the data pane and select 'Create Calculated Field'.
* Name the calculated field something descriptive, e.g., "YoY Sales Change".
* Enter the formula to calculate the year-over-year percentage change:
(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))
* Click 'OK' to save the calculated field.
* Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:
* Remove the original 'Sales' measure from the view by dragging it off the Rows shelf.
* Drag the newly created "YoY Sales Change" calculated field to the Rows shelf where the 'Sales' field was originally.
* Format the "YoY Sales Change" field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
Tableau Help: Offers guidance on creating calculated fields and using table calculations.
Tableau Desktop User Guide: Provides instructions on formatting and saving worksheets.
These steps allow you to manipulate data within Tableau effectively, using table calculations to analyze trends and changes in sales data by category and segment over years.
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?
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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?
IF YEAR([Date])=2010 THEN COUNTD ([OrderID]) END
Which calculation will produce the correct result?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).