Mastering SQL Server 2014 Data Mining

Master selecting, applying, and deploying data mining models to build powerful predictive analysis frameworks

About This Book

• Understand the different phases of data mining, along with the tools used at each stage
• Explore the different data mining algorithms in depth
• Become an expert in optimizing algorithms and situation-based modeling

Who This Book Is For

If you are a developer who is working on data mining for large companies and would like to enhance your knowledge of SQL Server Data Mining Suite, this book is for you. Whether you are brand new to data mining or are a seasoned expert, you will be able to master the skills needed to build a data mining solution.

In Detail

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.

Next, you will be taken through the various classification models such as the decision tree data model, neural network model, as well as Naive 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.

Table of Contents

Chapter 1: Identifying, Staging, and Understanding Data
Chapter 2: Data Model Preparation and Deployment
Chapter 3: Tools of the Trade
Chapter 4: Preparing the Data
Chapter 5: Classification Models
Chapter 6: Segmentation and Association Models
Chapter 7: Sequence and Regression Models
Chapter 8: Data Mining Using Excel and Big Data
Chapter 9: Tuning the Models
Chapter 10: Troubleshooting