Analytics-DA-201 Salesforce Certified Tableau Data Analyst Questions and Answers

The box plot visualization displays the distribution of average profits by region. The distribution of profits is represented by the range of the box (interquartile range) and the whiskers (which often represent the total range excluding outliers). From the image provided, the South region has the smallest visible range within its box and the shortest whiskers, indicating the smallest distribution of average profits among the choices provided.

A correct year-to-date filter must satisfy two requirements: the event must belong to the current calendar year, and its date must not be later than today. DATETRUNC( " year " , [Event Date]) = DATETRUNC( " year " , TODAY()) confirms that the event and today’s date fall within the same year. [Event Date] < = TODAY() then excludes future dates within that year. Option C identifies the current year but would also include future-dated events. Option D does the opposite by explicitly selecting dates after today. Option B compares each event date with the first day of its own year and therefore does not implement YTD filtering. Tableau documents DATETRUNC as truncating a date to a specified date-part level and TODAY() as returning the current date.

Tableau ' s Layer Control is specifically designed for maps containing multiple geographic mark layers. When enabled, it gives users an interactive panel from which individual map layers can be shown or hidden and interactions with particular layers can also be enabled or disabled. Tableau Desktop authors enable this feature through Map > Map Options > Layer Control before publishing the workbook. A parameter could theoretically drive custom calculations, but it is unnecessary because Tableau already supplies native layer-visibility controls. The Filter shelf filters underlying data values rather than directly controlling geographic mark-layer visibility. A dual-axis map is also unnecessary and is more limited than Tableau ' s current multi-layer mapping architecture. Therefore, C is the direct, officially supported method for allowing users to toggle map layers independently.

A scatter plot requires two quantitative measures on opposing axes, so Math Score should be placed on Rows and History Score on Columns. To produce one mark for each student rather than a single aggregated mark, Student ID should be placed on Detail on the Marks card. The exhibit also contains a linear model line, which is created by dragging Trend Line from the Analytics pane onto the view. A reference line is different: it marks a fixed or computed value on an axis and does not model the relationship between two measures. Adding both score fields to the Marks card is also unnecessary because their positions are already defined by the Rows and Columns shelves. These steps follow Tableau’s standard scatter-plot and trend-line workflow.

To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])) . This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.

Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):

Student ID 4183: 39 (Rank 1)

Student ID 4220: 71 (Rank 6)

Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank)

Student ID 4124: 75.5

Student ID 4050: 64

Student ID 4205: 67

Student ID 4056: 66

Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.

Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.

https://help.tableau.com/current/prep/en-us/prep_calculations.htm

The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be {SUM(Sales)} . The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL

To combine the lines to appear as shown in the second chart, you should set Discount to Dual Axis. Dual Axis is a feature that allows you to show two measures on two separate axes on one chart. You can create a dual axis by right-clicking on a measure on any shelf and selecting Dual Axis from the menu. This will create two axes on one chart and synchronize their scales.

In this case, you want to show Profit and Discount on two separate axes on one chart. You can right-click on Discount on any shelf and select Dual Axis from the menu. This will create a dual axis chart that shows Profit and Discount as two lines with different colors.

The other options are not correct for this scenario. Dragging Discount to Color on the Marks card will change the color of Profit based on Discount, but it will not show two lines. Converting Discount to Discrete will change Discount from a green pill to a blue pill, but it will not affect how it appears on the chart. Dragging Discount to Columns shelf will create two separate charts for Profit and Discount, but it will not combine them. References: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures.htm https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm

The chart is partitioned into separate panes by year, and each pane contains its own horizontal reference line based on the values within that pane. Therefore, the reference-line Scope must be set to Pane , which instructs Tableau to calculate and draw a separate line for each pane rather than a single line across the entire table. The line also represents a computed mean rather than a fixed numeric threshold, so the aggregation must be Average . Tableau ' s official documentation states that Table, Pane, and Cell determine the scope of a reference line, while Average places the line at the average value along the applicable axis. A Table-scoped average would produce one overall line, and a Constant would use a manually specified value rather than recalculating per pane.

