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: [email protected]
[email protected]
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.