The power of a union in Tableau
Our client is the owner of a retail chain. They want to offer their suppliers insights into their current sales share and what the impact of a different product placement level in the store could be.
Our client's goal was to provide their sales people with a tool that they can use to convince the supplier in the negotiations for investing in the best performing, and most expensive, product placement level.
Product placement level?
Effective in-store product placement will boost brand recognition and maximize sales, but it comes with a higher price.
Their store shelves are grouped into 4 different levels:
Here you can find a simplified representation of the result.
The X-axis displays the different suppliers of competing brands. They are ranked ascending based on their amount of sold quantities.
The Y-axis shows the actual sold quantities.
A drop down menu is available to select the desired supplier and the product placement level
Green, the "as is" situation for the selected supplier
Blue, the "to be" situation depending on the selected product placement level
Orange, the "as is" situation of the competitive suppliers
Our client has 4 different levels of product placement. By measuring the sales of a certain product by placing it on a different level for several weeks, they have come to the following conclusion.
"Eye level is buy level"
Based on the research they added a percentage of increased sales performance to each product placement level. The percentages used in this example are fictional:
Top level: 0,75%
Eye level: 1,35%
Middle level: 1,10%
Bottom level : 0,5%
The client wanted to maintain the original value for a better overview of the impact.
We had to create an extra value to visualize the simulated sales without changing the current data source.
Depending on the selected level, we need to create an extra bar in the bar chart as the "to be" value and maintain all the "as is" values from each supplier.
Requirements in this case:
1 Data source
4 Calculated fields
1 Custom sort
Through the union, Tableau created an extra dimension "Table Name". We use this extra dimension to indicate whether the duplicated rows should be multiplied by the corresponding percentage of the selected product placement level or not.
Join the Data Jam
92% of companies fail to scale their analytics, which likely includes you. We have studied the patterns in hundreds of client engagements and cracked the code for a modern data stack that guarantees success.
We'll uncover this in the most original webinar you've attended this year.