To make Sales appear automatically as shown in the second table, you should change the default number format of the Sales field. The default number format is how Tableau displays a field when you drag it to a worksheet. You can change the default number format by right-clicking on the field and selecting Default Properties > Number Format from the menu. This will open a dialog box where you can choose a category, such as Currency or Percentage, and customize the options, such as decimal places or prefixes.

In this case, you want to change the default number format of Sales to Currency with zero decimal places and a custom prefix of “S”. This will make Sales appear as “S” followed by the rounded value in thousands.

The other options are not correct for this scenario. Changing the data type of Sales to String will not affect how it appears on a worksheet. Creating a calculated field that uses a formula will not change the default number format of Sales, but create a new field that you have to drag to a worksheet. Converting Sales to Attribute will return only one value for each partition of data, which will not show any variation over time. References: https://help.tableau.com/current/pro/desktop/en-us/formatting.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_change_default.htm

To achieve the formatting as shown in the example, where sales figures are displayed with a " K " to represent thousands and rounded to the nearest thousand (e.g., $20K, $44K, etc.), you would need to adjust the default number format of the Sales field in Tableau. By changing the default number format, every instance where the Sales field is used would automatically reflect this new formatting. This is more efficient than creating a calculated field as it preserves the numeric nature of the field, allowing for further numerical operations and aggregations.

In Tableau dashboards, floating elements are those that can be freely moved over the dashboard canvas without being snapped into the tiled layout. The floating elements are often indicated by their standalone frames and the ability to overlap with other dashboard items. From the provided image, the state filter and the Rate of Obesity chart can be identified as floating if they can be moved independently of the tiled grid layout that constrains other elements.

To analyze the average revenue per product in different regions over time, you need to use two fields that contain numeric, quantitative values that you can measure and aggregate. Quantity and Revenue are both measures that fit this criterion. You can multiply Quantity and Revenue to get the total sales for each product, and then divide by the number of products to get the average revenue. You can also use these measures to create charts and tables that show the trends and comparisons over time and across regions. References:

Dimensions and Measures, Blue and Green - Tableau

Tableau Certified Data Analyst Study Guide

There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:

SUM([Sales])

LOOKUP(SUM([Sales]), -1)

PREVIOUS_VALUE(0)

 To calculate the sales growth over each year, you need to compare the current year’s sales with the previous year’s sales and divide the difference by the previous year’s sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:

(SUM([Sales]) - LOOKUP(SUM([Sales] ), -1)) / PREVIOUS_VALUE(0)

This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales] )) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.

To configure the dashboard to ensure that selecting a data point on the map only filters the Detail table, you should select Ignore Actions from the context menu of Sales over time. Ignore Actions is a feature that allows you to exclude a sheet from being affected by any actions on the dashboard, such as filters or highlights. You can select Ignore Actions by right-clicking on a sheet on the dashboard and selecting Ignore Actions from the menu.

In this case, you want to exclude Sales over time from being filtered by the map, so you should select Ignore Actions from its context menu. This will make Sales over time ignore any selections on the map and show all values. The Detail table will still be filtered by the map as usual.

The other options are not correct for this scenario. Removing Dashboard Item will delete Sales over time from the dashboard, which is not what you want. Deselecting Use as Filter will disable the map as a filter for any sheet on the dashboard, which is not what you want. Selecting Deselect will clear any selections on the map, but it will not prevent Sales over time from being filtered by future selections. References: https://help.tableau.com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_ignore.htm

On a Tableau dashboard, when a map is used as a filter, it affects all other sheets in the dashboard by default. To restrict the filter action to only affect the Detail table and not the ' Sales over time ' chart, you would modify the action settings. By selecting " Ignore Actions " from the context menu of the ' Sales over time ' chart, it will no longer respond to the filtering action initiated by selecting data points on the map.

