최신Salesforce Certified Tableau Data Analyst - Analytics-DA-201무료샘플문제
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)


Explanation:
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.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current
/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro
/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE
You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.
What should you do?
You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.
You create several filters.
From the Data Source page you plan to add data source fillers
When type of filter will appear in the Edit Data Source Filters dialog box?
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.



Explanation:

To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y-axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. References:
* Build a Scatter Plot
* Understanding and Using Scatter Plots
* Scatter plot in Tableau
You have the following dataset.

You need to create the following worksheet.

The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)


Explanation:

You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.
You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.
Which object should you add to the dashboard?


Explanation:
The object that you should add to the dashboard to allow users to switch to a different dashboard in the workbook is Navigation.
Navigation objects are used to create links between dashboards or sheets in a workbook. You can add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the dashboard. You can then configure the navigation object to specify the destination dashboard or sheet that you want users to navigate to when they click on it.
You can learn more about navigation objects and how to use them in this article: https://help.tableau.com
/current/pro/desktop/en-us/dashboards_navigation.htm
You have the following dataset:

Which grouping option should you use in Tableau Prep to group all five names automatically?
You have the following visualization.

You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)


Explanation:
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
A Data Analyst has a workbook that uses an extracted data source.
The analyst publishes the workbook to Tableau Server.
Which three actions can the analyst perform from the Extract Refresh page in Tableau Server? (Choose three.)
When a Data Analyst needs to format workbook settings, which options are available in the Format Workbook panel?
A colleague provides a Data Analyst with access to a folder that has the following files:
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?