Learning Tableau

Home
Practice Quizzes
Blog

Learning Tableau

Accelerate your Career and Get Certified

Qualified Associate Certification Practice Quiz 2

Answer these questions using the Superstore sample data.

1. If 2013 Sales numbers were expected to increase by 10% in the following year in all customer segments, what would be the total estimated sales for Home Office in 2014?

617,498

679,248

2,385,847

2. Which product has the highest ship cost to sales ratio?

Hoover® Commercial Lightweight Upright Vacuum

Accohide Poly Flexible Ring Binders

Kensington 7 Outlet MasterPiece Power Center with Fax/Phone Line Protection

Lexmark 4227 Plus Dot Matrix Printer

3. Find the customer with the highest profit. What is his or her average shipping cost per order?

[Hint: to calculate the shipping cost per order you will need to calculate the number of orders using the count distinct function]

66.72

10.49

12.59

12.18

Be sure to click Submit Quiz to see your results!

Time is Up!

Share this:

Click to share on Twitter (Opens in new window)
Click to share on Facebook (Opens in new window)

3 thoughts on “Qualified Associate Certification Practice Quiz 2”

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

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Notify me of follow-up comments by email.

Notify me of new posts by email.

Download All Practice Quizzes

Including step-by-step solutions.

Get All Quizzes

Certified Associate Practice Quizzes

Hands-on Analysis Quiz 1
Hands-on Analysis Quiz 2
Hands-on Analysis Quiz 3
Knowledge-based Quiz 1
Knowledge-based Quiz 2
Forecasting
Trendlines
Data Manipulation
Calculations
Level of Detail
Joins and Blends

Specialist Practice Quizzes

Knowledge-based questions on Connecting to and Preparing Data
Knowledge-based questions on Exploring & Analyzing Data
Knowledge-based questions on Sharing Insights

Online Courses

Our online Tableau courses can help you get certified as a Qualified Associate or Tableau Specialist.

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.5 Instructor Rating
19,555 Students

5,452 Reviews
2 courses

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC