![]() ![]() Mousing over that, we see that it’s a particular Consumer customer that has bought over $117k of products from us and has a profit of $34k. We see, for example, one dot up at the top. We now have each of the customers encoded by their segment.Ĥ. The goal would be to have everyone with both high sales and high profits, which would cluster the dots at the upper right corner of the graph.ģ. We’ll now have a dot for every customer that plots both their sales and their profit. Drag Customer Name out into the quadrant. You can easily swap these axes using the swap icon at the top.Ģ. This will build a quadrant with two axes, with Sales along your x-axis as your independent variable, and Profit on your y-axis as your dependent variable. Drag Sales to Columns and Profits to Rows. Scatter Plots to Find Correlation in Tableauġ. Tableau offers several analytical tools to do this. This is Tableau correlation analysis at work. And with enough data, you could probably start to have a pretty good idea that if a man is 6’0 tall he will weigh within a certain range. For example, as height in men increases, so typically does weight. Correlation analysis in Tableau compares two or more quantitative variables to see if values in one vary systematically with values in another. However, looking at correlation in Tableau by looking between numbers, and how one metric affects another, is an extremely valuable skill in analytics. Once in a set, these positive outliers can be highlighted in different visualizations, which can lead to valuable insights for the business.Up to this point, we’ve mostly looked at how data can be segmented by some dimension or over time. Let’s put these two products into a “positive-outlier” set by selecting them on the view (either through multi-select or dragging a box around them), right-clicking, and choosing “Create set…”. In the above example, our two highest-selling products are also above average in profitability. Lastly, these segments or products of interest can be made more permanent by placing them into sets. Also, are there opportunities to increase the sales of our most profitable items? This example created segments using the averages of each measure, but you can easily change the reference lines to the thresholds of your choice for segmentation. ![]() ![]() For example, we don’t want to have high sales of products that are causing us to lose money.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |