Creating a Market Basket Mining Model Structure (Data Mining Tutorial)

The first step in creating a market basket scenario is to use the Data Mining Wizard to create a new mining structure. In this task you will use the wizard to create a mining structure and initial associated mining model that are based on the Microsoft Association algorithm.

For More Information

Data Mining Wizard, Data Mining Designer, Microsoft Association Algorithm

To create an association mining structure

  1. In Solution Explorer in Business Intelligence Development Studio, right-click Mining Structures and select New Mining Structure.

    The Data Mining Wizard opens.

  2. On the Welcome to the Data Mining Wizard page, click Next.

  3. On the Select the Definition Method page, verify that From existing relational database or data warehouse is selected, and then click Next.

  4. On the Select the Data Mining Technique page, under Which data mining technique do you want to use?, select Microsoft Association Rules, and then click Next.

    The Select Data Source View page appears. By default, Adventure Works DW is selected under Available data source views.

  5. Click Next.

  6. On the Specify Table Types page, select the Case check box next to the vAssocSeqOrders table, select the Nested check box next to the vAssocSeqLineItems table, and then click Next.

  7. On the Specify the Training Data page, clear the Key check box next to CustomerKey, and clear the Key and Input check boxes next to LineNumber.

    By default, CustomerKey, OrderNumber, and LineNumber are listed as Key types. However, in this tutorial you will use LineNumber as a key only for Microsoft Sequence Clustering models; you must change the default setting for the association model.

  8. Select the Key and Predictable check boxes next to the Model column. The Input check box is then also automatically selected.

  9. Click Next.

  10. On the Specify Column's Content and Data Type page, click Next.

  11. On the Completing the Wizard page, in Mining structure name, type Association.

  12. In Mining model name, type Association, and then click Finish.

    Data Mining Designer opens to display the Association mining structure you just created.

Next Task in Lesson

Modifying the Market Basket Model (Data Mining Tutorial)