ExamGecko
Home / Tableau / Desktop Certified Associate / Practice Test 1
Ask Question

Tableau Desktop Certified Associate Practice Test 1

Add to Whishlist
00:00:00
Show Answer
Report Issue   Restart test

Question 1 / 40

Connect to the 'Global Superstore' data source and find out which 'Customer Name' (ignore the customer ID) has returned the highest percentage of his\her orders?

Michael Oakman
Michael Oakman
Daniel Lacy
Daniel Lacy
Greg Tran
Greg Tran
Yoseph Carroll
Yoseph Carroll
Comment (0)
Suggested answer: B
Explanation:

Left join the Orders and Returns table

Tableau Desktop Certified Associate image Question 1 explanation 75931 09232024004713000000

Number of orders returned will be order ID from the returns table divide by total orders

Tableau Desktop Certified Associate image Question 1 explanation 75931 09232024004713000000

Drop the customer name and ret order field in the view.

Tableau Desktop Certified Associate image Question 1 explanation 75931 09232024004713000000

Tableau Desktop Certified Associate image Question 1 explanation 75931 09232024004713000000

asked 23/09/2024
Kameron Katoku
51 questions