Hi,
I have a question about how I can find patterns in large group of data. I’m familiar with Pivot Tables and know formulas pretty well, but I’m stuck on how to find patterns in large group of data. More specifically, I can’t figure out how to get to the “items most frequently bought together” from the data set that I have.
Here’s the situation. We have thousands of orders and thousands of items (SKUs) with two statuses (Shipped & Unshipped). Customers can buy only one item or in any combination of items. Any ordered items can either be Shipped or Unshipped. See attached spreadsheet for an example.
We get a text file report of the orders. Each item gets its own line item (row), per order, per status. In other words, if a customer buys 10 of an item on the same order, but 6 of them are Shipped and 4 are Unshipped, then that item would be on 2 different rows, one for 6 Shipped and one for 4 Unshipped on the same order number.
We need to get this information to give us a better sense of what to cross-promote to customers.
BTW, I have Excel 2010 running in Windows 7.
Any help/ insight/ideas with this would be greatly appreciated. Thank you in advance.
Bookmarks