Salesforce Analytics-101 - Salesforce Certified Tableau Desktop Foundations

A Relative dates filter is designed for date ranges that dynamically change relative to the current date, making B correct. This filter can represent periods such as the current week, previous month, year to date, or the last specified number of days, weeks, months, quarters, or years. The important distinction is that a relative date filter is dynamic. As the current date advances, Tableau recalculates the applicable range when the view is opened or refreshed. This behavior is appropriate for requirements based conceptually on TODAY() because the filter should continue tracking the present period rather than retaining fixed start and end dates. A Range of dates filter establishes a specific date interval and is better suited to fixed boundaries. A Starting Date or Ending Date represents an open-ended boundary from a particular date rather than a dynamically shifting interval relative to today. Tableau's official documentation states that relative date filters dynamically update to display a time period relative to when the view is opened. Examples include the current week, year to date, or past ten days. This functionality allows analysts to create dashboards that consistently display the most recent period without manually editing the filter as calendar time progresses. Relevant topics include date fields, relative date filtering, dynamic analysis, and interactive filter configuration.

Relationships are designed to preserve each table's level of detail and keep logical tables separate within the data source, making A and B correct. Unlike physical joins, relationships do not flatten participating tables into one combined row-level table when the data source is created. Tableau keeps each logical table distinct and evaluates the relationship dynamically based on fields actually used in a visualization. This architecture helps Tableau analyze data residing at different granularities while reducing the duplication and data-loss risks that can occur with fixed physical joins. Tableau's official relationship documentation explicitly states that relationships maintain each table's native level of detail and create independent domains at multiple granularities. The tables are not merged together in the data source. Option C describes the behavior of joins or unions in the physical layer. Physical tables can be combined to form one logical table, but this is not what a relationship does. Option D is also incorrect because relationships do not require the author to choose a fixed join type such as inner, left, right, or full outer. Tableau determines appropriate joins contextually during analysis. Relevant Tableau Desktop concepts include logical tables, physical tables, relationships, contextual joins, cardinality, and preservation of granularity.

Opacity is the appropriate control when the objective is to change how intense or subdued the existing colors appear. In Tableau, the Color controls on the Marks card include an Opacity slider. Moving this control toward lower opacity makes marks increasingly transparent; increasing opacity makes the applied colors visually stronger and less transparent. Therefore, C is correct. The other options modify different properties. Border adds an outline around supported mark types and does not control the overall intensity of the fill color. Reversed inverts the ordering of a quantitative color palette—for example, changing a sequential palette so that lower values receive the darker intensity and higher values receive the lighter intensity. It changes which values receive each shade rather than controlling overall opacity. Stepped Color converts a continuous quantitative palette into a specified number of discrete color bands or bins. Tableau's current Color Palettes and Effects documentation explicitly identifies Opacity as the setting used to modify the transparency of marks. It separately defines Reversed as inverting the order of colors and Stepped Color as grouping quantitative values into uniform color bins. These distinctions make Opacity the correct setting for modifying visual color intensity.

The associate should save the workbook as a Tableau Packaged Workbook (.twbx). A packaged workbook can contain the workbook itself together with copies of supported local data sources, Tableau extracts, background images, and other workbook resources. This directly addresses the scenario because the recipient does not have access to the original underlying data. When appropriate data is packaged with the workbook, the recipient can open the workbook in Tableau Desktop and interact with or modify its existing worksheets and visualizations without requiring the author's original file paths. A .twb file contains the workbook definition but normally references external data rather than packaging the required local resources. Therefore, it would not reliably solve the access problem. Creating a .hyper file alone provides an extract but does not contain the complete Tableau workbook, including worksheets, dashboards, calculations, formatting, parameters, and visualization definitions. Exporting views produces presentation-oriented outputs and does not satisfy the requirement to modify the existing Tableau visualizations. Tableau specifically recommends packaged workbooks when sharing with someone who does not have access to referenced resources or the original environment.

Double-clicking a continuous numeric measure such as Sales in an empty Tableau worksheet automatically produces a bar chart, making C correct. Tableau uses intelligent defaults when fields are double-clicked in the Data pane. With a single measure and no dimensions already defining the view, Tableau aggregates the measure—normally using its default aggregation such as SUM—and adds it to the visualization. The Automatic mark type resolves to a bar, producing a single bar representing the aggregated Sales value. Tableau's official documentation provides this exact construction using the Profit measure. It states that double-clicking Profit automatically adds the field to the view in an intelligent way, and the documented resulting visualization is a bar chart of Profit. Sales is the same type of field—a quantitative measure—so the same automatic-view rule applies. A line chart ordinarily requires an ordered dimension such as a date field to provide a sequence across which values can be connected. A pie chart requires additional categorical structure for meaningful segmentation. A text table is generally created when a dimension is double-clicked first and subsequent fields refine that cross-tabular structure. Therefore, a lone continuous numeric measure double-clicked in a new worksheet produces the automatic single-measure bar visualization.

