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

In Tableau, you can manage the visibility of different visualizations on a dashboard using various techniques. Among the options provided, the most straightforward method to allow users to switch between two visualizations is to use show/hide buttons.

Here ' s why each option is or isn’t suitable for the requirement:

A. A parameter and a calculated field: While it ' s possible to use a parameter and a calculated field to control which visualization is displayed, it requires creating a calculated field that responds to a parameter and then using that field to filter the view. This method can become complex and is not as user-friendly for simply showing and hiding visualizations.

B. Worksheet actions: Worksheet actions in Tableau typically allow users to interact with the data within a visualization, such as filtering data or highlighting related data points when clicking or hovering. They are not designed to control the visibility of entire visualizations on a dashboard.

C. Show/hide buttons: Show/hide buttons are a feature specifically designed to manage the visibility of dashboard elements. When you create a show/hide button, it can be configured to display or hide a particular visualization, container, or any other dashboard element when clicked. This provides a very intuitive interface for users to switch between visualizations.

D. Dashboard actions: Dashboard actions, like worksheet actions, are used to create interactions between sheets, such as filtering data or navigating to other sheets or URLs based on user interactions. They are not intended for toggling the visibility of visualizations.

Therefore, the correct answer is C. Show/hide buttons as they provide a user-friendly way to switch between visualizations on a dashboard without the need for complex calculations or actions that aren ' t meant for this purpose. The show/hide button feature is specifically designed for toggling visibility and offers a simple and effective solution for the requirement.

Parameter actions allow a user to change a parameter value by directly interacting with marks in a visualization, such as by selecting or hovering over a mark. When that parameter is referenced by a calculated field, changing the parameter immediately changes the calculation ' s result and therefore the information displayed in the visualization. This enables highly interactive experiences without requiring the user to manipulate a separate parameter control. Tableau also supports parameter actions with reference lines, filters, and SQL queries. The action does not literally convert a parameter into a filter, nor does it create a static view or restrict interaction to predefined filters. Therefore, D best represents the advantage tested here: selections in the visualization can dynamically update parameter-driven calculations and consequently change the displayed analysis.

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.

To add a column that shows the day of the week for each row, you should complete the formula as follows:

DATENAME

(

‘weekday’

, [Order Date])

 The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use ‘weekday’ as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date.

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.

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.

The correct order of the three actions is:

Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.

Aggregate the date to month and year.

From the Analytics pane, drag Forecast to the worksheet.

The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default.

The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.

The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card.

The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.

To ensure that the data is updated every hour, you need to select Extract Refreshes from the data source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an existing one. You can specify the frequency and time of the refresh, as well as any custom options or credentials. New will create a new data source, Connected Workbooks will show you which workbooks use this data source, and Connections will show you which tables or files are connected to this data source. References: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

To ensure that the data is updated every hour on Tableau Server, you would need to go to the " Extract Refreshes " option. Here, you can schedule the data extracts to refresh at the desired frequency, which in this case would be every hour.

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.

The requirement is based on total sales by store, so the filter must operate on the Store Number dimension while evaluating an aggregated Sales condition. Tableau dimension filters provide a Condition tab that can retain dimension members according to an aggregate measure, for example SUM([Sales]) > = 500. Applying that logic as an extract filter ensures that only qualifying store members are included in the resulting extract. Filtering the Sales measure by an “at least” row-level value would incorrectly evaluate individual records rather than each store’s total. A Top filter ranks members and is intended for top or bottom N selection, not for a fixed minimum total. Therefore, the analyst should filter Store Number by a condition based on Sales, which corresponds to option B.

1) Open Tableau prep

2) Create a new column ...

3) Union the sales ...

4) Join the sales ...

To change the story point format to show the current story point number out of the total number of story points, you should use the Numbers option in the Layout tab. This option will display the story points as numbers in a horizontal or vertical sequence, such as 1/2, 2/2. You can also choose to show or hide the next and previous arrows for navigation. The Numbers option will help you indicate the progress and order of your story points more clearly than the other options. References:

Creating a Story - Tableau

New in 9.0: Formatting the Story Points Navigator - Tableau

Tableau Certified Data Analyst Study Guide

Both the ZN and IFNULL functions in Tableau can be used to replace NULL values with zeros. The ZN function converts NULL to zero directly, while the IFNULL function allows you to specify that NULL should be replaced with zero. Both will result in showing zero for any NULL values in the Profits field.

