Tableau-Desktop-Found Exploring and Analyzing Data Practice Test 5 — 15 Questions

Question 1

You notice a field in your Data pane has a small '=' sign icon next to its name. What does this signify in Tableau?

Accepted Answer

The field is a custom calculation. The '=' symbol indicates that the field is a calculated field. This is a critical indicator because it signals to the user that the value is derived from a formula rather than being a raw field from the underlying data source. Knowing this helps analysts quickly debug logic, understand data lineage, and ensure that the calculations are correctly implemented for the current analytical requirements.

Answer

The field is a geographic dimension

Answer

The field is a parameter

Answer

The field is a primary key

Question 2

You have a scatter plot showing 'Sales' vs 'Profit'. You want to see the trend line for each 'Region'. What is the most straightforward way to achieve this?

Accepted Answer

Drag Region to the Color shelf. Adding a dimension to the Color shelf automatically partitions the view, which applies the trend line logic to each color-coded segment. This is the most efficient way to compare trends across multiple categories simultaneously. Understanding how marks cards and shelves interact to segment data is a core skill for Tableau users performing comparative analysis on multidimensional datasets.

Answer

Create individual trend line files

Answer

Apply a filter to the Trend Line

Answer

Use a Table Calculation for trends

Question 3

When you drag a continuous date field (e.g., Order Date) to the Columns shelf, what does Tableau display by default?

Accepted Answer

A continuous time axis. Tableau defaults to showing a continuous time axis when a continuous date field is placed on the shelf. This allows for a smooth line chart that accurately reflects the temporal nature of the data. Understanding default behaviors helps analysts save time by avoiding unnecessary manual configuration of time scales, ensuring quick insights into trends, seasonality, and overall performance patterns over time.

Answer

A list of discrete years

Answer

A bar chart of frequencies

Answer

A filter dialog box

Question 4

Refer to the exhibit. What is the effect of the calculation on the visualization?

Accepted Answer

It computes a 4-month rolling average. The calculation creates a 4-month rolling average (current month plus the 3 previous months). By using a window calculation, Tableau looks at the result set currently in the view and performs an average on that subset. This is a common requirement for smoothing out seasonality in sales data, enabling analysts to identify long-term growth trends rather than being distracted by monthly volatility.

Answer

It calculates the average of all months

Answer

It calculates the average for the current year

Answer

It is a row-level calculation

Question 5

You are analyzing sales data and need to identify the top 10 products by profit. You have dragged 'Product Name' to the Rows shelf and 'Profit' to the Columns shelf. What is the most efficient way to isolate only the top 10 performers?

Accepted Answer

Drag Product Name to the Filters shelf, select the Top tab, and define a limit by field.. Using a Top N filter allows Tableau to perform the calculation at the data source level before rendering the visualization. This is more performant than using a manual hide or a set, as it dynamically adjusts if the underlying data changes. Mastering this technique is essential for creating clean, focused dashboards that guide stakeholders directly to the most critical business metrics without overwhelming them with unnecessary, low-value data points.

Answer

Sort the visualization in descending order and manually hide all rows after the tenth item.

Answer

Create a calculated field using the RANK function and filter for values less than or equal to 10.

Answer

Apply a wildcard filter to the Product Name dimension to include only the top 10 records.

Question 6

Refer to the exhibit. You are analyzing 'Profit Ratio' by 'Customer Segment'. When you drag this field to the view, the results seem incorrect for the aggregate total. Why might this be happening?

Accepted Answer

The calculation is using row-level Profit and Sales, resulting in an unweighted average.. Aggregating ratios requires careful handling of the numerator and denominator. By summing the ratio of every row, you are performing an average of averages, which is mathematically invalid. You must instead calculate the sum of total profit divided by the sum of total sales to obtain the correct weighted average. This ensures that the global metric accurately reflects the underlying data distribution across segments.

Answer

The data source requires a data blend, causing a granularity mismatch in the view.

Answer

The Profit Ratio field is set to a Continuous measure instead of a Discrete dimension.

Answer

The view is missing a table calculation to define the scope of the aggregation.

Question 7

Which feature allows you to quickly view the underlying data of a specific mark in your visualization without leaving the current sheet?

Accepted Answer

The 'View Data' option in the Tooltip or Right-click context menu.. The 'View Data' window is a critical tool for data validation and exploration. It allows users to see the specific records that constitute a single mark or a selection of marks. This feature is essential for debugging calculated fields and verifying that the data being visualized matches the expectations of the business logic, providing immediate feedback during the dashboard building process.

Answer

The Data Interpreter tool in the Data Source tab.

Answer

The Annotations menu in the Worksheet toolbar.

Answer

The 'Describe' button in the Data pane sidebar.

Question 8

You want to create a calculated field that displays 'High' if Profit is over $1000 and 'Low' otherwise. What is the correct syntax for this IF statement?

