Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with CertsForce

To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu. References: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_size.htm

In a dual-axis chart in Tableau, if you want to have two different visual mark types (like a shape and a line) and configure them differently (such as making one larger than the other), you would need to duplicate the measure. You then drag this duplicate to the second Marks card (which represents the second axis). There, you can adjust the size of the marks (shapes, in this case) independently of the line marks on the first Marks card.

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.

To unsubscribe from the views, you should use the My Content area of Tableau web pages. This area allows you to manage your subscriptions, as well as your workbooks, views, and data sources. You can select the views you want to unsubscribe from, click Actions, and then click Unsubscribe. You can also change the subscription options, such as the schedule, the format, or the message. References:

Create a Subscription to a View or Workbook - Tableau

Tableau Certified Data Analyst Study Guide

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.

To complete the formula, you should drag the option MAX from the list of options and drop it into the first blank space, and then drag the option [Sales] and drop it into the second blank space. The formula will look like this: Option (MAX) Option ([Sales] ). This formula will calculate the maximum value of the sales field for each country. You can use this formula to create a calculated field that will show the highest sales amount for each country in your data source. References:

Create a Simple Calculated Field - Tableau

MAX Function - Tableau

Tableau Certified Data Analyst Study Guide

A Top N filter is applied to categorical members, so the field being filtered should be a discrete dimension. When a discrete dimension is placed on the Filters shelf in Tableau Desktop, the Filter dialog provides General, Wildcard, Condition, and Top tabs. The Top tab can then retain the top or bottom N members based on an aggregate measure, such as the top 10 customers by SUM(Sales). A continuous measure uses quantitative range filtering rather than the dimension-member Top interface. A table calculation is evaluated later in Tableau’s order of operations and is not the field type used to configure a standard Top N dimension filter. A set can itself be defined using a Top rule, but it is a separate object rather than the required field type for this filter. Therefore, C is correct.

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.