In this chapter, we covered the current market trends and business requirements for predictive data analysis, which is also called data mining. In order to deploy a successful data mining model, you need to have a clear idea of your end goal, develop a thorough understanding of the data that you are dealing with, transform and clean the data accordingly, and last but not least develop a mining algorithm. In the next chapter, we will take a look at the different tools that SQL Server offers to help develop a data mining model. The SQL Server Business Intelligence suite provides a rich set of components, which could be used at different stages of data modeling. The next chapter will focus on a few of those commonly used tools of the trade, such as SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.
Mastering SQL Server 2014 Data Mining
By :
Mastering SQL Server 2014 Data Mining
By:
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
Free Chapter
Identifying, Staging, and Understanding Data
Data Model Preparation and Deployment
Tools of the Trade
Preparing the Data
Classification Models
Segmentation and Association Models
Sequence and Regression Models
Data Mining Using Excel and Big Data
Tuning the Models
Troubleshooting
Index
Customer Reviews