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

Question 1

You want to show the distribution of Sales values. Which mark type is automatically selected by 'Show Me' when you select a single continuous measure?

Accepted Answer

Histogram. Tableau's 'Show Me' feature is designed to recommend the best visualization based on the data types selected. For a single continuous measure, a histogram is the standard statistical representation of distribution. Understanding these defaults is vital for beginners, as it provides a quick path to standard analytical views without requiring manual configuration of bins or axis settings, promoting efficiency in early-stage data exploration.

Answer

Bar Chart

Answer

Line Chart

Answer

Scatter Plot

Question 2

You have a list of dates. You want to see the year-over-year growth for Sales. Which Table Calculation is most appropriate?

Accepted Answer

Percent Difference. Table calculations are powerful for performing complex arithmetic directly on the aggregated data in the view. 'Percent Difference' is the industry-standard calculation for growth metrics. Learning to apply this calculation is essential for business analysts, as it transforms raw numbers into actionable performance indicators that track progress over time, which is a fundamental requirement for most financial and operational reporting tasks in Tableau.

Answer

Running Total

Answer

Moving Average

Answer

Rank

Question 3

A user wants to compare the year-over-year sales growth percentage for three different regions. Which approach provides the most accurate analytical view?

Accepted Answer

Apply a Percent Difference quick table calculation and set the Relative to setting to Previous.. Using a Quick Table Calculation for Year-over-Year Growth allows Tableau to compute the percentage difference between the current year and the previous year automatically. This method is preferred over manual calculated fields because it is dynamic, responding to filters and hierarchy changes instantly. Understanding this technique is vital for analysts performing time-series analysis while maintaining clean, maintainable, and interactive dashboard components for stakeholders.

Answer

