Finding products sold togeter 1

[testhandle]

Hi,

Sales transaction containing columns(product,month & year of sales,sale price) are available. Please tell how to identify the products sold together.

Thanks
John Jayaseealn

 

[MarleneD]

Do you mean sold in a single transaction?

 

[testhandle]

Products bought by single customer.

Sales transaction containing columns(custno,product,month & year of sales,sale price) are available.

Thanks

 

[MarleneD]

Hi:

I am not sure I follow what you need - But it sounds like you are looking for OLAP reporting.

Build a multi-dimentional cube - and you will be able to see the results you need.

i.e. by customer, by product etc

Try

http://www.dwreview.com

- they have some good articles on this.

Hope this helps.

 

[BruceReed]

Marlene is right, you need an OLAP reporter. Before you buy one (big bucks regardless which one you buy) try using the data in MS Excel pivot tables. It might get the info. you're looking for.

Bruce

 

[Predictor]

I'd suggest:

1. Consolidate the data by customer, which will be easy in any modern database

and...

2. Summarize using an association rules (also called market masket basket analysis) tool, such as XAffinity, from Exclusive Ore (others are listed on KDNuggets' software section at:

http://www.kdnuggets.com/software/associations.html).

Assuming that the number of products you're dealing with is anything like what I've seen in the past, typical OLAP solutions will be clumsy, if they can swallow this much data at all, and will not perform the kind of statistical analysis needed to make this process useful.