For a published Tableau data source, the Connect capability controls whether a user can connect to that data source from Tableau Desktop and use it for analysis. Tableau permissions also determine whether the content is visible within the site and project hierarchy, but among the choices, Connect is the capability specifically associated with making a usable published data source available for connection. Certification does not restrict the list to certified sources only, and ownership is not required; users can connect to data sources created by other publishers when permissions allow it. A user’s home directory is not the governing scope for published Tableau data sources. Therefore, the correct choice is the data sources for which the user has the required Connect permission, subject to normal site and content visibility permissions.

To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a sched ule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh. References:

Tableau Certified Data Analyst Exam Prep Guide , page 10, section “Publishing and Scheduling Data Refreshes”

Tableau Help: Embedding Database Credentials

Tableau Help: Extract Your Data

A URL action is Tableau’s mechanism for opening an external web page or web-based resource from a worksheet or dashboard. Because the requirement says the page must open when the user clicks the sheet, the action should be configured as Go to URL with Run action on set to Select. Select runs the action when the user clicks a mark, while Menu requires the user to open a context or tooltip menu and choose the action explicitly. A navigation button and a Go to Sheet action move between Tableau sheets or dashboards rather than opening an external webpage. A Web Page object embeds web content within a dashboard and does not satisfy the requirement to open the specific page in the default browser when the sheet is clicked. Therefore, option C is the appropriate configuration.

To filter regions based on the highest sales and allow users to specify the number of regions shown, you should perform these actions in order:

Answer area:

Create an integer data type parameter named Param1.

Drag Region to the Filters shelf.

Configure a Top filter by field. Use Param1 and filter by the sum of Sales.

 To create a dynamic filter that lets users choose the number of regions to display, you need to use a parameter and a top filter. A parameter is a user-defined variable that can be used in calculations, filters, and reference lines. A top filter is a type of filter that shows only the top or bottom N values based on a specified field or expression.

In this question, you want to filter regions based on the highest sales. You also want users to be able to specify the number of regions shown. To achieve this, you need to follow these steps:

First, you need to create an integer data type parameter named Param1. This parameter will allow users to enter a number that will determine how many regions to show. You can create a parameter by right-clicking on the Data pane and selecting Create Parameter. Then, you need to specify the name, data type, current value, and allowable values for the parameter. In this case, you can choose Integer as the data type, 10 as the current value, and All as the allowable values. You also need to show the parameter control by right-clicking on the parameter and selecting Show Parameter Control. This will display a slider or a text box where users can enter or adjust the parameter value.

Next, you need to drag Region to the Filters shelf. This will open the Filter dialog box, where you can choose how to filter the Region field. You can filter by general, wildcard, condition, or top. In this case, you want to filter by top, so you need to select the Top tab.

Finally, you need to configure a top filter by field. Use Param1 and filter by the sum of Sales. This will filter the Region field by showing only the top N regions based on the sum of Sales, where N is the value of the parameter Param1. You can configure a top filter by field by selecting By field in the Top tab, then choosing the parameter Param1 from the drop-down list, and selecting the aggregation function Sum and the field Sales from the other drop-down lists. This will create a filter expression that looks like this: Top Param1 by SUM(Sales).

By following these steps, you will create a filter that shows only the regions with the highest sales, and allows users to change the number of regions shown by adjusting the parameter value.

Revenue and Quantity are the two quantitative fields that must be measured to calculate average revenue per item. The analyst can derive the required business metric by relating the monetary Revenue measure to the Quantity measure, such as revenue divided by units sold at the appropriate aggregation level. Customer Region is required to segment the analysis geographically, but it is a dimension rather than the numeric value being measured. Order Date provides the time dimension for analysing the metric over time, and Product Name can further categorise the data, but neither is the primary quantitative measure required by the question. Tableau defines measures as quantitative fields that can be numerically aggregated, while dimensions are qualitative fields used to group or segment the data. Therefore, Revenue and Quantity are the appropriate selections.

