What Is It? The Associate Wizard helps you build an Association Rules model based on existing data from an Excel table or ...

What Is It? 

The Associate Wizard helps you build an Association Rules model based on existing data from an Excel table or an Excel range. An Association Rules model detects associations between items that appear together in multiple transactions, and is typically used for market basket analysis.



What Does It Do?

The wizard allows you to specify the column that identifies a transaction, and the column that identifies the items inside transactions.



Notes

To use the Association Wizard, you must be connected to a SQL Server Analysis Services database. Your source data must be organized as a transaction table (similar to a list of shopping cart contents). The source data must contain a transaction identifier column (identifying one group of items, or one shopping cart) and an Item identifier column (identifying the items in that group). The transaction column must be in a one-to-many relationship with the item column. Your source data must be sorted by the transaction identifier column.



The model created by this wizard can be saved, or exist only while you are working with the data. However, to create a temporary model, the server must be configured to allow temporary mining models. Contact your server administrator to make sure the server configuration allows temporary mining models. The wizard also allows you to specify whether the model preserves the training data and associates it with the patterns (enable drillthrough).