How To Create Pareto Chart In Tableau

 

How To Create Pareto Chart In Tableau

  1. Drag Profit to Rows and Product Name to Columns. 
  1. Click the Sort Desc icon at the top below the Analysis menu. 
  1. Click on Profit and then hold down the ctrl key and drag a second instance of the pill to the right on the Rows shelf. 
  1. Click the down arrow on the of the second Profit pill. Click Add Table Calculation.   
  1. In the calculation type, select Running Total.  Leave all the other defaults. 
Tableau Pareto Chart
Tableau Pareto Charts
  1. Click the down arrow again on that second Profit pill.  Click “Edit Table Calculation.” 
  1. In the window that pops up, check the box in the bottom left that reads “Add Secondary Calculation.” 
  1. In the Secondary Type box, select Percent of Total.  Leave the other defaults.   
  1. Close the box.  You’ll now have two charts, one on top of the other.  The first has your profit sorted by product in descending order.  The second shows the percent of the total profit that each individual product contributes.  So if total profit was $500 and Product A had a profit of $100, it would be 20% of the total profit 
Pareto Chart Tableau
  1. On the second Profit pill, right click or click the down arrow.  Choose Dual Axis.  This combines them into the same chart. 
  1. On the marks card, there are now two shelves, one for Sum(Profit), and the other says Sum(Profit) and has a triangle next to it (representing that it’s a table calculation). 
  1. Click the first shelf for Profit and change the mark type to bar. 
  1. On the second shelf (with the triangle), change that mark type to line. 
  1. On the colors shelf, change the color of the bars to gray, and the line to orange. 
  1. Right click on the orange line and select Drop Lines > Show Drop Lines. 
Pareto Chart in Tableau
  1. Right click on the secondary axis (on the right hand side) and Add a Reference Line. 
  1. Set the Scope to Entire Table.  Set the Value in the middle section to Constant (from the drop down menu) and type in 0.6. 
Pareto in Tableau
  1. Click ok. 
  1. You can now click any point on the orange line and see what portion of the cumulative profits it represents.  By lassoing the bars under the 60% reference line, we can get a count to see how many products comprise 60% of the overall company profits.  Of the 1263 products in the database, <35 make up 60% of the overall profits.  That’s a staggering finding! 
How to Create Pareto Chart in Tableau

We hope that learning how to create a Tableau Pareto chart helps you and your company find solutions to your

Comments

Post a Comment

Popular posts from this blog

How to Create Dashboard in Tableau Steps

Image
  How to Create a Dashboard in Tableau Understand the importance of creating dashboards and learn to build a simple Tableau dashboard by following a visual guide. May 2022  · 16 min read What is the Purpose of a Dashboard? A car dashboard provides real-time information about a car's speed, fuel volume, RPM, and other engine-related indicators. Similarly, a data dashboard provides information about company historical sales, key performance indicators (KPIs), sales growth, operational indicators, and customer feedback. This information is presented in a precise manner so that managers or executives can understand the situation and make appropriate decisions.  There are hundreds of moving parts in your business and a dashboard summarizes these events into an easy-to-understand, real-time data visualization. These visualizations and charts can be used to make fast and effective decisions. Dashboard by  Freepik  | edited by Author There are several benefits of dashboard reporting: Usabi
Read more

Tableau Charts Uses.

  Tableau Charts and What and Use .                                                                A Pareto chart 1. . A Pareto chart is a type of chart that graphically represents the relative frequency or size of different categories or factors. It is named after Wilfredo Pareto, an Italian economist who observed that 80% of the wealth in Italy was owned by 20% of the population. The Pareto chart is based on the Pareto principle, which states that roughly 80% of effects come from 20% of the causes. The chart consists of a bar graph and a line graph. The bars are arranged in descending order of frequency or size, and the line graph represents the cumulative percentage of the total. The chart helps to visually identify the most significant factors contributing to an outcome, and can be used for quality control, productivity improvement, and decision-making. Some common uses of Pareto charts include: Quality control: Identifying the most common defects or
Read more

How to Create Text Visualisation in Tableau

Image
  f we load one of these files into Tableau (I'll stick with Don Quixote, but feel free to use whichever book you like best!), we get something that looks like: Let's pop over to a new sheet and see what we can do! If we drag the  Words  dimension onto the  Text  mark, we can view all the unique words in the book: ...well, almost. See how we only get partway through the As? There are too many unique words to fit! No problem, let's make a filter to show only those that appear at least 50 times: That's a little better: Let's see what happens if we try using  Word Count  to drive the  Size  mark: Ooh, sort of like a treemap! Let's switch from an  Automatic  mark type back to  Text : Hey, that's starting to look like a word cloud! There's just one problem: now that we've mapped  Word Count  to  Size , it's easy to see that the most frequently used words aren't actually very informative. That's okay, we can filter again! This time, let's b
Read more