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 – finding the best mining model with Lift Chart and Profit Chart


In this example, we will add two other data mining algorithms, Naïve Bayes and Clustering, to the Target mail mining Structure example from the previous chapter. Then, we compare Lift Chart and Profit Chart for these algorithms to see which one works better compared to the test set. Perform the following steps to add the algorithms:

  1. Open Target mail mining Structure from the first example of the previous chapter.

  2. In the mining structure designer, go to the Mining Models tab and create a new mining model in one of the following ways:

    • Right-click anywhere on the Mining Models tab and choose New Mining Model

    • Click on the icon that shows the Create a related mining model option on hovering

  3. In the New Mining Model window, choose Microsoft Naïve Bayes as the algorithm and name it Target Mail Naive Bayes, as shown in the following screenshot:

  4. Repeat steps 2 and 3 to create a new mining model with the Microsoft Clustering...