Learning Tableau

13 thoughts on “Certified Associate Certification Practice Quiz 2”

1. adarsh says:

   June 25, 2020 at 5:56 am

   I GOT THE QUESTION 3 AFTER DOING IT WRONG. YOU HAVE TO CALCULATE TOTAL SHIPPING COST/ DISTINCT NO. OF ORDERS

   Reply
2. Jayasree says:

   August 12, 2020 at 6:37 pm

   Hello Adarsh,

   Could you pls advise how you solved this question ? Iam unable to do it

   Regards,
   Jayasree.

   Reply
   1. LearningTableau says:

      August 12, 2020 at 6:40 pm

      Shipping cost per order = Total shipping cost divided by the number of unique orders
      Use COUNTD([Order ID]) to get the number or unique orders.

      Reply
3. kriti says:

   August 27, 2020 at 11:08 pm

   need help for question 1 and 3

   Reply
4. Jayasree Carey says:

   August 28, 2020 at 2:18 pm

   Answer for Qn 1

   Sum of Sales of Home Office in 2013 = 10%of $6,17,498 = $61,749

   Expected Sales for Home Office in 2014 = $6,17,498+$61,749

   Regards,
   Jayasree.

   Reply
5. Jady says:

   August 29, 2020 at 4:40 am

   1) You will need to add two filters:
   – customer segment = home office
   – year(order date) = 2013
   Then add SUM(Sales) in rows. To compute the next year (2014), you will have to multiply the SUM(Sales) result by 1.10 (because it’s a 10% increase)
   And boom, you’ll have 679248.

   3) Add SUM(Profit) in columns, and Customer Name in rows. Order the chart by SUM(Profit) and you will see that Andrea Shaw has the highest profit. Add a text with this formula: SUM([Shipping Cost])/countd([Order ID]) (shipping cost PER order)
   Boom, you’ll see 12.59 for Andrea Shaw.

   Reply
6. srie0918 says:

   August 31, 2020 at 4:44 pm

   Hello, could anyone please help with Q2? I’m thinking to see the ratio, you’d have to create a calculated field?

   Thanks in advance.

   Reply
7. Ivan says:

   September 8, 2020 at 8:10 am

   Q2 amswer

   1. Create calculated field
   2. Enter sum(shipping cost)/sum(sales)
   3. Move newly created calculated field into columns
   4. Move Product Names into rows
   5. Sort by new calculated field

   Reply
8. Josh Monroe says:

   September 11, 2020 at 6:22 pm

   Just create a calculated field for Ship to Sales Ratio. Sum of Shipping Cost/Sum of Sales.

   Put the product names and the new Ship to Sales ratio into a view and sort by the new calculated field.

   Reply
9. Yaseen Khan Suri says:

   October 12, 2020 at 11:45 pm

   Question one is 10%, not 110%. In the solution, it says 110%, why? Please clarify.

   Reply
   1. Wenjie Huang says:

      November 5, 2020 at 10:21 am

      Hi

      It means the sales in 2014 will increase by 10% so the sales in 2014 will be 110% of sales in 2013.

      Thanks,
      Iris

      Reply
10. devisri says:

    November 18, 2020 at 3:09 am

    i didnt get the answer for question no.3 tried with the formula sum of total shipping cost/countd(order id) am i wrong in the calculation field please reply

    Reply
    1. Wenjie Huang says:

       December 1, 2020 at 2:05 pm

       Hi

       First, you need to find the customer with the highest profit. Then find the number of unique orders for this customer to get the answer.

       Thanks
       Iris

       Reply