Create a calculated field using the formula (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / LOOKUP(SUM([Sales]), -1).

Answer

Use a Running Total quick table calculation and divide by the total sales for the region.

Answer

Create a set of years and use an IF statement to compare the current year to the prior year.

Question 4

When dragging a continuous date field from the Data pane onto the Columns shelf, what is the default behavior in Tableau?

Accepted Answer

Tableau automatically generates a line chart with a continuous axis.. Tableau defaults to a continuous range represented by a green pill on the shelf. This behavior enables the creation of time-series axes rather than discrete headers. Mastery of discrete versus continuous fields is fundamental to Tableau, as it dictates how data is aggregated, how axes are rendered, and how colors are assigned, forming the bedrock of effective visual data exploration and trend identification.

Answer

Tableau displays individual headers for each date value as a discrete dimension.

Answer

The data is automatically aggregated into the Year level without showing the full range.

Answer

Tableau prompts the user to select between a discrete or continuous format before placing it.

Question 5

You are analyzing store performance and notice that one store has a null value for its profit margin. How does Tableau handle this null value when creating a line chart?

Accepted Answer

Tableau connects the lines between the non-null data points, effectively ignoring the null value.. By default, Tableau connects the data points on either side of a null value with a continuous line, effectively ignoring the gap. Understanding how nulls impact visual interpretation is critical for data integrity. Analysts must decide whether to 'Show at Default Value' or 'Connect' the points, as hidden nulls can lead to erroneous conclusions about performance trends if the data is not fully represented on the axis.

Answer

Tableau breaks the line, creating a gap in the visual representation at the point of the null.

Answer

Tableau displays a zero value at the null position, potentially skewing the trend line downward.

Answer

Tableau automatically filters out the entire record associated with the null value.

Question 6

Which THREE of the following actions can you perform to increase the level of detail in a visualization?

Accepted Answer

Drag a dimension onto the Detail card.. Increasing the level of detail is a core Tableau skill that enables deeper investigation into data patterns. By adding dimensions, using the Detail mark, or nesting hierarchies, analysts reveal underlying variations that are often obscured by high-level aggregations. Mastering these methods ensures that complex datasets are broken down into actionable, granular segments that provide meaningful insights for business decision-making and performance monitoring.

Answer

Change the aggregation from SUM to AVG.

Answer

Drag a measure onto the Color shelf.

Question 7

Which TWO of the following are valid ways to filter data in Tableau?

Accepted Answer

Dragging a field directly onto the Filters shelf.. Filters are essential for focusing analysis on relevant data segments. Tableau provides multiple entry points for filtering, including the Filters shelf, interactive dashboard actions, and context menus on the canvas. Mastering these filtering methods allows analysts to create responsive, user-friendly dashboards where end-users can narrow down information without requiring knowledge of the underlying data source structure or complex query syntax.

Answer

Using the 'Filter' icon in the top toolbar.

Answer

Setting a filter in the 'Data Source' tab that affects all sheets.

Answer

Writing a custom SQL query for every single filter required.

Question 8

Which THREE of the following are valid ways to add a reference line to a view in Tableau?

Accepted Answer

Drag 'Reference Line' from the Analytics pane to the view.. Reference lines are essential for adding context to data, such as targets or averages. Knowing how to access them via the Analytics pane, the Axis menu, or through specific mark settings is critical for building informative dashboards. These methods provide flexibility to the author, allowing for quick visual benchmarks that help users immediately grasp whether performance meets expectations or exceeds historical averages.

Answer

Go to the 'Format' menu and select 'Reference Lines'.

Answer

Use the 'Add' button on the Marks card.

Question 9

When creating a dual-axis chart in Tableau, which TWO configuration steps are required to ensure the axes are aligned correctly for interpretation?

Accepted Answer

Right-click the second measure and select 'Dual Axis'.. To successfully create a dual-axis chart, you must first enable the dual-axis by right-clicking the second measure, and then synchronize the axes if the scales require direct comparison. These steps ensure that the visual markers are positioned correctly relative to each other. Without synchronization, the viewer might misinterpret the data, as the two measures would be plotted against different scales, leading to false conclusions about their relative growth or magnitude.

Answer

Change the mark type of both axes to 'Automatic'.

Answer

Convert both measures to discrete values.

Answer

Drag the second measure to the Detail mark.

Question 10

When dragging a date field to the view, Tableau automatically converts it to a 'Year'. How can you change this to display 'Month'?

Accepted Answer

Right-click the date pill and select 'Month' from the list.. Tableau offers a hierarchy for date fields. By clicking the '+' sign on the pill or using the context menu to select a different date part, you can drill down or switch levels. This flexibility allows users to shift from high-level annual trends to detailed monthly or daily insights instantly, which is vital for spotting seasonal patterns or anomalies in time-series data during exploratory analysis.

Answer

Delete the pill and drag it in again.

Answer

You cannot change the aggregation once it is in the view.

Answer

Create a new calculated field for 'Month'.

Question 11

You are building a dashboard and notice the 'Sales' data is not filtering correctly when you apply a global filter. Which TWO issues could be causing this discrepancy?

Accepted Answer

The filter is only set to 'Only This Worksheet'.. If a filter isn't working globally, it is likely because the filter is only applied to the specific worksheet or because the underlying data source is not shared across all views. Checking the 'Apply to Worksheets' settings and ensuring the data sources are correctly blended or joined is the first step in troubleshooting. These are common configuration errors that prevent dashboard synchronization.

Answer

The filter is a parameter, not a dimension.

Answer

The filter is a 'Wildcard' filter.

Answer

The filter is on the Pages shelf.

Question 12

You want to highlight high-profit products in a bar chart while keeping the rest of the chart visible but dimmed. What is the best method to achieve this?

Accepted Answer

Create a set based on profit and use it as a color shelf item.. Using a Highlight Action or creating a set and dragging it to color is the most effective approach. This technique allows for comparative analysis by drawing the eye to the key information while keeping the context of the entire dataset. It is a fundamental design principle in Tableau that enhances readability and helps users focus on the most important performance metrics without cluttering the visualization with too many colors.

Answer

Manually select the bars and hide them.

Answer

Change the background color to white.

Answer

Apply a filter to only show high-profit items.

Question 13

You are analyzing sales data by region. You want to identify the top 5 products by profit for each region simultaneously. Which feature should you use to achieve this in a single view?

Accepted Answer

Create a Set on Product Name based on top 5 profit, then add this set to the Filters shelf.. Using a Top N Filter combined with the Set feature or a calculated field allows for partitioned analysis. By creating a Set on Product Name based on Profit and adding it to the Filters shelf, you isolate the top performers. Understanding how to scope top N calculations per category is critical for effective comparative analysis in Tableau dashboards.

Answer

Create a Top 5 Set on Product Name and place it on the Rows shelf.

Answer

Apply a Top 5 filter on Product Name using the 'Top' tab and select 'By field'.

Answer

Sort the Product Name field in descending order by Profit and limit the rows to 5.

Question 14

You have a continuous date field on the Columns shelf and a measure on the Rows shelf. You want to see the trend change at the daily level, but you only see a single data point representing the entire range. What is the most likely cause?

Accepted Answer

The date field is set to Discrete instead of Continuous.. Tableau aggregates data by default when measures are present. If a date field is treated as a discrete dimension or if the aggregation level is set too high, the trend line collapses. Changing the date field to continuous or adjusting the granularity ensures that the time series is properly plotted across the axis, which is fundamental for accurate trend analysis.

Answer

The data source contains only one record for the entire date range.

Answer

The measure aggregation is set to Count instead of Sum.

Answer

The date field needs to be converted to a string data type.

Question 15

Which TWO of the following statements accurately describe the behavior of 'Measure Names' and 'Measure Values' in Tableau?

Accepted Answer

Measure Names can be used as a dimension to split data into separate marks.. Understanding the generated fields Measure Names and Measure Values is essential for building dual-axis charts and custom tables. These fields allow users to display multiple measures in a single view by pivoting the data structure virtually. Mastering this concept enables analysts to create complex, multi-layered visualizations that go beyond simple single-measure charts, facilitating richer data exploration.

Answer

Measure Values can be used to perform complex table calculations across different data sources.

Answer

You can add any dimension to the Measure Values shelf to improve granularity.

Answer

Measure Names is a measure that can be averaged or summed like other numeric fields.