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

Summary

In this chapter, we discussed the Microsoft Sequence Clustering algorithm, which helped us determine the items that are most probable to be bought together and in a particular sequence. We were not only able to predict the items that will be bought, but also got an idea of how to modify the page wise navigation of the website so that it provides a better user experience. The Microsoft Time Series algorithm helped us predict certain values of the sales of certain commodities for a future date and time with the data of the previous sales. In the next chapter, we will look at the data mining capabilities provided to us by Excel and HDInsight. We will also explore its functionalities and perform a simple data mining activity using the Excel data mining add-in and Mahout in HDInsight.

Previous Section
End of Chapter 7
Next Chapter