Accepted Answer

IF [Profit] > 1000 THEN 'High' ELSE 'Low' END. The IF...THEN...ELSE...END structure is the standard logical construct in Tableau for categorization. Understanding how to create these conditional flags is vital for data exploration, as they allow users to segment their data into meaningful buckets for analysis. This transforms raw numerical data into actionable insights, helping stakeholders identify trends or outliers that require immediate business attention or further investigation.

Answer

IIF([Profit] > 1000, 'High', 'Low')

Answer

IF [Profit] > 1000: 'High'; ELSE: 'Low'

Answer

CASE [Profit] > 1000 WHEN TRUE THEN 'High' ELSE 'Low' END

Question 9

Refer to the exhibit. You are trying to show a 'Grand Total' on a bar chart that uses an aggregate calculation. Why might this be failing?

Accepted Answer

The measure is a non-additive calculation, such as a ratio or distinct count.. Grand totals operate by re-calculating the sum at a higher level of aggregation. If the measure is a non-additive aggregate (like a ratio or a distinct count), Tableau cannot perform a simple sum of the displayed values to reach the total. You must ensure that the total is calculated by aggregating the underlying base data rather than the derived values displayed in the view.

Answer

The visualization uses a dual axis, which disables the Grand Total option.

Answer

The data source has a circular reference in the relationship model.

Answer

The 'Grand Total' feature is only available for crosstab visualizations.

Question 10

Which feature allows you to see the underlying data for a specific mark in a visualization in a tabular format?

Accepted Answer

View Data. The 'View Data' feature is a fundamental tool for data exploration and validation. It allows analysts to inspect the granular records that compose an aggregated mark. This is crucial for verifying data accuracy, troubleshooting unexpected results, and gaining a deeper understanding of the row-level details that drive high-level visual trends during the exploratory data analysis process.

Answer

Show Me

Answer

Data Interpreter

Answer

Tooltip editor

Question 11

When creating a histogram, what does Tableau automatically generate to bin the continuous measure?

Accepted Answer

A new Bin field. Tableau simplifies the creation of histograms by automatically generating a numeric bin field. This feature is essential because histograms require continuous measures to be discretized into equal intervals to visualize frequency distributions. Understanding this process allows analysts to adjust bin sizes manually to better reveal the shape, center, and spread of the data distribution, which is vital for identifying patterns and outliers.

Answer

A new Set

Answer

A new Group

Answer

A new Parameter

Question 12

You have a view with two dates: 'Order Date' and 'Ship Date'. You want to calculate the average time between these two dates. What is the most effective approach?

Accepted Answer

Use the DATEDIFF function. Calculating the duration between two dates is a common analytical task requiring the DATEDIFF function. This function returns the difference between two date fields based on a specified interval (e.g., days). By using this calculation, you can then aggregate the duration using an average to understand operational efficiency. This is a critical metric for supply chain and logistics analysis within many business contexts.

Answer

Use the DATEPART function for each date

Answer

Subtract the two date fields directly

Answer

Create a Set for each date

Question 13

You want to show the distribution of Sales across different states and highlight the ones that are performing above the national average. What is the most straightforward way to visualize this?

Accepted Answer

Use a Reference Line. Reference lines are the most efficient way to add a benchmark to a visualization. By adding a reference line representing the average of the data, users can immediately identify states that fall above or below the threshold. This provides instant visual context and helps stakeholders make data-driven decisions regarding performance, avoiding the need for complex calculations or extra visual clutter.

Answer

Create a calculated field to flag values above average

Answer

Use a Trend Line

Answer

Change the mark color to red and blue

Question 14

Which Tableau feature enables you to combine multiple worksheets into a single interactive display, where filtering one worksheet affects the others?

Accepted Answer

Dashboard. Dashboards are the core container for interactive analysis in Tableau. By integrating multiple worksheets and leveraging filter actions, you create a cohesive user experience where users can explore data across different dimensions. This functionality is essential for business reporting, as it transforms static charts into a dynamic, narrative-driven interface that allows for deep exploration of complex business metrics.

Answer

Story

Answer

Data Source Page

Answer

Workbook

Question 15

Refer to the exhibit. How can you change the visualization to show the relative contribution of each region instead of raw Sales totals?

Accepted Answer

Use a Quick Table Calculation: Percent of Total. Using Table Calculations like 'Percent of Total' transforms raw values into proportions, which are often more insightful for comparing relative performance across regions. This shifts the focus from magnitude to contribution, allowing for better identification of dominant or underperforming areas within the data. This is a common requirement in geographic analysis where absolute numbers can obscure the regional share of the business.

Answer

Create a parameter to divide by total sales

Answer

Filter out the top performing regions

Answer

Use the 'Running Total' calculation