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

Question 1

You are analyzing sales data and need to compare the contribution of each product category to total revenue. Which chart type best facilitates this part-to-whole analysis?

Accepted Answer

Treemap. A treemap is highly effective for part-to-whole analysis because it uses area to represent relative proportions, making it easy to identify which categories dominate revenue. Understanding part-to-whole relationships is fundamental for performance monitoring in business intelligence, as it allows stakeholders to quickly assess individual category impact on the overall bottom line without needing to perform manual calculations or aggregate data in a separate spreadsheet tool.

Answer

Line Chart

Answer

Scatter Plot

Answer

Histogram

Question 2

You have a scatter plot comparing Sales and Profit. You want to see the trend line for each segment. How should you apply this?

Accepted Answer

Add Segment to the Color mark.. Adding trend lines allows users to observe the direction and strength of the relationship between variables. By adding 'Segment' to the Color mark, you force Tableau to compute a unique trend line for each segment, which is a standard procedure for segment-based performance analysis. This provides deeper insights into whether certain segments follow different patterns, which is critical for targeted marketing and strategic business planning efforts.

Answer

Change the aggregation to Average.

Answer

Create a calculated field for each segment.

Answer

Use a dual-axis chart.

Question 3

When dragging a Date field into the view, Tableau automatically creates a hierarchy. How can you modify this to display a specific, constant level of detail?

Accepted Answer

Right-click the field in the view and select a different date part.. Tableau's automatic date hierarchies allow for rapid drill-down, but analysts often need to lock a view to a specific level like 'Month' or 'Year'. By manually selecting the specific date part from the context menu or using the drop-down on the date field in the shelves, you override the default hierarchy. This control is essential for standardized reporting where consistent time-grain comparison is required across multiple dashboard views.

Answer

Drag the date field to the Filters shelf.

Answer

Create a new Data Source.

Answer

Use an LOD expression to change the date.

Question 4

Which THREE actions can be performed to improve the performance of a slow-loading visualization during the analysis phase?

Accepted Answer

Apply Extract Filters to reduce the data volume.. Optimizing visualization performance is critical for effective data storytelling. Large data volumes and complex calculations can drag down interactivity. By using extract filters, minimizing marks, and simplifying complex calculations, analysts can ensure their dashboards remain responsive. These techniques are standard best practices for ensuring that the end-user experience remains smooth, especially when dealing with large datasets typical in enterprise business intelligence environments, preventing frustration and increasing adoption rates.

Answer

Use as many quick filters as possible.

Answer

Increase the number of dashboard sheets.

Question 5

You are creating a geographic visualization. When you drag a City field onto the view, Tableau does not recognize the locations. What should you check first?

Accepted Answer

The geographic role assignment of the field.. Tableau relies on geographic roles to interpret location data. If a field isn't assigned the correct role, Tableau can't map it. Checking the geographic role is the primary troubleshooting step for mapping issues. Ensuring data fields are correctly classified is a prerequisite for creating accurate maps, which are essential for spatial analysis and identifying location-based trends in global business datasets.

Answer

The data source connection string.

Answer

The workbook file size.

Answer

The color scheme of the view.

Question 6

When reviewing a dashboard, you notice a specific mark is labeled as 'Null'. What does this typically signify?

Accepted Answer

There is missing or undefined data in the source.. A 'Null' label means the data contains missing values or the specified dimension/measure has no corresponding entry in the database. Understanding 'nulls' is vital for data quality assurance. If an analyst fails to address these, the visualization might misrepresent the data, leading to incorrect business conclusions. Analysts must decide whether to filter these out, alias them, or investigate the underlying source to ensure the final report is accurate.

Answer

The data is intentionally hidden by the server.

Answer

The data type is set to Boolean.

Answer

The visualization has too many marks.

Question 7

When creating a scatter plot, what is the impact of placing a dimension on the Detail mark?

Accepted Answer

It creates a separate mark for every member of the dimension.. Placing a dimension on the Detail mark increases the granularity of the view by creating a separate mark for each member of that dimension. In a scatter plot, where you are already mapping two measures to axes, this allows for the comparison of specific categories or items (like customers or products) without cluttering the view with headers, enabling effective visual identification of outliers and clusters.

Answer

It adds a new axis to the chart.

Answer

It automatically color-codes the marks.

Answer

It hides the labels for all data points.

Question 8

Refer to the exhibit. Why does this calculation error occur in Tableau?

Accepted Answer

The calculation mixes aggregated and non-aggregated fields in an incompatible way.. The error occurs because you are attempting to perform an operation on an already aggregated field. 'SUM([Sales])' returns a single aggregate, and 'Profit' is a raw measure; dividing an aggregate by a non-aggregate creates a mix of aggregation levels. Tableau requires all components in an expression to have the same level of aggregation, ensuring calculations are mathematically sound and consistent across the entire dataset during exploration.

Answer

