Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Time for action – predicting prospective bike buyers


In this example, we will add a case table that contains only a list of new customers with attributes such as yearly income, total children, gender, and so on. Then we will apply DMX queries on the mining model and the case table to find out the list of prospective bike buyers. The prerequisite for running this example is the decision tree example mentioned in the previous chapter. Perform the following steps to predict prospective bike buyers:

  1. Open the Adventure Works DW2012.dsv designer.

  2. Right-click on a blank area in it and click on Add/Remove Tables. Select the ProspectiveBuyer(dbo) table and add it to the DSV.

  3. Right-click on the ProspectiveBuyer table in the DSV and explore its data. You will see that most of the input variables of the Target mail mining algorithms are supported as columns of this table.

  4. Save the DSV and open Target Mail Mining Structure and go to the Mining Model Prediction tab.

  5. In the Mining Model pane, on the top left...