A standard dimension filter is evaluated after a FIXED Level of Detail expression in Tableau’s order of operations. FIXED LOD calculations establish their result using the dimensions specified in the expression without reference to the dimensions currently in the view, and they are computed before ordinary dimension filters. Consequently, applying a normal dimension filter changes which marks or records are displayed in the worksheet, but it does not recalculate the FIXED result based on that filter. If the analyst needs the filter to affect the FIXED LOD, the filter can be promoted to a context filter because context filters are evaluated earlier. The question specifies only a dimension filter, so the correct behavior is that the displayed data changes while the FIXED LOD calculation remains unaffected.

Publishing a new data source from Tableau Desktop requires publishing rights that are available with a Creator site role, together with the necessary project capabilities. Tableau documents Creator as the site role that provides full connection and publishing access from Tableau Desktop, including the ability to create and publish data sources, workbooks, and flows. Server administrator rights are not required for ordinary publishing. A Tableau Public account applies to Tableau Public rather than publishing governed content to Tableau Server or Tableau Cloud. View permission alone is also insufficient because viewing an existing project or workbook does not grant the Save and publish capabilities needed to create a new published data source. Therefore, among the listed choices, a Creator site role is the required condition.

You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for “Central” as “Midwest”.

In Tableau, aliases can be used to change the way dimension members appear without altering the underlying data. This is useful for display purposes and does not create a new field within the dataset.

B is the verified answer; the selection shown in the candidate PDF is not reliable here. The difficulty is that FullName contains a variable number of space delimiters. A simple “split all” operation would produce First | Last for a two-part name but First | Middle | Last for a three-part name, so the second result column does not consistently represent the middle name. Tableau’s Custom Split functionality allows splitting from the first or last occurrences of a delimiter. The analyst can therefore reliably extract the first and last names regardless of whether a middle name exists, and derive the middle component when present. Tableau’s documentation notes that Custom Split provides control over first N, last N, or all occurrences and is useful when separator counts vary between records.

Tableau Desktop supports custom mark shapes by loading image files from the Shapes folder inside My Tableau Repository. The analyst should copy the new shape files into a folder under My Tableau Repository\Shapes. Tableau uses that folder as a custom shape palette, and the analyst can then select the shapes from the Marks card by choosing Shape and editing the shape assignment. Once custom shapes are used, they are stored with the workbook, which supports sharing the visualization with other users. Dragging image files directly into a workbook does not register them as reusable mark shapes, and a URL cannot be used as the workbook’s shape repository. My Tableau Prep Repository is also incorrect because Tableau Prep is not where Tableau Desktop mark-shape palettes are stored.

Sales:  B. Columns

Profit:  D. Rows

Customer Name:  C. Detail on the Marks card

Category:  A. Color on the Marks card

To create the visualization, you need to drag Sales to Columns, Profit to Rows, Customer Name to Detail on the Marks card, and Category to Color on the Marks card. This will create a scatter plot that shows the relationship between Sales and Profit for each Customer Name, with different colors for each Category.

To resume a suspended alert, you need to go to the My Content area of Tableau web pages, where you can see all the alerts that you own or subscribe to. You can click on the alert name and then select Resume from the menu. You can also edit or delete the alert from there. References: https://help.tableau.com/current/pro/desktop/en-us/alerts.htm https://help.tableau.com/current/pro/desktop/en-us/alerts_manage.htm

In Tableau, the " My Content " area on the web interface is the place where a user can manage their content, including workbooks, data sources, and alerts. If an alert is suspended, the owner of the alert can go to the " My Content " area to resume it.

Tableau CASE logic evaluates one expression and compares its result against the values provided in successive WHEN clauses. In option B, the initial expression evaluates whether aggregated Profit is greater than zero, producing a Boolean result. WHEN TRUE then returns “Profitable,” while the ELSE branch returns “Unprofitable.” The other choices do not follow valid CASE comparison structure. Option A attempts to use OR between string literals inside one WHEN value. Option C places the comparison operators before values rather than supplying values that can be compared against the CASE expression. Option D similarly combines a string literal with an AND condition in a WHEN clause that is being compared against Category. Tableau’s documented CASE structure is CASE < expression > WHEN < value > THEN < result > ... ELSE ... END, making B the valid choice among those provided.

