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>
Table of Contents (17 chapters)
Mastering SQL Server 2014 Data Mining
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Preparing data models


This section will outline the business problem that we intend to solve and help you decide on the algorithm that would be used to get us the required predictions. We will discuss the data mining algorithms available from the Microsoft suite and their usage.

Cross-Industry Standard Process for Data Mining

The discussion of data mining standards is important because it forms the basic framework for the data mining process in many organizations. The survey conducted by KDnuggets at http://www.kdnuggets.com/polls/2007/data_mining_methodology.htm clearly shows Cross-Industry Standard Process for Data Mining (CRISP-DM) as the winner.

The following diagram shows an outline of the CRISP-DM methodology:

The first stage, as shown in the preceding figure, is the Business Understanding phase, which has the prime objective of understanding the end objective from a business perspective. How will these results transform into business results? This phase is one of the important phases...