매달, 우리는 1000명 이상의 사람들이 시험 준비를 잘하고 시험을 잘 통과할 수 있도록 도와줍니다.
Salesforce Certified Tableau Consultant 온라인 연습
최종 업데이트 시간: 2025년12월09일
당신은 온라인 연습 문제를 통해 Salesforce Analytics-Con-301 시험지식에 대해 자신이 어떻게 알고 있는지 파악한 후 시험 참가 신청 여부를 결정할 수 있다.
시험을 100% 합격하고 시험 준비 시간을 35% 절약하기를 바라며 Analytics-Con-301 덤프 (최신 실제 시험 문제)를 사용 선택하여 현재 최신 55개의 시험 문제와 답을 포함하십시오.
정답:
Explanation:
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.
정답:
Explanation:
Comprehensive and Detailed Explanation From Exact Extract:
Tableau Cloud does not natively contain a Sankey diagram in Show Me.
Such advanced charts often require:
A custom extension
Or specialized templates built into Tableau Exchange
A sandboxed Viz Extension allows users to embed specialized visualization components (like Sankey diagrams) securely in Tableau Cloud. These extensions are designed for advanced chart types that are not available natively.
Accelerators provide prebuilt dashboards but are not intended for custom visual types such as Sankey.
Connectors relate to connecting to data sources, not visualization.
Show Me does not include a Sankey option.
Therefore, downloading a sandboxed Viz Extension is the correct approach.
Viz Extensions documentation explaining support for custom charts, including Sankey.
Tableau Exchange listing providing sandboxed visualization extensions for non-native chart types.
Show Me panel documentation showing Sankey is not an included chart type.
정답:
Explanation:
Comprehensive and Detailed Explanation From Exact Extract:
When Tableau Data Management is enabled, Tableau Catalog provides Lineage capabilities that map connections between:
External databases
Tables
Data sources
Workbooks
Fields
Tableau documentation states that the Lineage tab for any external asset (such as a database or table):
Shows all connected workbooks
Shows dependencies and impact analysis
Allows admins to instantly assess how many analytics assets will be affected by a data warehouse migration
Option A directly uses Tableau Catalog to perform exactly this task.
Option B is unnecessary because the Catalog lineage tool already provides this information without development effort.
Option C is completely inappropriate because it offers no analysis or planning.
Option D is too time-consuming and unnecessary, especially when Tableau Catalog provides an automated dependency map.
Therefore, the correct method is to use the Lineage tab in External Assets.
Tableau Catalog lineage documentation showing how to view impacted workbooks.
External Assets and data source dependency features in Tableau Data Management.
Impact analysis best practices for data warehouse migration using Tableau Catalog.
정답:
Explanation:
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.
정답:
Explanation:
Comprehensive and Detailed Explanation From Exact Extract:
Key details from the scenario:
The dashboard is on a command center screen.
The environment cannot access the internet.
The data source is real-time (live).
The dashboard must keep itself refreshed automatically.
No human interaction should be required.
From Tableau’s documentation:
✔ Dashboard Extension API
Tableau’s Extension API allows developers to create custom extensions that can automate refreshing a live dashboard at intervals.
The extension is hosted on the company’s internal web server, which solves the “no internet access” limitation.
This is the only method in the listed options that:
Works offline
Can auto-refresh the dashboard
Supports a “screen-based” live monitoring use case
Uses the existing live connection (no need for extracts)
Thus, A is correct.
Why the other options are wrong:
✘ B. Schedule a Prep Flow
Prep flows do not refresh dashboards.
They only refresh prepared data sources.
The dashboard still won’t auto-update unless reopened.
✘ C. Download an extension from Tableau Exchange
Tableau Exchange requires internet access, which the company does not have.
Also, “sandboxed extensions” cannot refresh the dashboard at timed intervals.
✘ D. Use extracts and scheduled extract refresh Extracts require:
A Tableau Server / Cloud schedule Internet access for Cloud
And extracts are not real-time This contradicts the requirement for real-time data and an offline environment.
정답:
Explanation:
To effectively display quarterly profit growth and aggregated sales totals across different product categories, a combination of a Waterfall chart and a Tree Map is recommended:
Waterfall Chart: This chart type is excellent for visualizing the sequential growth or decline of profits across different quarters for each sub-category. It clearly shows how profits accumulate over time, highlighting both positive and negative changes, which makes it ideal for tracking profit growth or decline through the quarters.
Tree Map: A Tree Map can efficiently display aggregated sales totals where each block size represents the total sales of a product category, providing a quick, visually impactful comparison across categories. This is especially useful when the client wants to understand which categories contribute most to sales in a glanceable format.
Together, these charts provide a comprehensive overview of both profit trends over time (Waterfall Chart) and a comparative snapshot of sales performance across categories (Tree Map), meeting the client's need to analyze performance dynamics in a detailed yet consolidated manner.
Reference
These recommendations are based on common best practices for data visualization in Tableau, where specific chart types are chosen for their strengths in communicating certain types of data relationships and dynamics, as detailed in Tableau's official visualization guides.
정답:
Explanation:
Comprehensive and Detailed Explanation From Exact Extract:
Tableau allows fiscal calendars to be defined at the data source level, affecting how all date fields behave across the workbook.
According to Tableau documentation:
Fiscal calendars must be set using Data Source Date Properties.
Once set, this becomes a default property for all date fields unless overridden.
This allows charts, hierarchies, and date parts to automatically follow the fiscal year starting in February.
Correct procedure:
Go to Data Source.
Open Date Properties.
Set Fiscal Year Start = February.
(Optional) Adjust Date Field Default Properties.
This ensures all charts and date hierarchies use the fiscal calendar automatically.
Why the other options are incorrect:
A. Right-click on axis → Use Fiscal Calendar
This option does not exist in Tableau.
B. Set Fiscal Year in Data Preview
Not supported; fiscal configuration isn’t made in the preview window.
C. Use FISCALYEAR() / FISCALQUARTER()
This is manual, requires custom fields, and does not configure Tableau’s built-in fiscal calendar system.
This is more work and not the correct method.
Only Option D configures the fiscal calendar globally and correctly.
Tableau Date Properties documentation specifying fiscal year settings.
Default Properties configuration for date fields.
Official guidance for implementing fiscal calendars.
정답:
Explanation:
When dashboards are published to Tableau Cloud, the function USERNAME() returns the user’s Tableau Cloud username, which is the email address associated with their Tableau Cloud account.
Tableau documentation states:
On Tableau Cloud, the value returned by USERNAME() is always the user’s email address. Row-Level Security (RLS) is typically implemented using a comparison of USERNAME() to an email field in the data source.
For secure filtering, the field compared to USERNAME() must match the authentication identity exactly.
Looking at the provided table:
“Abbreviated Name” contains short custom codes like “SMiller,” which do not match Tableau Cloud usernames.
“Lower Case Name” contains names like “sean miller,” which also do not match Tableau Cloud usernames.
“Email” contains the full email address for each user, such as “[email protected],” which is the only field that corresponds to what USERNAME() returns in Tableau Cloud. Therefore, the correct field to reference is Email.
Tableau Cloud authentication documentation stating USERNAME() returns the user’s email address. Row-Level Security setup guidance recommending the comparison USERNAME() = [Email Field]. Tableau security practices indicating only the email column will match USERNAME() values on Tableau Cloud.
정답:
Explanation:
Comprehensive and Detailed Explanation From Exact Extract:
Tableau’s documentation on Parameter Actions states that they allow users to interactively update a parameter directly from the view―without opening the parameter control box. To “interactively set a reference date” that drives a table calculation:
A parameter must hold that reference date.
A parameter action allows clicking or selecting a mark in the view to update the parameter value.
Table calculations can then reference that parameter to change their computation dynamically.
Filter actions modify which data is shown, not a reference date.
Running actions change sheets, not computation parameters.
Highlight actions visually accent marks but do not set values.
Thus, parameter actions are the only mechanism that meets the requirement.
Parameter Actions overview describing interactive parameter updates.
Use cases where parameter actions drive table calculations.
Action type comparison showing that only parameter actions update a computation value.
정답: 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:
Open the CC workbook and navigate to the Categorical Sales worksheet.
Drag the 'Sales' field to the Rows shelf if it's not already there.
Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'. Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'. This will compute the average sales for each segment within each category and year. Create a Calculation for Year-over-Year Percentage Change:
Right-click in the data pane and select 'Create Calculated Field'.
Name the calculated field something descriptive, e.g., "YoY Sales Change".
Enter the formula to calculate the year-over-year percentage change:
(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))
Click 'OK' to save the calculated field.
Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:
Remove the original 'Sales' measure from the view by dragging it off the Rows shelf.
Drag the newly created "YoY Sales Change" calculated field to the Rows shelf where the 'Sales' field was originally.
Format the "YoY Sales Change" field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage. Save Your Changes:
From the File menu, click 'Save' to ensure all your changes are stored.
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:
From the desktop, double-click on the CC workbook to open it in Tableau Desktop.
Navigate to the Population worksheet by selecting its tab at the bottom of the window.
Format and Shape the Data:
Ensure the data types match those specified in the requirements: Sex, Origin, Race as strings; Year, Age, Population as whole numbers.
To verify or change the data type, click on the dropdown arrow next to each field name in the Data
pane and select "Change Data Type" if necessary.
Calculate Total Number of Records:
Create a new calculated field named "Total Records". To do this, right-click in the Data pane and select "Create Calculated Field".
Enter the formula COUNT([Record ID]) or SUM([Number of Records]) depending on how the data source identifies each row uniquely.
Drag this new calculated field onto the worksheet to display the total number of records.
Enter the Value into the Total Records Parameter:
Locate the "Total Records" parameter in the Data pane. Right-click on the parameter and select "Edit".
Manually enter the number displayed from the calculated field into the parameter, ensuring accuracy
to meet the data shaping requirement.
Save Your Changes:
From the File menu, click 'Save' to ensure all your changes are stored.
Reference: 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:
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.
Reference: 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 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.
Reference: 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 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:
From the desktop, double-click on the CC workbook to open it in Tableau Desktop. Navigate to the Incremental worksheet by clicking on its tab at the bottom of the window.
Calculate Cumulative Sales Percentage:
Create a new calculated field to compute the cumulative percentage of sales. Right-click in the Data
pane and select 'Create Calculated Field'.
Name this field "Cumulative Sales Percentage".
Enter the following formula to calculate the running sum of sales as a percentage of the total sales:
(RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) [Sales]))
Click 'OK' to save the calculated field.
Add the Cumulative Sales Percentage Line to the Chart:
Drag the "Cumulative Sales Percentage" field to the Rows shelf, placing it next to the existing Sales measure.
Ensure that the cumulative line appears as a continuous line. Right-click on the "Cumulative Sales Percentage" field on the Rows shelf, select 'Change Chart Type', and choose 'Line'.
Adjust the axis to synchronize or dual-axis if necessary. Right-click on the axis of the "Cumulative Sales Percentage" and select 'Synchronize Axis' if it's on a dual-axis setup.
Format the Cumulative Sales Percentage Line:
Click on the "Cumulative Sales Percentage" line in the visualization.
Navigate to the 'Format' pane to adjust the line style, thickness, and color to make it distinct from
other data in the chart.
Save Your Changes:
From the File menu, click 'Save' to ensure all your changes are stored.
Reference: 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 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. 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.