Analytics-DA-201 Exam Dumps - Salesforce Certified Tableau Data Analyst

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.

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.

https://kb.tableau.com/articles/howto/filtering-data-with-a-parameter?lang=fr-fr

After creating a parameter named Choose Region, you want to use it to filter the chart based on the user ' s selection. To do this, you would create a calculated field with the formula [Region] = [Choose Region] and add this calculated field to the Filters card. This will dynamically filter the chart to display data only for the region that matches the user’s selection in the Choose Region parameter.

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.

A Running Total accumulates the measure sequentially across the addressing dimension. With Year on Columns and SUM(Downloads) in the view, Tableau starts with the first year ' s downloads and progressively adds each subsequent year ' s value to the accumulated total. The resulting bars therefore represent all downloads received up to each year since release rather than the downloads for that individual year alone. YTD Total is intended for accumulation within a calendar year and commonly restarts with the new year. Percent of Total expresses each value as a proportion of the full partition, while Year Over Year Growth compares the relative change between consecutive annual values. Tableau lists Running Total as a standard quick table calculation specifically for cumulative analysis. Therefore, B is the appropriate calculation.

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.