The field 'Profit' must be converted to a dimension before it can be used in a calculation.

Answer

You cannot divide a measure by another measure in Tableau.

Answer

The calculation is attempting to use a field that has been filtered out of the view.

Question 9

What is the result of using a discrete color palette on a continuous measure?

Accepted Answer

The color is rendered as a series of distinct color steps.. A discrete color palette applied to a continuous measure creates distinct color ranges, often known as stepped colors. This allows users to categorize performance levels (e.g., Low, Medium, High) rather than using a smooth gradient. This technique is essential for making data more readable and enabling quick visual interpretation of performance thresholds, which helps stakeholders grasp complex quantitative data with minimal cognitive load during rapid review.

Answer

The measure is automatically converted into a dimension.

Answer

The visualization fails to render because measures must use continuous gradients.

Answer

The color is automatically assigned to every unique value in the dataset.

Question 10

Which mark type is best suited for showing the trend of sales over time?

Accepted Answer

Line chart.. A line mark type is the standard for time-series data because it highlights the continuity and direction of trends. By connecting data points, it allows the human eye to easily follow the path and identify patterns, seasonality, or anomalies. Choosing the correct mark type is fundamental to effective data storytelling and ensures that users can interpret the time-based relationships in the data without ambiguity.

Answer

Bar chart.

Answer

Scatter plot.

Answer

Heat map.

Question 11

When you have a measure on the color shelf, how can you change the center point of the diverging color palette?

Accepted Answer

Use the 'Edit Colors' dialog and check the 'Center' box to define a custom value.. Adjusting the center point of a diverging palette allows for a clearer distinction between positive and negative performance, or performance relative to a target. By manually setting the 'Center' value in the Edit Colors dialog, analysts can ensure that '0' or a specific KPI benchmark is clearly defined, preventing misleading visual interpretations and ensuring that the color intensity accurately reflects the delta from the chosen reference point.

Answer

Drag the measure to the Columns shelf and set the axis range.

Answer

Apply a filter to the measure to remove values below the desired center.

Answer

Create a calculated field that subtracts the center value from the measure.

Question 12

You are analyzing sales performance and want to compare the growth rate of two different product categories over time. Which technique is most effective for visualizing the relative performance differences regardless of the absolute scale?

Accepted Answer

Apply a 'Percent Difference' quick table calculation on the sales measure.. Using a dual-axis chart with a synchronized axis is not the solution here because the scales differ. Instead, applying a Quick Table Calculation for 'Percent Difference' or 'Year-over-Year Growth' allows you to normalize the values. This approach is essential for identifying trends in performance when categories have vastly different revenue volumes, ensuring the visual comparison focuses on rate of change rather than total value.

Answer

Change the mark type to a Gantt bar to show the start and end points.

Answer

Create a scatter plot using the sales values of both categories as axes.

Answer

Use a highlight table to display the raw sales values for each month.

Question 13

You have a dashboard displaying regional profit. You want to enable users to interactively filter the view based on profit thresholds and product sub-categories. Which TWO actions should you perform to create this user experience?

Accepted Answer

Drag Profit to the Filters shelf and select 'Range of Values'.. Adding a filter for the profit measure and another for the sub-category dimension provides the necessary interactivity. By configuring these as 'Show Filter' cards, users can dynamically adjust the view. This setup is crucial for exploratory data analysis, allowing stakeholders to drill down into specific segments without requiring the author to create multiple static versions of the same dashboard visualization.

Answer

Drag Sub-Category to the Filters shelf and select 'Wildcard match'.

Answer

Create a parameter to control the background color of the view.

Answer

Add a dashboard action to highlight marks on click.

Question 14

What is the primary difference between a Dimension and a Measure in Tableau when dragging them into a view?

Accepted Answer

Dimensions define labels and groupings, while Measures are aggregated.. Dimensions add granularity and slice the data into headers, whereas Measures are quantitative values that are aggregated by default (like SUM or AVG). Understanding this distinction is fundamental because it dictates how data is organized, grouped, and displayed on your visualizations. Misidentifying a field's role can lead to incorrect data summaries or charts that fail to represent the business question accurately.

Answer

Measures cannot be used on the Filters shelf.

Answer

Dimensions are always numbers, and Measures are always strings.

Answer

Only Dimensions can be used to color marks.

Question 15

You need to show the average sales for each region, but some regions have significantly more data points than others. Which measure aggregation ensures the most accurate comparison?

Accepted Answer

AVG(Sales). Using the 'Average' (AVG) aggregation is essential here because it normalizes the data regardless of the count of records. If you used 'Sum', the regions with more transactions would unfairly appear to perform better, even if their average transaction value is low. Using AVG provides a fair, balanced comparison that reveals true regional performance efficiency rather than just volume-based accumulation.

Answer

SUM(Sales)

Answer

COUNT(Sales)

Answer

MEDIAN(Sales)