Tableau Certification Exam Question – Part 5

Tableau Certification Exam Questions - Part 5


This question is Part 5 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 AE

Use SPCL_Sample-Superstore-Subset Excel File and using Orders sheets, Get the product sub category wise running totals for all the years and find the bottom 3rd product sub category in terms of sales

Solution Concept

It is a very basic KPIs for sales people to monitor such products or product sub categories which are not performing well over a period of time. This question finds a very meaningful insight from the available data to find a product sub category based on its performance across all years. Technique used in this question is Quick Table Calculations which facilitates us to find the running total for a measure across year as dimension. Since this question analyzes the all available data so no filter will be used for such questions.

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.

In order to learn how running total 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.

tableau certification exam questions

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

Select Orders Sheet and drop in the data pane

tableau certification exam questions

Its data will be visible and will look like this

tableau certification exam questions

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

New Sheet will open like this

tableau certification exam questions

Click the Order Date and drag it to columns shelf

tableau certification exam questions

Sheet will look like this

tabelau certification exam questions

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

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

tableau certification exam questions

Now select the quick table calculation ‘Running Total’ as shown below

tableau certification exam questions

Data looks like this

tableau certification exam question

Click on the descending button to sort the data in descending order

After this, all data looks in descending order as show below

tableau certification exam questions

It is the default property of Quick Table Calculations that it computes data ‘Table Across’ by default.Since in this question, this is our intension to compute values across Rows so we shall keep the same compute level

tableau certification exam questions

If we notice from screen shot below, it is now giving us the performance of each product sub category across years by adding previous value in current year value (which is the basic concept of running totals).

Quickly we are able to identify the bottom third product is Scissors, Rulers and Trimmers which is the desired result as shown below

tableau certification exam questions

Related Links

For More Similar Video and Text Based Solutions – Click Here

Tableau Certification Practice Test or Tableau Certification Mock Tests
Tableau Certification Sample Questions with step by step solutions

Leave a Reply

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