Question 1

A client has a published data source in Tableau Server and they want to revert to the previous version
of the data source. The solution must minimize the impact
on users.
What should the consultant do to accomplish this task?

Accepted Answer

D

Explanation: Tableau Server maintains a revision history for published content, including data sources. The most efficient and least disruptive method to revert to a previous version is to use this built-in functionality. An authorized user can navigate to the data source's revision history, select the desired previous version, and use the "Restore" action. This single-click operation reverts the data source to the selected state while preserving its ID and all existing connections from dependent workbooks, thus minimizing the impact on end-users who will seamlessly connect to the restored version.

Question 2

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?

Accepted Answer

C

Explanation: Tableau Catalog, a part of the Tableau Data Management offering, is designed to address issues of data trust and discovery. It provides a comprehensive view of the data environment, including lineage and impact analysis. By using Tableau Catalog, the client can trace the data from the database tables to the published data sources and finally to the visualizations. This allows them to compare the metadata of the seemingly identical data sources, identify subtle differences in joins, filters, or calculated fields, and understand exactly why they produce different results. This visibility is crucial for diagnosing inconsistencies and re-establishing trust in the data.

Question 3

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?

Accepted Answer

B

Explanation: For optimal performance, data processing should be shifted from the query layer (dashboard) to the data preparation layer (Recipe or Dataflow). Aggregating daily data to a monthly level drastically reduces the number of rows in the dataset, which is the most significant factor for query speed. Pre-calculating the required monthly averages in the data layer ensures the dashboard only has to render results, not compute them on the fly. Filtering the data to only the necessary years (current and previous) further reduces the dataset size, adhering to the principle of loading only the data required for the analysis. This combined approach minimizes dataset size and query complexity, leading to the best possible performance.

Question 4

A Tableau Cloud client has requested a custom dashboard to help track which data sources are used
most frequently in dashboards across their site.
Which two actions should the client use to access the necessary metadata? Choose two.

Accepted Answer

A, C

Explanation: To create a custom dashboard tracking data source usage in Tableau Cloud, there are two primary methods. The first is to use the Admin Insights project, which is available to site administrators. It contains pre-built, curated data sources, including Site Content, that provide metadata about workbooks, views, and data sources, allowing for the creation of custom administrative views. The second method is to programmatically query the metadata using the Tableau Metadata API. This API allows for detailed, custom queries to discover content and understand the relationships between assets, such as which dashboards are using specific data sources.

Question 5

A client calculates the percent of total sales for a particular region compared to all regions. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/ANALYTICS-CON-301/page_45_img_1.jpg Which calculation will fix the automatic recalculation on the % of total field?

Accepted Answer

C

Explanation: To calculate a region's percentage of total sales, the formula must divide the sales for that specific region by the grand total sales across all regions. The calculation must be independent of any dimension filters applied to the view. The expression {FIXED [Region]:sum([Sales])}/{FIXED :SUM([Sales])} achieves this. The numerator, {FIXED [Region]:sum([Sales])}, calculates the total sales for each distinct region. The denominator, {FIXED :SUM([Sales])}, calculates the grand total sales across the entire dataset. Because FIXED Level of Detail (LOD) expressions are computed before regular dimension filters, the denominator remains constant even when the view is filtered to a single region. This ensures the percentage is always calculated against the true grand total.

Question 6

A client uses Tableau Data Management and notices that when they view a data source, they
sometimes see a different count of workbooks in the Connected
Workbooks tab compared to the lineage count in Tableau Catalog.
What is the cause of this discrepancy?

Accepted Answer

C

Explanation: The discrepancy arises because Tableau Catalog's lineage view is permission-aware, while the "Connected Workbooks" tab is not, in the same way. The lineage tool in Tableau Catalog only displays downstream assets, such as workbooks, that the current user has permission to view. In contrast, the "Connected Workbooks" tab on a data source page lists all workbooks connected to it, assuming the user has permission to see the data source itself. Therefore, if a user has permission to view the data source but not some of the workbooks connected to it, the count in the lineage view will be lower than the count in the "Connected Workbooks" tab.

Question 7

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?

Accepted Answer

A

Explanation: The most effective and recommended approach is to build a single dashboard and utilize the built-in device layout feature. This allows a consultant to create customized layouts for desktop, tablet, and phone experiences within one dashboard asset. By tailoring the arrangement and visibility of components for each specific layout and using a fixed size for predictability, the consultant can ensure an optimal and consistent user experience across all devices. This method centralizes maintenance, as any change to the underlying data or queries only needs to be done once.

Question 8

A client has a database that stores widget inventory by day and it is updated on a nonstandard
schedule as shown below.
Analytics-Con-301 practice exam questions

Analytics-Con-301 practice exam questions

They want a data visualization that shows widget inventory daily, however their business unit does
not have the ability to modify the data warehouse
structure.
What should the client do to achieve the desired result?

Accepted Answer

D

