Salesforce Analytics-DA-201 Practice Exam Questions & Answers

Explanation

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. Reference: 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.

Explanation

To create a filled map to show the distribution of total Sales by State across the United States, you need to do the following steps:

Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.

Click on the Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.

Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.

Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.

Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.

Explanation FIXED level of detail expressions calculate at a specific granularity regardless of what's in the view. When you add a dimension filter to context, it applies globally to all calculations including LOD expressions. This ensures the five excluded states are removed before the FIXED calculation runs. Right-clicking the filter and selecting Add to Context moves it above all other filters in calculation order.

Explanation The EXCLUDE function removes specific dimensions from a LOD calculation, allowing you to compute values at a less detailed level. If you want to average sales without certain dimensions affecting the result, EXCLUDE does exactly that. INCLUDE adds dimensions, FIXED ignores view dimensions entirely, and REPLACE switches dimensions. Only EXCLUDE lets you deliberately remove granularity while keeping others.

Explanation When you have a new data source published to Tableau Server that contains updated or additional data, you replace the old one using the Replace Data Source option from the Data menu. This approach works within the existing workbook and dashboard structure. Simply adding a new worksheet or creating a new dashboard would duplicate effort. Downloading and republishing affects version control and site organization.

Explanation

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.

Explanation Converting a date field to continuous in Tableau creates a linear axis where months display in chronological order as equally spaced points. Discrete dates create separate bars or marks for each month. For a cumulative sales chart showing progression over time, continuous dating provides the right visual progression. Sorting or renaming dates won't give you the continuous axis behavior needed for this type of chart.