The target visualization shows a subtotal after the members of each Category while retaining the individual Sub-Category rows. In Tableau, Analysis > Totals > Add All Subtotals inserts subtotal rows or columns when multiple dimensions are present on Rows or Columns. Here, Category and Sub-Category are both on Rows, so Tableau can calculate a subtotal for each Category group. Show Column Grand Totals and Show Row Grand Totals create totals for the entire view along the corresponding direction; they do not insert a separate total inside every Category section. Column Totals to Top only changes the placement of existing column totals. Because the requirement is to add a Total row for Furniture, Office Supplies, and Technology individually, Add All Subtotals is the correct command.

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.

A Tableau Web Data Connector is designed to retrieve data available over HTTP or HTTPS and make that data available to Tableau. A common use case is connecting to a web service or REST API, transforming the returned information into the structure expected by Tableau, and creating an extract for analysis. Tableau documentation lists REST APIs, JSON data, XML data, and internal web services among the sources accessible through Web Data Connectors. A WDC is not a web analytics utility for capturing site traffic, nor is its fundamental purpose generic HTML-table scraping or publishing data to a corporate website. Although newer Tableau releases are moving toward newer connector technologies, the functionality tested by this Tableau Data Analyst question remains connection to web-accessible data such as an API.

To combine the tables by using Tableau Prep and include only values from Table1 that do not match any values in Table2, you should use a left only join. A left only join is a type of join that returns only the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2). The field values from Table2 will appear as null values in the combined table. A left only join is also known as an anti-join or an exclusion join. References:

Tableau Certified Data Analyst Exam Prep Guide , page 9, section “Preparing Data”

Tableau Help: Join Your Data

Tableau Help: Left Only Join

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 apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role. References: The information is based on the following sources:

Use Data Roles to Validate your Data - Tableau

New in Tableau Prep: Automatically identify data quality issues with Data Roles

Common Characters is appropriate because the five values contain essentially the same characters but differ in capitalization, punctuation, separators, and—in one case—the order of the first and last names. Tableau Prep’s Common Characters fuzzy-matching algorithm removes punctuation, duplicates, and whitespace before evaluating the character fingerprint. Tableau specifically documents that values such as “John Smith” and “Smith, John” can be matched by this technique because their characters are equivalent despite being reordered. Pronunciation is intended for values that sound alike, while Spelling uses edit-distance similarity and is better suited to typographical variations. Manual Selection would require the analyst to choose the values explicitly instead of grouping them automatically. Therefore, B is the verified answer.

Extensions in Tableau are web-based programs that can interact with dashboards. To add a button that allows users to export the dashboard as an image, you would use an Extension object. This could be a custom extension designed to trigger the download of the dashboard view as an image.

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.

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.

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

To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace. References:

Format Dashboards - Tableau

Tableau Certified Data Analyst Study Guide

The current view contains only one aggregated Discount mark for each Vendor, so Tableau does not have enough individual marks within each vendor partition to calculate a meaningful distribution. Adding Invoice Number to Detail increases the level of detail so that each invoice contributes an individual Discount mark while Vendor remains the grouping dimension. Tableau can then calculate quartiles, median, whiskers, and outliers from the underlying distribution. Tableau’s box-plot guidance lists a dimension on Detail as one of the fundamental building blocks of a box-and-whisker plot. Changing the whisker configuration would affect how an already valid distribution is displayed but would not create the missing observations. Count Distinct and converting Discount to discrete would alter the analytical meaning rather than establish the correct mark granularity. Therefore, B is correct.

In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.

To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed. References:

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

Tableau Help: Refresh Data on a Schedule

Tableau Help: Manage Refresh Tasks

Tableau Prep ' s Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.

Using relationships: You can use relationships to link the secondary data source with the primary data source based on a common field. This will allow you to use fields from both data sources in your visualization without creating new fields or duplicating data. You can then replace references to update the dimension values. For example, you can use relationships to link the updated dorm codes with the primary data source and then replace Dorm_Code with Dorm_Code_New in your visualization.

https://community.tableau.com/s/question/0D54T00000C5ldZSAR/update-data-view-based-on-dimension

To update existing visualizations with new codes without changing the field name, using relationships to bring in the secondary data source is appropriate. Then using Replace References allows you to update the references from the old dorm codes to the new ones while maintaining the existing field name.

To organize the tables in the Data pane based on the type of data contained within the tables, you should use folders. Folders are a way to manually group fields, parameters, sets, or tables in the Data pane according to your preference. You can create folders by right-clicking on the fields or tables you want to group and selecting Folders > Create Folder. You can also drag and drop fields or tables into existing folders. You can name the folders according to the type of data they contain, such as sales, customer, product, etc. Folders can help you find and access the fields or tables you need more easily and efficiently. References:

Organize and Customize Fields in the Data Pane - Tableau

Tableau Certified Data Analyst Study Guide

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 add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting “Add Show/Hide Button.” You can also customize the appearance and behavior of the button.

To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.

The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.

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.