There are different ways to prepare the data in Tableau Prep, but one possible answer is:

Answer area:

Join the tables.

Aggregate the data by Sales Team.

Add the following filter to the Employees table: Sale Team - Team Alpha.

 To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha.

Set actions allow selections made in a worksheet or dashboard to update membership in an existing set. That set can then be used in calculations or placed on the Marks card to change how another visualization is encoded. A common design is to place set membership on Color, so selecting marks in a source view changes which marks are in or out of the set and therefore changes their colors in a target view. This is exactly the interaction described in option B. Set actions are not intended to join or filter across unrelated data sources automatically, and pie-chart dataset-size comparison is simply a chart-design task. Likewise, highlighting proportions in a Gantt chart is not a defining set-action behavior. The key mechanism is selection-driven set membership that controls a visual property such as Color.

The question presents a scenario where a geographic map visualization in Tableau needs to be transformed from a series of discrete circles representing data points to a density map visualization. The density map shows concentrations of data points with a gradient of color, where denser areas are indicated by a darker color.

Here ' s the explanation for each option:

A. Change the mark type to Density: This is the correct answer because changing the mark type to ' Density ' in Tableau creates a density map, which displays the concentration of data points with a color gradient. This is exactly what is needed to achieve the visual effect shown in the second image, where regions with a higher concentration of data points are represented by darker shades.

B. Drag Location to Size on the Marks card: This option would adjust the size of the marks based on the number of locations, which is not relevant to creating a density map. It would result in varying sizes of circles, not a continuous gradient.

C. Change the mark type to Map: The visualization is already using a map. This option would not change the visualization to the desired density map.

D. Drag Population to Size on the Marks card: This would change the size of the circles based on the population values, making some circles larger and others smaller. This is not how a density map is created, which uses color intensity rather than size to show concentration.

E. Change the opacity to 75%: Changing the opacity would affect the transparency of the marks on the map but would not transform the visualization into a density map.

To achieve the visualization shown in the second image, the mark type must be changed to ' Density, ' which will produce a heat map-like effect where the color intensity represents the concentration of data points. Therefore, the correct answer is A. Change the mark type to Density .

To create a density map from a scatter plot of data points, you would change the mark type to Density. This mark type allows you to visualize the concentration of data points in an area, which can be useful for identifying clusters or patterns in geospatial data.

1) Open Tableau prep

2) Create a new column ...

3) Union the sales ...

4) Join the sales ...

Publishing the Excel-based goals data as its own managed data source provides the most appropriate architecture for a file that must be updated regularly and reused alongside an existing published revenue source. The analyst can publish the Excel connection as an extract and configure the appropriate refresh mechanism, after which the dashboard workbook connects to both centrally governed published sources. Tableau documents that published extract data sources can be refreshed on a schedule and that every connected workbook then benefits from the refreshed data. Merely embedding an Excel extract in one workbook would couple refresh management to that workbook, while simply uploading a flat file through web authoring does not guarantee updates to the original changing file. Modifying the ERP system is unnecessary. Therefore, option D provides the intended reusable and maintainable Tableau design.

A reusable custom color palette is defined through Tableau’s preferences configuration rather than by formatting a single worksheet. The Preferences.tps file resides in My Tableau Repository and uses XML tags to define named color palettes and their color values. After the palette is added and Tableau Desktop is restarted, the palette becomes available from the color-palette selector and can be used across workbooks, which matches the branding requirement. Custom shapes are unrelated because they control mark appearance rather than color definitions. Worksheet shading affects only formatting in a particular workbook or sheet, and the standard color picker does not create the same reusable named palette in the manner described by this question. Therefore, modifying the XML in Preferences.tps is the correct exam-aligned method.

we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:

IF FIRST () = 0 THEN COUNT (Returns) END

This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL.

