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

Data mining using Microsoft Excel


The data mining plugin for Microsoft Excel provides us with the ability to build a data mining model and handle a wide range of data from various data sources. The following are a few features provided by this add-in:

  • Analyze how values in a data column are influenced by values in all the other columns

  • Detect groups of rows with similar characteristics

  • Automatically populate a column with values based on a few examples you provide

  • Perform forecasting on a time series

  • Find rows that are unlike most other rows (interesting or anomalous)

  • Perform a scenario (goal-seeking or what-if) analysis

  • Create a powerful (yet easy-to-use) prediction calculator

  • Perform shopping basket analysis and identify cross-sales opportunities

The article at http://msdn.microsoft.com/en-in/library/dn282385.aspx provides more details about the data mining add-in for Excel. The link to download the data mining plugin for Excel 2007 is http://www.microsoft.com/en-us/download/details.aspx?id=7294...