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

Time for action – creating a data mining solution with the Microsoft Decision Tree algorithm

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.

1. Open SSDT and create an Analysis Service Multidimensional and Data Mining project. Name the project Chapter 07 Data Mining Descriptive Models.
2. Right-click on the data source folder and create a new data source for AdventureWorksDW2012. Choose the impersonation information with the account that has enough privilege, then accept the default name as Adventure ...