Explanation: The core problem is data densification—creating rows for dates that are missing in the source data. The key constraint is that the user cannot modify the source data warehouse. Tableau Prep is the ideal tool for this scenario. It is a data preparation tool that can connect to the source, generate the missing daily rows using its "New Rows" feature, and then output a new, complete data source (like a Hyper extract). This new source can then be used in Tableau Desktop for visualization, effectively solving the problem without altering the original database.

Question 9

SIMULATION From the desktop, open the CC workbook. Use the US Population Estimates data source. You need to shape the data in US Population Estimates by using Tableau Desktop. The data must be formatted as shown in the following table. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/ANALYTICS-CON-301/page_26_img_1.jpg Open the Population worksheet. Enter the total number of records contained in the data set into the Total Records parameter. From the File menu in Tableau Desktop, click Save.

Accepted Answer

[VALUE IS DATA-DEPENDENT AND CANNOT BE DETERMINED WITHOUT THE SOURCE CC WORKBOOK FILE.]

Explanation: The simulation requires performing a series of actions where the final step, entering the total record count, depends on the specific data file. The correct procedure is as follows: On the Data Source page , verify the data types. Click the icon next to each field name and select the correct type as specified in the image (e.g., String for Sex , Number (whole) for Year ). Navigate to the Population worksheet . In the Data pane , locate the measure named US Population Estimates(Count) . Drag this US Population Estimates(Count) field onto the Text mark. The view will update to show a single number, which is the total record count. In the Data pane , right-click the Total Records parameter and select Show Parameter . Enter the number from step 4 into the Total Records parameter card that appears in the view. Click File > Save .

Question 10

SIMULATION
From the desktop, open the CC workbook.
Open the Incremental worksheet.
You need to add a line to the chart that
shows the cumulative percentage of sales
contributed by each product to the
incremental sales.
From the File menu in Tableau Desktop, click
Save.

Accepted Answer

THE SIMULATION IS COMPLETED BY ADDING A SECONDARY TABLE CALCULATION (RUNNING TOTAL, THEN PERCENT OF TOTAL) TO A DUPLICATE SUM(SALES) FIELD, CREATING A SYNCHRONIZED DUAL-AXIS CHART WITH THE RESULT DISPLAYED AS A LINE, AND THEN SAVING THE WORKBOOK.

Explanation: To display a cumulative percentage line, a multi-step table calculation is required. The primary Running Total calculation computes the cumulative sum of sales across the products. The secondary Percent of Total calculation then converts these cumulative sums into a percentage of the overall total. This result is placed on a second axis (Dual Axis), changed to a line mark, and synchronized with the primary axis to overlay the cumulative percentage line onto the original chart. This technique is a standard method for creating a Pareto chart to visualize cumulative contribution.

Question 11

SIMULATION 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.

Accepted Answer

THIS IS A SIMULATION TASK. THE FINAL NUMERICAL VALUE FOR "NEWELL" CANNOT BE DETERMINED WITHOUT ACCESS TO THE "CC WORKBOOK" DATA FILE.

THE CORRECT LEVEL OF DETAIL (LOD) EXPRESSION TO MODIFY THE PERCENT CONTRIBUTION CALCULATED FIELD IS: SUM([QUANTITY]) / SUM({FIXED : SUM([QUANTITY])})

Explanation: The goal is to calculate each manufacturer's contribution to the total quantity. SUM([Quantity]) : This aggregation calculates the quantity for the level of detail in the view (i.e., for each manufacturer). {FIXED : SUM([Quantity])} : This FIXED LOD expression calculates the grand total quantity across the entire dataset, independent of the dimensions or filters* in the view. Dividing the manufacturer's sum by this fixed grand total provides the correct percentage contribution. After applying this formula, you would identify the value for "Newell" and enter it into the specified parameter. (*Note: FIXED LOD expressions are computed before dimension filters. If filters are present and should apply to this calculation, they must be added to context.)

Question 12

SIMULATION
From the desktop, open the CC workbook.
Open the Incremental worksheet.
You need to add a line to the chart that
shows the cumulative percentage of sales
contributed by each product to the
incremental sales.
From the File menu in Tableau Desktop, click
Save.

Accepted Answer

1.  ON THE ROWS SHELF, RIGHT-CLICK THE SUM(SALES) PILL AND SELECT DUAL AXIS.
2.  ON THE MARKS CARD, SELECT THE SUM(SALES) (2) TAB, AND CHANGE THE MARK TYPE TO LINE.
3.  ON THE ROWS SHELF, RIGHT-CLICK THE SECOND SUM(SALES) PILL, SELECT ADD TABLE CALCULATION.
FOR CALCULATION TYPE, SELECT RUNNING TOTAL.
CHECK THE ADD SECONDARY CALCULATION BOX.
FOR THE SECONDARY CALCULATION TYPE, SELECT PERCENT OF TOTAL.
CLOSE THE DIALOG BOX.
4.  ON THE COLUMNS SHELF, RIGHT-CLICK THE CITY PILL, AND SELECT MEASURE > COUNT (DISTINCT).
5.  ON THE COLUMNS SHELF, RIGHT-CLICK THE CNT(CITY) PILL, SELECT ADD TABLE CALCULATION.
FOR CALCULATION TYPE, SELECT RUNNING TOTAL.
CHECK THE ADD SECONDARY CALCULATION BOX.
FOR THE SECONDARY CALCULATION TYPE, SELECT PERCENT OF TOTAL.
CLOSE THE DIALOG BOX.
6.  FROM THE LEFT PANE, SELECT THE ANALYTICS TAB.
7.  DRAG REFERENCE LINE ONTO THE VIEW AND DROP IT ON THE TABLE SCOPE FOR THE SUM(SALES) AXIS.
IN THE DIALOG, FOR VALUE, ENTER 0.8. CLICK OK.
8.  DRAG REFERENCE LINE ONTO THE VIEW AND DROP IT ON THE TABLE SCOPE FOR THE CNT(CITY) AXIS.
IN THE DIALOG, FOR VALUE, ENTER 0.2. CLICK OK.
9.  FROM THE FILE MENU, CLICK SAVE.

