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

SQL Server BI Suite


The SQL Server BI Suite encompasses the entire range of tools and applications that are available out of the box along with the SQL Server installation. The following list highlights some of these tools and applications:

  • SQL Server Engine: This is the core service preliminarily used to store, process, and secure data

  • SQL Server Data Tools: This is an Integrated Development Environment (IDE) to design and develop solutions for the SQL Server platform both on and off premises

  • SQL Server Analysis Services: This service provides Online Application Processing (OLAP) and data mining capabilities to the users

  • SQL Server Integration Services: This service provides the enterprise-level extract, transform, and load capabilities to the users

  • SQL Server Data Quality Services: This tool provides the ability to maintain data quality and ensures that the data is suitable for business usage

  • SQL Server Reporting Services: This is an out-of-box reporting tool that provides the end user...