Analytics-Con-301 無料問題集「Salesforce Certified Tableau Consultant」
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?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
A client calculates the percent of total sales for a particular region compared to all regions.
The Sales percentage is inadvertently recalculated each time the filter is applied to the Region.
Which calculation should fix the automatic recalculation on the % of total field?
The Sales percentage is inadvertently recalculated each time the filter is applied to the Region.
Which calculation should fix the automatic recalculation on the % of total field?
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
A client has a dashboard that renders in less than 10 seconds. The client receives a request to add a new calculated field that will return TRUE if a Project contains any one of the values "Project 1" or "Project 2" and FALSE otherwise. After adding the function found below, the dashboard's render time increases to 14 seconds from 10 seconds.
[Project] = 'Project 1' OR [Project] = 'Project 2'
Which function should the consultant use to reduce the render time?
[Project] = 'Project 1' OR [Project] = 'Project 2'
Which function should the consultant use to reduce the render time?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
A client notices that several groups are sharing content across divisions and are not complying with their data governance strategy. During a Tableau Server audit, a consultant notices that the asset permissions for the client's top-level projects are set to "Locked," but that "Apply to Nested Projects" is not checked.
The consultant recommends checking "Apply to Nested Projects" to enforce compliance.
Which impact will the consultant's recommendation have on access to the existing nested projects?
The consultant recommends checking "Apply to Nested Projects" to enforce compliance.
Which impact will the consultant's recommendation have on access to the existing nested projects?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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.
正解：
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 has many published data sources in Tableau Server. The data sources use the same databases and tables. The client notices different departments give different answers to the same business questions, and the departments cannot trust the data. The client wants to know what causes data sources to return different data.
Which tool should the client use to identify this issue?
Which tool should the client use to identify this issue?
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
A company has a sales team that is segmented by territory. The team's manager wants to make sure each sales representative can see only data relevant to that representative's territory in the team Sales Dashboard.
The team is large and has high turnover, and the manager wants the mechanism for restricting data access to be as automated as possible. However, the team does not have a Tableau Data Management license.
What should the consultant recommend to meet the company's requirements?
The team is large and has high turnover, and the manager wants the mechanism for restricting data access to be as automated as possible. However, the team does not have a Tableau Data Management license.
What should the consultant recommend to meet the company's requirements?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)