O'Reilly logo

Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide by Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required