A Data Analyst has a dataset that contains the fallowing rows of sales data.

The analyst needs to return a value of TRUE if a month has sales greater than $50,000; otherwise, the formula must return a value of FALSE.
Which two formulas achieve this goal? (Choose two.)

• A.[Sales] > 50000
• B.SUM([Sales]) IN (50000)
• C.MAX([Sales], 50000)
• D.IF [Sales] > 50000 THEN TRUE ELSE FALSE END

Comment: *

Name: *

Email: *

Verification: *

Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?

• A.INCLUDE
• B.EXCLUDE
• C.RUNNING_AVG
• D.AVG

Comment: *

Name: *

Email: *

Verification: *

You have the following chart that sorts states by the number of products each state has purchased.

Which formula should you use to include a number with the position of each state within each region?

• A.FIRST ()
• B.INDEX ()
• C.WINDOW_SUM(SUM ([Quantity]))
• D.LOOKUP (SUM ([Quantity]))

Comment: *

Name: *

Email: *

Verification: *

You have the following primary data source that contains a dimension named Dorm_Code.

You receive the following secondary data source that contains updated dorm codes.

You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?

• A.Bring in the secondary data source as a union.
• B.Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window
• C.Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New
• D.Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source

Comment: *

Name: *

Email: *

Verification: *

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.)

Correct Answer:

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

Comment: *

Name: *

Email: *

Verification: *