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
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.
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
Tatyana Yakushev [PredixionSoftware.com]
Download Predixion Insight 3.0 - World class predictive platform for big data
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?