SQL Server Market Basket Analysis // Association


  • Hello,

    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.


    Tuesday, July 09, 2013 3:34 PM