In this example, we will create our first data mining solution with the Microsoft decision tree algorithm. The AdventureWorksDW
database contains information about bike buyers. We want to use that information as input variables to the decision tree algorithm and find out what drives someone to buy a bike.
Open SSDT and create an Analysis Service Multidimensional and Data Mining project. Name the project
Chapter 07 Data Mining Descriptive Models
.Right-click on the
data source
folder and create a new data source forAdventureWorksDW2012
. Choose the impersonation information with the account that has enough privilege, then accept the default name as Adventure Works DW2012 and complete the wizard.Create a data source view with the Adventure Works DW2012 data source. In the Select Table and Views menu, select only vTargetMail and add it to the included object's list in the box to the right. Click on Continue...