Book Image

Mastering SQL Server 2014 Data Mining

By : Amarpreet Singh Bassan, Debarchan Sarkar
Book Image

Mastering SQL Server 2014 Data Mining

By: Amarpreet Singh Bassan, Debarchan Sarkar

Overview of this book

<p>Whether you are new to data mining or are a seasoned expert, this book will provide you with the skills you need to successfully create, customize, and work with Microsoft Data Mining Suite. Starting with the basics, this book will cover how to clean the data, design the problem, and choose a data mining model that will give you the most accurate prediction.</p> <p>Next, you will be taken through the various classification models such as the decision tree data model, neural network model, as well as Naïve Bayes model. Following this, you'll learn about the clustering and association algorithms, along with the sequencing and regression algorithms, and understand the data mining expressions associated with each algorithm. With ample screenshots that offer a step-by-step account of how to build a data mining solution, this book will ensure your success with this cutting-edge data mining system.</p>

Related Content you might be interested in

Current Title:

Small book image
Mastering SQL Server 2014 Data Mining
Amarpreet Singh Bassan | Debarchan Sarkar
Dec, 2014 | 304 pages
No titles found
Table of Contents (17 chapters)
Mastering SQL Server 2014 Data Mining
Mastering SQL Server 2014 Data Mining
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Identifying, Staging, and Understanding Data
Identifying, Staging, and Understanding Data
Data mining life cycle
Staging data
Understanding and cleansing data
Summary
2
Data Model Preparation and Deployment
Data Model Preparation and Deployment
Preparing data models
Validating data models
Deploying data models
Summary
3
Tools of the Trade
Tools of the Trade
SQL Server BI Suite
References
Summary
4
Preparing the Data
Preparing the Data
Listing of popular databases
Summary
5
Classification Models
Classification Models
Input, output, and predicted columns
The feature selection
The Microsoft Decision Tree algorithm
The Microsoft Neural Network algorithm
The Microsoft Naïve Bayes algorithm
Summary
6
Segmentation and Association Models
Segmentation and Association Models
The Microsoft Clustering algorithm
The Microsoft Association algorithm
Summary
7
Sequence and Regression Models
Sequence and Regression Models
The Microsoft Sequence Clustering algorithm
The Microsoft Time Series algorithm
Summary
8
Data Mining Using Excel and Big Data
Data Mining Using Excel and Big Data
Data mining using Microsoft Excel
Data mining using HDInsight and Microsoft Azure Machine Learning
Summary
9
Tuning the Models
Tuning the Models
Getting the real-world data
Adding a clustering model to the data mining structure
Adding the Neural Network model to the data mining structure
Summary
10
Troubleshooting
Troubleshooting
A fraction of rows get transferred into a SQL table
Error during changing of the data type of the table
Troubleshooting the data mining structure performance
Error during the deployment of a model
Summary
Index
Index

The Microsoft Association algorithm

We all have been to a supermarket at some time or the other. One of the prime responsibilities of the manager of the supermarket is to sell the highest volume of products and to achieve this goal, knowledge of the purchasing patterns of the customers is required. When we know what or how our customers purchase certain products, we can suggest them products that they might be interested to buy and reorganize the store so that the items most frequently bought together are placed together. The algorithm that will help us in this endeavor is the Microsoft Association algorithm.

The input to the Microsoft Association algorithm is often in the form of a case table and a nested table. The case table consists of a unique record of each customer, while the nested table consists of multiple rows pertaining to the items purchased by the customer. The MSDN article at http://technet.microsoft.com/en-us/library/ms175659(v=sql.110).aspx gives a detailed explanation of...

Previous Section
End of Section 3
Next Section