Key details for this exam, checked against the published exam outline
Each question shows the correct answer and an explanation of why it is right
An online sales company has a table data source that contains Order Date. Products ship on the first day of each month for all orders from the previous month.
The consultant needs to know the average number of days that a customer must wait before a product is shipped.
Which calculation should the consultant use?
The correct calculation to determine the average number of days a customer must wait before a product is shipped is to first find the shipping date, which is the first day of the following month after the order date. This is done using DATETRUNC('month', DATEADD('month', 1, [Order Date])). Then, the average difference in days between the order date and the shipping date is calculated using AVG(DATEDIFF('day', [Order Date], [Calc1])). This approach ensures that the average wait time is calculated in days, which is the most precise measure for this scenario.
To calculate the average waiting days from order placement to shipping, where shipping occurs on the first day of the following month:
Calculate Shipping Date (Calc1): Use the DATEADD function to add one month to the order date, then apply DATETRUNC to truncate this date to the first day of that month. This represents the shipping date for each order.
Calculate Average Wait Time (Calc2): Use DATEDIFF to calculate the difference in days between the original order date and the calculated shipping date (Calc1). Then, use AVG to average these differences across all orders, giving the average number of days customers wait before their products are shipped.
Date Functions in Tableau: Functions like DATEADD, DATETRUNC, and DATEDIFF are used to manipulate and calculate differences between dates, crucial for creating metrics that depend on time intervals, such as customer wait times in this scenario.
SIMULATION
From the desktop, open the NYC
Property Transactions workbook.
You need to record the performance of
the Property Transactions dashboard in
the NYC Property Transactions.twbx
workbook. Ensure that you start the
recording as soon as you open the
workbook. Open the Property
Transactions dashboard, reset the filters
on the dashboard to show all values, and
stop the recording. Save the recording in
C:\CC\Data\.
Create a new worksheet in the
performance recording. In the worksheet,
create a bar chart to show the elapsed
time of each command name by
worksheet, to show how each sheet in
the Property Transactions dashboard
contributes to the overall load time.
From the File menu in Tableau Desktop,
click Save. Save the performance
recording in C:\CC\Data\.
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:
From the desktop, double-click the NYC Property Transactions.twbx workbook to open it in Tableau Desktop.
Start Performance Recording:
Before doing anything else, navigate to the 'Help' menu in Tableau Desktop.
Select 'Settings and Performance', then choose 'Start Performance Recording'.
Open the Property Transactions Dashboard and Reset Filters:
Navigate to the Property Transactions dashboard within the workbook.
Reset all filters to show all values. This usually involves selecting the dropdown on each filter and choosing 'All' or using a 'Reset' button if available.
Stop the Performance Recording:
Go back to the 'Help' menu.
Choose 'Settings and Performance', then select 'Stop Performance Recording'.
Tableau will automatically open a new tab displaying the performance recording results.
Save the Performance Recording:
In the performance recording results tab, go to the 'File' menu.
Click 'Save As' and navigate to the C:\CC\Data\ directory.
Save the file, ensuring it is stored in the desired location.
Create a New Worksheet for Performance Analysis:
Return to the NYC Property Transactions workbook and create a new worksheet by clicking on the 'New Worksheet' icon.
Drag the 'Command Name' field to the Columns shelf.
Drag the 'Elapsed Time' field to the Rows shelf.
Ensure that the 'Worksheet' field is also included in the analysis to break down the time by individual sheets within the dashboard.
Choose 'Bar Chart' from the 'Show Me' options to display the data as a bar chart.
Customize and Finalize the Bar Chart:
Adjust the axes and labels to clearly display the information.
Format the chart to enhance readability, applying color coding or sorting as needed to emphasize sheets with longer load times.
Save Your Work:
Once the new worksheet and the performance recording are complete, ensure all work is saved.
Navigate to the 'File' menu and click 'Save', confirming that changes are stored in the workbook.
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.
A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations)
is required for the files before designing the visuals. The files have the following attributes:
. All files have the same schema.
. Multiple files have something in common among their file names.
. Each file has a unique key column.
Which data transformation strategy should the consultant use to deliver the best optimized result?
Moving calculations to the data layer and materializing them in the extract can significantly improve the performance of reports in Tableau. The calculation ZN([Sales])*(1 - ZN([Discount])) is a basic calculation that can be easily computed in advance and stored in the extract, speeding up future queries. This type of calculation is less complex than table calculations or LOD expressions, which are better suited for dynamic analysis and may not benefit as much from materialization12.
Given that all files share the same schema and have a common element in their file names, the wildcard union is an optimal approach to combine these files before performing any transformations. This strategy offers the following advantages:
Efficient Data Combination: Wildcard union allows multiple files with a common naming scheme to be combined into a single dataset in Tableau, streamlining the data preparation process.
Uniform Schema Handling: Since all files share the same schema, wildcard union ensures that the combined dataset maintains consistency in data structure, making further data manipulation more straightforward.
Pre-Transformation Combination: Combining the files before applying transformations is generally more efficient as it reduces redundancy in transformation logic across multiple files. This means transformations are written and processed once on the unified dataset, rather than repeatedly for each individual file.
Wildcard Union in Tableau: This feature simplifies the process of combining multiple similar files into a single Tableau data source, ensuring a seamless and efficient approach to data integration and preparation.
A customer plans to do an in-place upgrade of their single node Tableau Server from 2023.1 to the most recent version.
What is the correct sequence to prepare for an in-place upgrade?
Tableau's official in-place upgrade steps for single-node Tableau Server require:
Disable scheduled tasks (to prevent extract failures during upgrade).
Run the upgrade script for the new version.
Validate and test the server after upgrade.
The critical detail:
An in-place upgrade means upgrading the existing production environment directly, not installing in a separate environment or cloning VMs.
Option B matches exactly the documented operational steps for an in-place upgrade.
Why the other options are incorrect:
A: Uninstalling Tableau Server is not part of an in-place upgrade workflow.
C: This describes a migration or test upgrade in a separate environment, not an in-place upgrade.
D: VM cloning and restoring is not required for in-place upgrades and is not part of Tableau's official procedure.
Only B represents the correct in-place upgrade sequence.
Tableau Server in-place upgrade instructions: disable tasks run upgrade script test.
Single-node upgrade guidelines noting that uninstalling is not required.
Tableau Server administration materials clarifying the difference between in-place upgrade and sandbox testing.
A client builds a dashboard that presents current and long-term stock measures. Currently, the data is at a daily level. The data presents as a bar chart that
presents monthly results over current and previous years. Some measures must present as monthly averages.
What should the consultant recommend to limit the data source for optimal performance?
For optimal performance, it is recommended to limit the data to what is necessary for analysis, which in this case would be the current and previous years. Moving the calculation of averages to the data layer and aggregating the dates to a monthly level will reduce the granularity of the data, thereby improving the performance of the dashboard. This approach aligns with best practices for optimizing workbook performance in Tableau, which suggest simplifying the data model and reducing the number of records processed12.
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?
The correct calculation to count all distinct orders placed in 2010 involves placing the conditional inside the aggregation function, not the other way around. Here's how to correct the client's calculation:
Original Calculation Issue: The client's original calculation attempts to apply the COUNTD function within an IF statement, which does not work as expected because the COUNTD function cannot conditionally count within the scope of the IF statement.
Correct Calculation: COUNTD(IF YEAR([Date]) = 2010 THEN [OrderID] END). This calculation checks each order date; if the year is 2010, it returns the OrderID. The COUNTD function then counts all unique OrderIDs that meet this condition.
Why It Works: This method ensures that each order is first checked for the year condition before being counted, effectively filtering and counting in one step. It efficiently processes the data by focusing the distinct count operation only on relevant records.
Reference
This approach is consistent with Tableau's guidance on using conditional logic inside aggregation functions for accurate and efficient data calculations, as detailed in the Tableau User Guide under 'Aggregations and Calculations'.
A consultant is designing a dashboard that will be consumed on desktops, tablets, and phones. The consultant needs to implement a dashboard design that
provides the best user experience across all the platforms.
Which approach should the consultant take to achieve these results?
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.
Exam domains verified against: Official Salesforce Analytics-Con-301 exam guide, last checked October 2026.
Map current analytics infrastructure and business requirements to Tableau capabilities and future state architecture. Assess existing data structures for quality, lineage, and performance risks to inform migration and upgrade planning.
Sample question from this domain above: Q3
Design data transformation strategies and row-level security structures that meet governance and performance requirements. Select appropriate connection methods including Tableau Bridge, Web Data Connectors, and custom SQL for optimal data delivery.
Sample question from this domain above: Q2
Build advanced visualizations and table calculations using order of operations, LOD expressions, and aggregations. Optimize workbook performance by identifying resource-intensive queries, inefficient calculations, and design elements that impact speed.
Develop governance strategies for content security, data quality, and certification. Design content distribution approaches and workbook lifecycle processes including build, test, deployment, and maintenance on Tableau Server or Cloud.
Common questions about the exam itself
