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

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