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

Chapter 3. Tools of the Trade

Data mining as a process is closely dependent on the knowledge of the entire SQL Server BI Suite. The SQL Server BI Suite provides the tools that are important at the stage of the data mining process. The data mining process consists of activities such as hosting the data generated from different business processes (in the form of SQL Server tables), designing the data warehouse project (with the help of SQL Server Data Tools), which will contain the historical data of different departments of the organization, hosting the data marts that could be in the form of relational databases or cubes and giving a visualization on the data (in the form of SQL Server reports). Thus, we will devote this chapter to take a tour of the important components of the SQL Server BI Suite, which are SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services. This chapter should not be considered as a deep dive but rather a refresher and walkthrough...

Previous Section
End of Section 1
Next Section