Correct Answer: C

Correct Answer: AB

Explanation: To create an image of the chart that you can add to the annual report, you can use either the Export option or the Copy option from the Worksheet menu. The Export option will allow you to save the image as a file in a specified

location, name, and format. The Copy option will allow you to copy the image to the clipboard and paste it into another application, such as Microsoft Word. Both options will let you choose which elements to include in the image, such as title,

caption, legend, etc. References:

Export Views from Tableau Desktop to Another Application Copy and Paste Views from Tableau Desktop to Another Application

Correct Answer: A

To modify the chart to show only min and max values of both measures in each region, you need to do the following steps:

Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Line worksheet.

Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.

Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.

Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.

Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.

Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.

References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm

https://help.tableau.com/current/pro/desktop/en-us/filtering_range.htm

Correct Answer: A

To create a histogram on the Quantity field by using bin size of 3, 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 Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.

Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.

Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.

Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a # sign next to it.

Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.

Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.

References: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm

https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm

https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm

Correct Answer:

There are different ways to prepare the data in Tableau Prep, but one possible answer is:

Answer area:

Join the tables.

Aggregate the data by Sales Team.

Add the following filter to the Employees table: Sale Team - Team Alpha. To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on

the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this

by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary

table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and

selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha.

References:

[Tableau Certified Data Analyst Exam Prep Guide], page 9, section "Preparing Data"

[Tableau Help: Join Your Data]

[Tableau Help: Aggregate Your Data] [Tableau Help: Filter Your Data]