Explanation: This procedure correctly configures the Pareto chart. First, a dual-axis chart is created to overlay a line graph (for cumulative percentage) on the bar chart (for individual sales). Table calculations are then applied to both the sales measure and the city dimension to compute the running total as a percentage of the total. This creates the characteristic Pareto curve and the cumulative percentage axis. Finally, constant reference lines are added at 80% on the sales axis and 20% on the city axis to visually represent the Pareto principle (the 80/20 rule), which is the core requirement of the task.

Question 13

SIMULATION 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. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/ANALYTICS-CON-301/page_22_img_1.jpg 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.

Accepted Answer

ON THE CATEGORICAL SALES WORKSHEET, LOCATE THE AVG(SALES) MEASURE PILL (IF IT IS SUM(SALES), RIGHT-CLICK IT AND CHANGE THE AGGREGATION TO MEASURE (AVERAGE)).
RIGHT-CLICK THE AVG(SALES) PILL AND SELECT EDIT TABLE CALCULATION....
PRIMARY CALCULATION:

SET CALCULATION TYPE TO AVERAGE.
SET COMPUTE USING TO SPECIFIC DIMENSIONS.
CHECK ONLY SEGMENT.

CLICK ADD SECONDARY CALCULATION.
SECONDARY CALCULATION:

SET SECONDARY CALCULATION TYPE TO PERCENT DIFFERENCE FROM.
SET COMPUTE USING TO SPECIFIC DIMENSIONS.
CHECK ONLY YEAR(ORDER DATE).

CLOSE THE TABLE CALCULATION DIALOG BOX.
FROM THE FILE MENU, CLICK SAVE.

Explanation: This task requires a nested table calculation (also known as a secondary table calculation) to satisfy both requirements. The primary calculation addresses the first bullet: "calculate the average sales by segment." By setting the Calculation Type to Average and computing using Segment , Tableau first averages the sales figures for the Consumer, Corporate, and Home Office segments for each Category/Year intersection. The secondary calculation addresses the second bullet: "compute the year-over-year percentage change." By adding a secondary calculation of Percent Difference From and computing using YEAR(Order Date) , Tableau takes the result of the first calculation (the average) and computes its percentage change from the previous year.

Question 14

SIMULATION Refer to the exhibit. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/ANALYTICS-CON-301/page_29_img_1.jpg 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\.

Accepted Answer

IN THE NEW PERFORMANCE RECORDING WORKBOOK, CREATE A NEW WORKSHEET.

DRAG THE WORKSHEET DIMENSION TO THE ROWS SHELF.

DRAG THE COMMAND DIMENSION TO THE ROWS SHELF (PLACED AFTER WORKSHEET).

DRAG THE ELAPSED TIME MEASURE TO THE COLUMNS SHELF.

FROM THE FILE MENU, SELECT SAVE, AND SAVE THE FILE TO C:\CC\DATA\.

Explanation: This simulation first requires you to generate performance data by starting the recording ( Help > Settings and Performance > Start Performance Recording ), performing the specified actions, and stopping the recording. Tableau then opens a new workbook containing this data. The core task is to build the specified bar chart. Placing the Worksheet and Command dimensions on the Rows shelf and the Elapsed Time measure on the Columns shelf correctly structures the data. This creates a bar chart that visually represents the duration of each command, broken down by the worksheet it originated from, thereby isolating the components contributing to the load time as requested.

Question 15

A university has data on its undergraduate students and their majors by grade level (Freshman,
Sophomore, Junior, Senior). The university is interested in
visualizing the path students take as they change majors across grade levels.
Which visualization type should the consultant recommend?

Accepted Answer

D

Explanation: A Sankey diagram is the most appropriate visualization for this requirement. It is specifically designed to illustrate the flow and magnitude of transitions between different states or stages. In this scenario, it can effectively map the journey of students, showing how the distribution of majors changes from one grade level (e.g., Freshman) to the next (e.g., Sophomore). The width of the connecting paths (links) between the nodes (majors) would be proportional to the number of students, clearly visualizing the paths, including where students remain in the same major and where they switch.

Free Salesforce Analytics-Con-301 Actual Exam Questions