Time for action – the Microsoft association rule

Assume this scenario as an example: the AdventureWorks company wants to identify a set of products that are usually purchased together. The company can use this information to put these products beside each other or add similar items next to each other in a store to achieve higher sales. This is known as market-basket analysis because it relates to the analysis of products in a single basket in each purchase. In this example, we will use the AdventureWorksDW2012 database.

  1. Open the AdventureWorksDW2012 data source view from the previous example.
  2. Right-click on an empty area in the data source view and select Add/Remove Tables.
  3. In the Add/Remove Tables window, add vAssocSeqOrders and vAssocSeqLineItems ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial