ExamGecko
Search Search Login
Home Home / Tableau / Desktop Certified Associate
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

Connect to the 'Global Superstore' data source and use the Orders table. Find out how many distinct customers have made 6 orders?
How can we add Visualization in a tooltip?
Connect to the 'Significant Volcano Eruption' data source. How many volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year?
In LOD calculation, we can use fields from multiple data sources (blended data source)?
Tableau automatically associates continuous fields with categorical palettes.
Connect to the Olympic Athletes data source, which athlete won at least one gold in 2008 Olympics and then won at least 4 golds in 2012 Olympics.
Connect to the 'Education' data source. Which college(s) average math, verbal, and writing scores are lesser than the overall 70% percentile in these subjects?
Connect to the 'Education' data source. Create a histogram using the Total score field and having a bin size of 100. Find out in which bin the students scored the highest verbal percentage? [Note: Verbal percentage should be calculated by considering how many marks scored in the verbal out of the total marks scored.]
Connect to the 'Global Superstore' data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?
Which of the following are valid calculations?

Question 34 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Create a hierarchy of Segment, Category, Region. Create a crosstab using this hierarchy and add profit, profit ratio fields. Which of the following are true from the below options?

A.
The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)
Answers
A.
The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)
B.
The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765
Answers
B.
The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765
C.
The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment
Answers
C.
The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment
D.
The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment (among all the segments)
Answers
D.
The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment (among all the segments)
Suggested answer: A, B

Explanation:

Create a hierarchy of Segment, Category, Region and drop it into the rows.

Create profit ratio calculated field:

Drop the profit and profit ratio fields to the view, your view will look like this:

Now let's go through each answer option.

1) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment - The profit ratio is -142.26% which is lowest overall so it is true.

2) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765 - It is true, the profit ratio is 2.06%, which is third-lowest.

3) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment - False, it is having a $2,245 profit.

4) The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment - False

Note: This is an easy question but time consuming, so attempt these types of questions in the end.

Show Answer
asked 23/09/2024
Ida Aasvistad
35 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms