TCC-C01 Tableau Certified Consultant Questions and Answers

To track which data sources are used most frequently across a site in Tableau Cloud, the client should use the GraphiQL engine and the Metadata API.The GraphiQL engine allows for interactive exploration of the metadata, making it easier to construct and test queries1.The Metadata API provides access to metadata and lineage of external assets used by the content published to Tableau Cloud, which is essential for tracking data source usage2.

References:The actions are based on the capabilities of the GraphiQL engine and the Metadata API as described in Tableau’s official documentation and learning resources321.

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:
• Modify the Percent Contribution Calculated Field:

{FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])}

• uk.co.certification.simulator.questionpool.PList@1d327330
• Enter Percentage for Newell:
• Save Your Changes:

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.

To record the performance of the Property Transactions dashboard in the NYC Property Transactions.twbx workbook and analyze it using a bar chart, follow these detailed steps:

• Open the NYC Property Transactions Workbook:
• Start Performance Recording:
• Open the Property Transactions Dashboard and Reset Filters:
• Stop the Performance Recording:
• Save the Performance Recording:
• Create a New Worksheet for Performance Analysis:
• Customize and Finalize the Bar Chart:
• Save Your Work:

References:

• Tableau Help Documentation: Provides guidance on how to start and stop performance recordings and analyze them.
• Tableau Visualization Techniques: Offers tips on creating effective bar charts for performance data.

By following these steps, you have successfully recorded and analyzed the performance of the Property Transactions dashboard, providing valuable insights into how each component of the dashboard contributes to the overall load time. This analysis is crucial for optimizing dashboard performance and ensuring efficient data visualization.

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:
• Create a Calculation for Year-over-Year Percentage Change:

(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))

• uk.co.certification.simulator.questionpool.PList@1d326a90
• Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:
• Save Your Changes:

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.

To shape the data in the "US Population Estimates" data source and enter the total number of records into the "Total Records" parameter in Tableau Desktop, follow these steps:

• Open the CC Workbook and Access the Worksheet:
• Format and Shape the Data:
• Calculate Total Number of Records:
• Enter the Value into the Total Records Parameter:
• Save Your Changes:

References:

• Tableau Desktop Guide: Provides detailed instructions on managing data types, creating calculated fields, and updating parameters.
• Tableau Data Shaping Techniques: Outlines effective methods for manipulating and structuring data for analysis.

This process will ensure the data in the "US Population Estimates" is accurately shaped according to the specified format and that the total number of records is correctly calculated and entered into the designated parameter. This thorough approach ensures data integrity and accuracy in reporting.

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:
• Construct the Pareto Chart:
• Add Reference Lines for the Pareto Principle:
• Adjust the Appearance of the Chart:
• Save Your Changes:

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.

To add a line showing the cumulative percentage of sales contributed by each product to the incremental sales in the Incremental worksheet of your Tableau Desktop, follow these detailed steps:

• Open the CC Workbook and Access the Worksheet:
• Calculate Cumulative Sales Percentage:

(RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) [Sales]))

• uk.co.certification.simulator.questionpool.PList@1d326e60
• Add the Cumulative Sales Percentage Line to the Chart:
• Format the Cumulative Sales Percentage Line:
• Save Your Changes:

References:

• Tableau Help: Provides additional details on creating calculated fields and customizing line charts.
• Tableau User Guide: Offers extensive instructions on formatting charts, including line types and axis synchronization.

By following these steps, you will successfully add a cumulative sales percentage line to your chart, enhancing the visualization to reflect the incremental contribution of each product to the overall sales in a dynamic and informative manner.

To effectively curate and document data for obtaining data lineage, particularly from a data source connected to a data lake, the recommended tool is:

• Tableau Catalog with Tableau Data Management Add-on: This add-on enhances the capabilities of Tableau Catalog, providing extensive features for data management, including detailed data lineage, impact analysis, and metadata management.
• Functionality: The Tableau Catalog with the Data Management Add-on allows users to see the full history and lineage of the data, trace its usage across all Tableau content, and understand dependencies. It also facilitates better governance and transparency in data handling.
• Why Choose this Tool: For a client needing comprehensive data lineage and documentation capabilities, this add-on ensures that data stewards and users can maintain and utilize a well-managed data environment. It supports robust data governance practices necessary for large and complex data ecosystems like those typically associated with data lakes.

ReferencesThe recommendation is based on the functionalities offered by the Tableau Data Management Add-on, as described in Tableau's official documentation on managing and documenting data sources for enhanced governance and operational efficiency.

When a client republishes a dashboard after making changes and users report broken bookmarks, the likely causes include:

• The dashboard was published to a different project: Changing the project location alters the URL path, causing bookmarks to point to a now non-existent dashboard location.
• The dashboard was published with a new name: Altering the dashboard's name changes its URL, resulting in broken bookmarks as the previous URL no longer leads to the intended dashboard.

For implementing row-level security (RLS) without the Tableau Data Management Add-on, the best approach is to integrate user filters into the published data source:

• Creating User Filters on Published Data Source: This method involves defining user filters that apply directly to the data source before it is published to the Tableau Server. This ensures that any workbook or view leveraging this data source inherently respects the row-level security settings.
• To implement this, create a calculated field in Tableau that defines the security logic, typically using a formula that references user functions (likeUSERNAME()orISMEMBEROF()). Drag this field to the Filters shelf and configure it to match the security rules (who can see what data).
• Once configured, publish the data source to Tableau Server with these filters in place. This approach centralizes security management, making it easier to maintain and update security policies as they are applied universally to all workbooks using this data source.

This strategy is safe as it reduces the risk of accidental data exposure through individual workbook misconfiguration and simplifies long-term maintenance of security policies.

ReferencesThis method follows Tableau’s best practices for implementing row-level security as detailed in Tableau’s security management resources. It ensures robust, maintainable security measures that scale with organizational needs without requiring additional add-ons.

To build efficient extracts from large data sources, it is crucial to minimize the load and optimize the performance of the extracts:

• A. Keep only the data required for analysis by using extract filters: This best practice involves using filters to reduce the volume of data extracted, thus focusing only on the data necessary for analysis.
• B. Use aggregate data for visible dimensions, whenever possible: Aggregating data at the time of extraction reduces the granularity of the data, which can significantly improve performance and reduce the size of the extract.
• E. Hide all unused fields: Removing fields that are not needed for analysis from the extract reduces the complexity and size of the data model, which in turn enhances performance and speeds up load times.

These practices are endorsed in Tableau’s official documentation and training sessions as effective ways to enhance the performance of Tableau extracts and optimize dashboard responsiveness.

The most user-friendly solution is to use Dynamic Zone Visibility in combination with a Show/Hide Button. This approach allows the dashboard to dynamically display only the relevant quick filters based on the viewer’s selection of shops or warehouses, thus reducing clutter and focusing the user’s attention on applicable filters.The Show/Hide Button further enhances the userexperience by allowing viewers to toggle the visibility of the filter container, providing a clean and organized dashboard interface1.

References:Dynamic Zone Visibility is a feature in Tableau that enables dashboard elements to appear or disappear based on the value of a field or parameter1.This functionality is ideal for creating interactive and user-friendly dashboards that adapt to user interactions and selections1.