4 Replies Latest reply on Jan 3, 2016 9:11 PM by Renato Baruti

# The questions below use the dataset Sample - Superstore Subset (Excel), which is included in Desktop 8.

The top 10 customers by Sum of Sales represent ___ of the total profits.

a. 3.50%

b. 5.03%

c. 17.54%

d. None of the Above

With a moving average of Sales by Month and Year, smoothed with 6 months prior to and after the date, and

including current value, what was the Moving Average of Sales in June of 2012?

a. \$101,752

b. \$180,036

c. \$188,552

d. \$286,170

• ###### 1. Re: The questions below use the dataset Sample - Superstore Subset (Excel), which is included in Desktop 8.

Hii,

Can you please tell me the answers of these questions along with the steps if you know

• ###### 2. Re: The questions below use the dataset Sample - Superstore Subset (Excel), which is included in Desktop 8.

Hi Pooja,

These questions are located in the Tableau 9 Qualified Associate Study Guide. At the bottom of the link below you will find the questions and step-by-step guide on determining the answer.

http://mkt.tableau.com/files/Desktop-9-QA-Prep-Guide.pdf

• ###### 3. Re: The questions below use the dataset Sample - Superstore Subset (Excel), which is included in Desktop 8.

For Tableau  V9.2 my answers are :

1. The top 10 customers by Sum of Sales represent  14.36 % of the total profits.

Steps :

a. Filter top 10 customers by Sales desc.

b.create total_profit using LOD as : {FIXED : SUM([Profit])}

c.create profit for top 10 as : SUM( [Profit] ) / TOTAL(SUM( [Profit] ))*100

d.under analysis select Total or columns to get the answer for total profit % of top 10 .

2. what was the Moving Average of Sales in June of 2012?

Ans : \$41,544

Steps:

a.create moving avg. calc as : WINDOW_AVG(SUM([Sales]), -6, 6)

b.use month as continuous in columns .

Let me know if these are correct / incorrect .

• ###### 4. Re: The questions below use the dataset Sample - Superstore Subset (Excel), which is included in Desktop 8.

1.) The top 10 customers by Sum of Sales represent ___ of the total profits.

• Create a set using the Customer Name field. In the top tab, use top 10 by sum of sales.  This will create a set of the top 10 customers that have the most sales.
• Add the Set created to the row shelf.
• Add the Profit field to Label (make sure the Profit field is aggregated to sum).
• Right click on the Profit field in the marks card and select Quick Table Calculation->Percent of Total.

2.) With a moving average of Sales by Month and Year, smoothed with 6 months prior to and after the date, and including current value, what was the Moving Average of Sales in June of 2012?

• Right click and drag Order Date to the Columns shelf. Select Month(Order Date). This will make the date field continuous unbroken line.
• Drag the Sales field to the Rows shelf (make sure the Sales field is aggregated to sum).
• Right click on the Sales field in the Rows shelf and select Add Table Calculation.
• The following should be included in the Table Calculation dialog box:

- Calculation Type: Moving Calculation

- Summarize values using: Average

- Moving Along: Table (across)

- Previous Values: 6, Next Values: 6. Check the Include current value box

- Select Ok

• Hover over the June 2012 mark to show the the tooltip.