DRAG DROP

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)

Reveal Solution Hide Solution

Correct Answer:

Explanation:

You have the following dataset.

You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer.

Which formula should you use for the filter?

Reveal Solution Hide Solution

Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.

Add a distribution band on Profit to show the standard deviation from- 1 to 1.

Reveal Solution Hide Solution

You have the following line chart that shows the average sales by month.

Which month had the biggest increase in swage sales compared to me previous month in 2019?

Reveal Solution Hide Solution

A colleague provides you with access to a folder that contains the following files:

• Sates.csv

• Bookl.twb

• Sates.hyper

• Export.mdb

Which He contains an extract?

Reveal Solution Hide Solution

You have the Mowing dashboard.

Which two elements are floating? Choose two.

Reveal Solution Hide Solution

DRAG DROP

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

Reveal Solution Hide Solution

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.

Reference:

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

The Last() calculation is set to compute using Table (across)

Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?

Reveal Solution Hide Solution

You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution