Tableau TCC-C01 Tableau Certified Consultant Exam Practice Test

Answer : A

For a consultant designing a dashboard to be consumed across multiple device types, the best approach is:

Multi-device Layout: Tableau provides the capability to design device-specific layouts within a single dashboard. This feature allows the dashboard to adapt its layout to best fit the screen size and orientation of desktops, tablets, and phones.

Fixed Size Layouts: By fixing the size of each layout, the consultant can ensure that the dashboard appears consistent and maintains the intended design elements and user experience across devices. Fixed sizes prevent components from resizing in ways that could disrupt the dashboard's readability or functionality.

Implementation: In Tableau, you can create these layouts by selecting 'Device Preview' and adding custom layouts for each device type. Here, you define the dimensions and the positioning of sheets and controls tailored to each device's typical viewing mode.

Reference This approach leverages Tableau's device designer capabilities, which are specifically designed to optimize dashboards for multiple viewing environments, ensuring a seamless user experience regardless of the device used. This functionality is well documented in Tableau's official guides on creating and managing device-specific dashboards.

Answer : A

To optimize the dashboard rendering, particularly when dealing with a large dataset, a filter action is the most effective tool. Here's why the specified choice is optimal:

Add a filter action: This action creates a direct filter on the detail table based on the selection in the bar chart. It ensures that only data related to the selected sub-category is loaded into the table, significantly reducing load time and improving performance.

Set 'Run action on' to Select: This setting means the filter action will be triggered as soon as the user selects a bar in the bar chart. Immediate activation of the filter ensures that the dashboard is interactive and responsive.

Set 'Clearing the selection will' to Exclude all values: When the selection is cleared, this setting ensures that no data is shown, which avoids loading the entire dataset unnecessarily. This maintains performance when no sub-category is actively selected.

Reference This strategy follows Tableau's performance best practices by using actions to limit the amount of data processed and rendered, as detailed in the Tableau User Guide and training materials on Dashboard Actions for optimizing large datasets.

Answer : C

To flag orders with sales higher than the regional average, the correct calculated field would compare the sum of sales for each order against the average sales of all orders within the same region:

Correct Formula: { FIXED [Order ID] : SUM([Sales]) } > { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

This calculation uses a Level of Detail (LOD) expression:

The left part of the formula { FIXED [Order ID] : SUM([Sales]) } calculates the total sales for each individual order.

The right part { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) } calculates the average sales per order within each region.

The > operator is used to compare these two values to determine if the sales for each order exceed the regional average.

Reference This formula utilizes Tableau's LOD expressions to perform complex comparisons across different dimensions of the data, as explained in Tableau's official training materials on LOD calculations.

Answer : A

To ensure that users automatically see Tableau views of regional sales filtered by customer as they sign into Salesforce, embedding the views directly into Salesforce is most effective:

Embedding Views: Tableau provides capabilities to embed its dashboards into web applications such as Salesforce. This approach ensures that the visualization is part of the Salesforce user interface, enhancing user experience by not requiring users to navigate away from Salesforce to view the data.

Implement this by using Tableau's embedding code, which can be generated from the Tableau Server for each specific view. Place this embed code into the Salesforce Visualforce pages or use Salesforce Canvas to integrate these views seamlessly.

This setup allows the Tableau views to inherit user credentials from Salesforce, enabling personalized data visualization based on the user's access rights and region, directly aligned with their Salesforce login session.

Reference The embedding technique is documented in both Tableau's and Salesforce's official integration guides, which provide step-by-step instructions on embedding Tableau views into Salesforce platforms.

Answer : D

To visualize the path students take as they change majors across different grade levels, a Sankey Diagram is highly effective. This type of visualization illustrates the flow and quantity between different stages or categories:

Sankey Diagram: It allows for a visual representation of students' movements between majors over time. Each flow's thickness is proportional to the number of students moving from one major to another, giving a clear, immediate visual cue of major popularity and student migration patterns.

To create a Sankey Diagram in Tableau, you typically need to prepare the data specifically for this type of chart. The data must include source (starting major), target (ending major), and the value (number of students). It often requires custom calculations and data reshaping to get the data in a format that a Sankey can use.

Once the data is prepared, you can use a combination of calculated fields, path binning, and line charts to simulate the flow effect in Tableau. External plugins or web-based integrations might also be employed for more direct implementations.

Reference Sankey Diagrams are not natively supported in Tableau but can be implemented through creative use of data preparation and calculations, as suggested in advanced Tableau user communities and demonstrated in various Tableau public galleries.

Answer : C

The Tableau Catalog is part of the Tableau Data Management Add-on and is designed to help users understand the data they are using within Tableau. It provides a comprehensive view of all the data assets in Tableau Server or Tableau Online, including databases, tables, and fields. It can help identify issues such as data quality, data lineage, and impact analysis. In this case, where different departments are getting different answers to the same business questions, the Tableau Catalog can be used to track down inconsistencies and ensure that everyone is working from the same, reliable data source.

When different departments report different answers to the same business questions using the same databases and tables, the issue often lies in how data is being accessed and interpreted differently across departments. Tableau Catalog, a part of Tableau Data Management, can be used to solve this problem:

Visibility: Tableau Catalog gives visibility into the data used in Tableau, showing users where data comes from, where it's used, and who's using it.

Consistency and Trust: It helps ensure consistency and trust in data by providing detailed metadata management that can highlight discrepancies in data usage or interpretation.

Usage Metrics and Lineage: It offers tools for tracking usage metrics and understanding data lineage, which can help in identifying why different departments might see different results from the same underlying data.

Tableau Catalog Usage: The Catalog is instrumental in providing a detailed view of the data environment, allowing organizations to audit, track, and understand data discrepancies across different users and departments.

Answer : B

When a filter is applied directly to the view, it can affect the calculation of percentages in a histogram because it changes the underlying data that the quick table calculation is based on. To avoid this, adding the [Profit] filter to the context will maintain the original calculation of percent shares while filtering out bins with less than a 15% share. This is because context filters are applied before any other calculations, so the percent shares calculated will be based on the context-filtered data, thus preserving the integrity of the original percent labels.

When a histogram is created showing the distribution of profits with labels indicating percent shares using a quick table calculation, and a need arises to limit the view to bins with at least a 15% share, applying a standard profit filter directly may undesirably alter how the percent labels calculate because they depend on the overall distribution of data. Placing the [Profit] filter into the context makes it a 'context filter,' which effectively changes how data is filtered in calculations:

Create a Context Filter: Right-click on the profit filter and select 'Add to Context'. This action changes the order of operations in filtering, meaning the context filter is applied first.

Adjust the Percent Calculation: With the profit filter set in the context, it first reduces the data set to only those profits that meet the filter criteria. Subsequently, any table calculations (like the percent share labels) are computed based on this reduced data set.

View Update: The view now updates to display only those bins where the profits are at least 15%, and the percent share labels recalculated to reflect the distribution of only the filtered (contextual) data.

Context Filters in Tableau: Context filters are used to filter the data passed down to other filters, calculations, the marks card, and the view. By setting the profit filter as a context filter, it ensures that calculations such as the percentage shares are based only on the filtered subset of the data.