Tableau - Do it Yourself Tutorial - Pareto Charts - DIY -11-of-50 скачать в хорошем качестве

Tableau - Do it Yourself Tutorial - Pareto Charts - DIY -11-of-50

Tableau - Do it Yourself(DIY) Tutorial - Pareto Charts - DIY -11-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(DIY) Tutorial - Pareto Charts - DIY -11-of-50 In this video, we will see how to create Pareto Charts 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 - DIY - Vid - 11 4- Drag and drop the Customer to the Column shelf area. 5- Now, Drag and drop the Sales Amount measure to the rows shelf area, and sort the customer in desc order of Sales Amount. 6- Add a table calculation for Sales Amount to be a running total along Customer. Add a secondary calculation for Percent of Total. 7- Create a calculated field from the analysis menu, insert formula (index ()/size ()). Name the field as Pareto KPI. 8- Drag Pareto KPI to the column shelf. 9. Right click on Pareto KPI to use the Compute using functionality to select the Customer. 10. Drag the Customer to detail, and Sales Amount measure to color. 11. Set the Marks type to line. 12. Add reference lines horizontally and vertically to show 20% for the Customer Pareto KPI and 80% for the running sum of Sales Amount. 13- Do the following Hands on exercise. Hands on - DIY #19 1- Add a new sheet. 2- Create a Pareto chart, using the above method for Item Name, and Sales Cost measure.