Standard deviation is available as a native aggregation for a measure and does not require the author to create either a table calculation or a calculated field. Therefore, C is correct. When a measure is used in a Tableau view, its aggregation can be changed through the field menu. In addition to commonly used functions such as SUM, AVG, MIN, MAX, and COUNT, Tableau provides Standard Deviation and Standard Deviation (Population) as built-in aggregation choices. The calculation is performed directly over the records contributing to the current mark. Running Total and Percent of Total are different because they are table calculations. They operate on already aggregated values after Tableau has constructed the visualization and depend on the addressing and partitioning of the view. Sample covariance is supported through calculation functionality such as covariance functions but is not presented as the equivalent direct aggregation option in the basic measure aggregation menu represented by this question. Implementing covariance typically involves specifying the two expressions whose covariance is required. Tableau's official Data Aggregation documentation explicitly lists standard deviation among the aggregations available for measures, including sample and population forms. Consequently, it can be selected directly without constructing an additional calculated field or applying a quick table calculation.

Tableau visualization animations can use either a Simultaneous or Sequential animation style, and their analytical purpose is to make changes in the data easier to perceive. Therefore, A and D are correct. Under Format > Animations, Tableau provides two animation styles. With Simultaneous, all applicable transitions occur at the same time. With Sequential, Tableau stages the transition—for example, fading marks, moving or sorting them, and then displaying the updated state. This directly confirms option A. Animations are particularly useful when filters, sorts, parameters, or other changes alter the position or composition of marks. Instead of immediately replacing one static state with another, the transition helps a viewer understand how the marks changed, making patterns, movements, and differences easier to track. This supports D. The Pages shelf is a separate Tableau feature for stepping through members of a field and can create a sequence of views, but it does not define visualization animations themselves. Likewise, animation is a workbook/sheet formatting capability rather than a feature specifically defined by map visualization usage. Tableau's official Animations documentation identifies Simultaneous and Sequential as the available animation styles and describes animations as a mechanism for visually communicating changes in the view.

Tableau dashboard actions can directly change Parameters and Sets, so B and C are correct. A parameter action allows a user to modify a parameter value by interacting directly with marks in a visualization. For example, selecting a mark can assign the mark's Sales value to a parameter, which can subsequently drive a calculated field, reference line, filter logic, or another analytical component. Tableau provides the dashboard action type Change Parameter specifically for this purpose. A set action similarly modifies the membership of an existing set based on interaction with marks. The action can assign selected values to the set, add values, or remove values. This enables sophisticated interactive behavior such as proportional brushing, dynamic comparisons, drill-down effects, and conditional calculations. Tableau identifies this action type as Change Set Values. Groups and bins do not have equivalent dashboard action types that dynamically modify their definitions through viewer interaction. They are data organization constructs configured during authoring. The Tableau Actions documentation explicitly lists Change Parameter and Change Set Values among supported action types. Parameter Actions documentation confirms that visualization interaction can update the target parameter, while Set Actions documentation confirms that interactions can modify values contained in a target set.

A basic bar chart can be created from a measure without requiring a dimension, making A correct. Tableau can construct an initial visualization automatically when a field is double-clicked in the Data pane. Official Tableau documentation demonstrates that double-clicking a quantitative measure such as Profit automatically adds it to the view and creates a bar chart. At this stage, no dimension is required; Tableau displays the aggregated value of the measure as a single bar. The remaining visualization types fundamentally depend on categorical partitioning. A highlight table uses dimensions to establish the table's row and column structure and measures to encode values through color or text. A treemap normally requires one or more dimensions to define individual rectangles, with measures controlling properties such as size and color. A stacked bar requires a categorical field to partition a bar into multiple stacked segments. A dimension can certainly be added later to a basic bar chart—for example, Category on Columns and Sales on Rows—to produce multiple bars. However, the question asks which visualization can be created without a dimension. Tableau's official field-dragging documentation specifically demonstrates that double-clicking a measure alone produces an automatic bar chart.