actually I am trying to make a market basket analysis with SQL Server 2012 and its tools "Server Data Tools" and "SQL server Management studio" (Visual Studio)
As basis I have a table with different types of products including customer attributes.
I want to use the association mining rules.
Here you can see the first 2 Datasets
TransactionID Ready made Frozen foods Alcohol Fresh Vegetables Fresh meat Snacks GENDER Age MARITAL CHILDREN WORKING 1 1 0 0 0 0 1 Female 18 to 30 Widowed No Yes 2 1 0 0 0 0 0 Female 18 to 30 Separated No Yes
You can see there will be only differentiated between "bought" or "not bought" (0 or 1) within the products.
I am not sure if I have to create two tables ( Products / customer ).
Moreover I am not sure about setting up the right inputs and predictions.
My goal is to have a real market basket analysis but now I got some confusing results. I guess somewhere I didn't set it up right.
I already made this with the IBM SPSS Modeler (A Prior and Carma) and this was quite "easy".
I hope you can help me because I already spend days of just finding help. I would say I have problems with these binary itemsets. 0 and 1.
- Edited by SQLGreenhorn Tuesday, July 09, 2013 3:35 PM
SQL Server expects you to have 2 tables (because in most cases there is a large number of products and it is not easy and efficient to create very wide table similar to yours).
BTW, if you are just starting with data mining using SQL Server, I recommend you to use Data Mining Add-ins for Excel from Microsoft. They are much easier to use and free.
Another option is to use Predixion Insight (which is developed by Predixion Software, not Microsoft and is available at http://www.predixionsoftware.com/predixion/Products/GetPredixionEnterpriseInsight.aspx ). Predixion Insight is as easy to use as Data Mining Add-ins for Excel but has a lot more features (for example, Microsoft Network viewer for association rules is VERY difficult to use. Predixion has new set of viewers for all of the Microsoft algorithms and you can see demo of Predixion association rules viewer in this video starting from 3:45 http://www.youtube.com/watch?v=rgz3LZRS_AY )
Tatyana Yakushev [PredixionSoftware.com]
Download Predixion Insight 3.0 - World class predictive platform for big data