gettableaucertifications
Tableau Certifications
  • Home
  • About Us
  • Free Quiz
  • Tableau Certification Practice Exams
    • Specialist
    • Data Analyst
    • Associate
    • Server
  • Data Sources
  • Videos
  • Blog
  • Join Us
  • Member Login
  • Home
  • About Us
  • Free Quiz
  • Tableau Certification Practice Exams
    • Specialist
    • Data Analyst
    • Associate
    • Server
  • Data Sources
  • Videos
  • Blog
  • Join Us
  • Member Login
  • Home
  • About Us
  • Free Quiz
  • Tableau Certification Practice Exams
    • Specialist
    • Data Analyst
    • Associate
    • Server
  • Data Sources
  • Videos
  • Blog
  • Join Us
  • Member Login
Menu
  • Home
  • About Us
  • Free Quiz
  • Tableau Certification Practice Exams
    • Specialist
    • Data Analyst
    • Associate
    • Server
  • Data Sources
  • Videos
  • Blog
  • Join Us
  • Member Login
Avail 50 % Off on all our products from 02 June to 15 June and get benefit from offer

Tableau Certification Exam Questions - Part 6

This question is Part 6 of our free series of questions along with step by step video and Text based solutions for Tableau Certification Exam Question Dumps including Tableau Desktop Specialist Certification Exam Dumps and Tableau Desktop Certified Associate Exam Dumps. You will see similar questions in both above mentioned certification exams. In Specialist Exam you can expect 8 to 10 scenario based questions where as in Associate exam, it’s almost double. We strongly recommend to have a walk through such material before your real exam. All data sources used in these questions are available in Data Source Page at our website Menu.

Question AF

Use SPCL_Sample-Superstore-Subset Excel File and using Orders sheets,Find the product sub category having the lowest sales across all years in the same product sub category

Solution Concept

Apparently this question looks very simple, but there is a little catch in this question that they have asked to find the lowest sales of product sub category across all the years. We can achieve result by using Rank function of Quick Table Calculations.

Note: if you want to practice this question on your PC, you can download the data source from data sources page from our website menu.

Rank is a very useful feature to identify the desired result from a big range of values. There are different type of Rank functions and its competitions available in Tableau. In order to learn how Rank works in Quick Table calculations, you can continue your learning journey and can read the following article  from Tableau knowledge base.

Watch Video Based Question Explanation and Solution

Text Based Solution

Open Tableau Desktop, Go to File menu navigation as shown below

tableau certification exam questions

It will open a new blank workbook like following

Click on Connect to data

tableau certification exam questions

From following screen click the Excel data source option.

It will ask the location for the data source available on the system, select the correct data source file and load it, Once you select the excel data source file from your local PC, it will be loaded in the Tableau and will look like as following

tableau certification exam questions

Select Orders Sheet and drop in the data pane

tableau certification exam questions

Its data will be visible and will look like this

Click on the sheet icon to create a new sheet as shown below

New Sheet will open like this

Click the Order Date and drag it to columns shelf

Sheet will look like this

tableau certification exam question

Select the sales measure and put it on the Text as shown below

It will show the sales across years

tableau certification exam questions

Now select Product Sub Category and drag it to Rows Shelf

.

tableau certification exam questions

Now the sheet is showing the sales across product sub category across all available years

Now select the Sales measure and select the Rank function from the Quick Table Calculations as shown below

tableau certification exam questions

Data sheet will look like this

tableau certification exam questions

In order to understand it more clearly, let’s put sales measure on Text

tableau certification exam questions

Sheet will look like this

tableau certification exam questions

Let us now observe any one product sub category and understand the behavior. If you just focus on the data of Office Machines, we see that Rank is computed across product categories and following points can be observed

Rank is 1 for highest sales value across all years for product category for office machines.

Rank is 4 for lowest sales value across all years for product category for office machines.

This behavior of Rank is controlled by its default properties which we can be seen from the following navigation as shown below

tableau certification exam questions

It shows following default properties, you can try different options of Rank and learn more about using different values of Rank competition

tableau certification exam questions

Now let us remove the Sales from the Marks Pane, keeping only Sales Quick Table Calculations in the Marks pane as shown below

tableau certification exam questions

We can see very clearly that there is only one product sub category (Bookcases) which has Rank Value 4 (Lowest Sales across all years for that product sub category) in our last year which is year 2013.

As highlighted in the above screenshot that Bookcases is the only product sub category which has lowest sales in last year (2013) else all product sub categories have got increase in sales figures across years.

Related Links

For More Similar Video and Text Based Solutions – Click Here

Tableau Certification Practice Test or Tableau Certification Mock Tests
  • Complete Specialist Practice Exams
  • Complete Associate Practice Exams
  • Complete Server Practice Exams
Tableau Certification Sample Questions with step by step solutions
  •  (Free Quiz Specialist)
  • (Free Quiz Associate)
Share
0

Related posts

February 28, 2021

Tableau Certification Exam Questions – Part 18


Read more
February 28, 2021

Tableau Certification Exam Questions – Part 17


Read more
February 28, 2021

Tableau Certification Exam Questions – Part 16


Read more

Click here to cancel reply.

Please Login to Comment.

info@gettableaucertifications.com

If you have any question, feel free to mail us or send whats app message.

Facebook Twitter Youtube Instagram Pinterest

Whats App: 00971-56-541 8335

We are just one message away from you, We answer every query, Feel free to get in touch.

Copyright © 2023 GetTableauCertifications. All Right Reserved. Designed and Developed by Technical MasteMind ♡.   Privacy Policy