Tableau Certified Consultant - TCC-C01 FREE EXAM DUMPS QUESTIONS & ANSWERS
A consultant creates a histogram that presents the distribution of profits across a client's customers. The labels on the bars show percent shares. The consultant used a quick table calculation to create the labels.
Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.
Which approach should the consultant use to produce the desired result?
Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.
Which approach should the consultant use to produce the desired result?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
From the desktop, open the CC workbook.
Open the City Pareto worksheet.
You need to complete the Pareto chart toshow the percentage of sales compared tothe percentage of cities. The chart mustshow references lines to visualize how thedata compares to the Pareto principle.
From the File menu in Tableau Desktop, clickSave.
Open the City Pareto worksheet.
You need to complete the Pareto chart toshow the percentage of sales compared tothe percentage of cities. The chart mustshow references lines to visualize how thedata compares to the Pareto principle.
From the File menu in Tableau Desktop, clickSave.
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.
A client collects information about a web browser customers use to access their website. They then visualize the breakdown of web traffic by browser version.
The data is stored in the format shown below in the related table, with a NULL BrowserID stored in the Site Visitor Table if an unknown browser version accesses their website.
The client uses "Some Records Match" for the Referential Integrity setting because a match is not guaranteed.
The client wants to improve the performance of
the dashboard while also getting an accurate count of site visitors.
Which modifications to the data tables and join should the consultant recommend?
The data is stored in the format shown below in the related table, with a NULL BrowserID stored in the Site Visitor Table if an unknown browser version accesses their website.
The client uses "Some Records Match" for the Referential Integrity setting because a match is not guaranteed.
The client wants to improve the performance of
the dashboard while also getting an accurate count of site visitors.
Which modifications to the data tables and join should the consultant recommend?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
A client wants guidance for Creators to build efficient extracts from large data sources.
What are three Tableau best practices that the Creators should use? Choose three.
What are three Tableau best practices that the Creators should use? Choose three.
Correct Answer: A,D,E
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes using an extract.
What is the most performant approach to model the data for a live connection?
What is the most performant approach to model the data for a live connection?
Correct Answer: B
Vote an answer
From the desktop, open the CC workbook.
Open the Manufacturers worksheet.
The Manufacturers worksheet is used to
analyze the quantity of items contributed by
each manufacturer.
You need to modify the Percent
Contribution calculated field to use a Level
of Detail (LOD) expression that calculates
the percentage contribution of each
manufacturer to the total quantity.
Enter the percentage for Newell to the
nearest hundredth of a percent into the
Newell % Contribution parameter.
From the File menu in Tableau Desktop, click
Save.
Open the Manufacturers worksheet.
The Manufacturers worksheet is used to
analyze the quantity of items contributed by
each manufacturer.
You need to modify the Percent
Contribution calculated field to use a Level
of Detail (LOD) expression that calculates
the percentage contribution of each
manufacturer to the total quantity.
Enter the percentage for Newell to the
nearest hundredth of a percent into the
Newell % Contribution parameter.
From the File menu in Tableau Desktop, click
Save.
Correct Answer:
See the complete Steps below in Explanation:
Explanation:
To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps:
* Open the CC Workbook and Access the Worksheet:
* Double-click on the CC workbook from the desktop to open it in Tableau Desktop.
* Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window.
* Modify the Percent Contribution Calculated Field:
* Navigate to the Data pane and find the "Percent Contribution" calculated field.
* Right-click on the "Percent Contribution" field and select 'Edit'.
* Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer:
{FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])}
* This formula uses{FIXED [Manufacturer]: SUM([Quantity])}to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity
{SUM([Quantity])}calculates the grand total across all manufacturers. The division calculates the percentage contribution.
* Click 'OK' to save the updated calculated field.
* Enter Percentage for Newell:
* With the updated "Percent Contribution" field, drag it onto the view to update the chart or table.
* Identify the value corresponding to 'Newell' in the updated visualization.
* Round this value to the nearest hundredth of a percent as required.
* Enter this value into the "Newell % Contribution" parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose 'Edit'. Enter the calculated percentage for Newell.
* Save Your Changes:
* From the File menu, click 'Save' to store all the modifications you have made to the workbook.
References:
* Tableau Help: Offers detailed guidance on using LOD expressions for precise and context-independent aggregations.
* Tableau Desktop User Guide: Provides comprehensive instructions on managing calculated fields and parameters, ensuring accurate data analysis.
By following these steps, you will have successfully updated the calculation for percent contribution using LOD expressions, providing a more accurate analysis of each manufacturer's contribution to the total quantity.
Moreover, updating the parameter with Newell's specific contribution rounds out the task by reflecting precise data inputs for reporting or further analysis.
Explanation:
To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps:
* Open the CC Workbook and Access the Worksheet:
* Double-click on the CC workbook from the desktop to open it in Tableau Desktop.
* Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window.
* Modify the Percent Contribution Calculated Field:
* Navigate to the Data pane and find the "Percent Contribution" calculated field.
* Right-click on the "Percent Contribution" field and select 'Edit'.
* Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer:
{FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])}
* This formula uses{FIXED [Manufacturer]: SUM([Quantity])}to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity
{SUM([Quantity])}calculates the grand total across all manufacturers. The division calculates the percentage contribution.
* Click 'OK' to save the updated calculated field.
* Enter Percentage for Newell:
* With the updated "Percent Contribution" field, drag it onto the view to update the chart or table.
* Identify the value corresponding to 'Newell' in the updated visualization.
* Round this value to the nearest hundredth of a percent as required.
* Enter this value into the "Newell % Contribution" parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose 'Edit'. Enter the calculated percentage for Newell.
* Save Your Changes:
* From the File menu, click 'Save' to store all the modifications you have made to the workbook.
References:
* Tableau Help: Offers detailed guidance on using LOD expressions for precise and context-independent aggregations.
* Tableau Desktop User Guide: Provides comprehensive instructions on managing calculated fields and parameters, ensuring accurate data analysis.
By following these steps, you will have successfully updated the calculation for percent contribution using LOD expressions, providing a more accurate analysis of each manufacturer's contribution to the total quantity.
Moreover, updating the parameter with Newell's specific contribution rounds out the task by reflecting precise data inputs for reporting or further analysis.