Forum Discussion
Correlation
So, I've posted what I've been able to create here. Essentially, I'm trying to find a way to visualize where there is an opportunity to reduce the number of suppliers. The ribbon chart on the top shows where there is a "y" indicating that the supplier does provide that service. It connects with the chart on the bottom, which shows how much the company spends with each supplier for that "commodity code" (thanks Ariba)... I want to be able to easily identify where we can reduce our suppliers, by consolidating spend from, say for example, 4 suppliers to 2 suppliers. What I'd really like this to do, if it could, is identify where, across a group of commodity codes, there is at least 1 supplier who supplies all commodity codes (capabilities), but where there is spend with greater than 1 supplier. In the case of the data provided in the attached image, Supplier W, in light blue, would be the best option for consolidating all spending. Supplier Z might be the best option for reduction (getting rid of this supplier to reduce the number of suppliers we contract with...). Does that make more sense? If so, I wasn't sure if there was a better way to create that visualization so that it's easier to identify opportunities.