Tableau - Do it Yourself Tutorial - Top N Analysis & Sorting - DIY# 3-of-50

Tableau - Do it Yourself Tutorial - Top N Analysis & Sorting - DIY -3-of-50

by

Bharati DW Consultancy

cell: +1-562-646-6746 (Cell & Whatsapp)

email:  info@bharaticonsultancy.in

bharati.dwconsultancy@gmail.com

website: http://bharaticonsultancy.in/





Tableau - Do it Yourself Tutorial - Top N Analysis & Sorting - DIY -3-of-50

>>Use the data connection from the Video-1 of the Tableau DIY series



1- Open the saved TWB file - Tableau BDCS DIY.

2- Use the data connection from the Video-1 of the Tableau DIY series

3- Goto a new Sheet, and rename it to DIY - Vid -3

4- Add the Customer Name from the dimensions to the column shelf.

5- Right Click on the Customer Name from the columns shelf and sort, desc.

6- Add Sales Amount in the row shelf.

7- Create and Add the newly created set to the filter Top 10 Customers based on Sales Amount shelf.

Edit filter to select only "IN" values.

8- Do the following hands-on exercises.



Hands on - DIY #5

1- Add a new sheet.

2- Create a sorting for Item Names, based on Sales amount desc.

3- Add Sales Amount in the column shelf

4- Add Sale Type in the Color Marks.

5- Display top 5 Item Names.



Hands on - DIY #6

1- Add a new sheet.

2- Add the Employee Name from the dimensions to the column shelf.

3- Add Sales Quantity in the row shelf

4- Show only the Employees, dealing with the top Channel Type based on quantity.

Meaning: Create a set for the Top 1 Channel type, and add it to the filter condition.



Hands on - DIY #7

Repeat the same for #6

5- Show only the Employees, dealing with the bottom Channel Type based on quantity.

Meaning: Create a set for the bottom 1 Channel type, and add it to the filter condition.