To complete the formula in the calculated field, you should select the following options from the drop-down menus:

FIRST ()

0

COUNT (Returns)

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm

To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page. References: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm

When connecting to a dataset in Tableau Desktop, you would go to the ' Data ' menu and select ' New Data Source ' . This allows you to connect to various types of data sources, including Microsoft Excel spreadsheets, where you can then select the specific file you wish to connect to.

Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.

A data source filter is a filter that applies to all the worksheets that use the same data source. It filters the data before any other filters or calculations are applied. You can add a data source filter from the Data Source page by clicking on the Add button next to Filters.

The type of filter that will appear in the Edit Data Source Filters dialog box is a dimension filter on all the sheets. This means that you can choose a dimension from your data source and filter it by values, range, condition, or top/bottom. The filter will affect all the worksheets that use that dimension.

The other types of filters are not data source filters and will not appear in the Edit Data Source Filters dialog box. A table calculation filter is a filter that applies to a table calculation, such as percent of total or running total. A top N condition filter is a filter that shows only the top or bottom N values of a measure or dimension based on a condition. A context filter is a filter that creates a subset of data that other filters can use.

To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.

The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau. ISFULLNAME([Tableau_user] ) = USERNAME() is not a valid expression in Tableau. ‘S’ + STR([Sales]/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of “S”. References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields.htm

In Tableau, the USERNAME() function returns the username of the user who is currently logged in. To create a filter that only shows data relevant to the logged-in Tableau user, a boolean calculated field can be created to compare the current username with the usernames listed in the Tableau_User_Name field of the dataset. Therefore, the correct formula for this filter is USERNAME() = [Tableau_USER_NAME] , which will return true for rows where the Tableau_User_Name matches the current user ' s username.

Tableau relationships provide a logical-layer approach to combining tables without requiring a fixed join type when the data source is created. The related tables remain separate, preserving their native level of detail. When a visualization is queried, Tableau evaluates the fields currently being used and automatically determines the appropriate joins required for that analytical context. This makes relationships dynamic and context-aware. Option A is incorrect because the matching fields that define the relationship are established when the relationship is configured; they do not change simply because of user interactions. Option B is incorrect because relationships do not store the entire data source in a pre-aggregated format. Option D describes physical joining more closely because relationships specifically avoid merging all related tables into one physical table. Therefore, C accurately describes the principal advantage.

To get the number of different types of awards that have been won, you should use the formula COUNTD({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.

The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau. MAX({Award}) will return the maximum value in the Award field, which may not be a type of award. INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards. References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#COUNTD https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#INDEX

The COUNTD function in Tableau calculates the number of distinct (unique) items in a field. When looking to get the number of different types of awards that have been won, the COUNTD([Award]) function will count each unique award name only once, regardless of how many times it appears in the dataset. This will return the total number of unique award types.

To refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules. References: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

On Tableau Server, you can manage the scheduling of extract refreshes by selecting the specific workbook and configuring additional refresh schedules as needed. This allows for multiple refresh triggers, such as the regular Monday at 10:00 AM schedule, as well as an additional trigger for the last day of the month at 18:00.

Tableau provides various options to export data from a worksheet. The formats available are typically those that are best suited for visualization or further data analysis. The options include:

.png for exporting images of the visualizations

.xlsx for exporting data in a format that can be opened with Microsoft Excel

.pptx for creating PowerPoint presentations with the visualization embedded

These formats are designed to facilitate sharing and presenting the insights derived from Tableau visualizations, or for conducting further analysis in tools like Excel.

Replace Data Source

Replace Data Source is a feature that allows you to replace one data source with another one that has the same or similar fields and structure. It updates all the worksheets that use the original data source with the new one, without reloading the data. In this case, you want to replace the data source that contains order data from 2019 with the one that contains order data from 2020.

To replace the data source, you need to do the following steps:

Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the original data source.

Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.

Select the data source that contains order data from 2020 from the list of available data sources and click OK. This will replace your original data source with the new one and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.