Book Image

Data Science with SQL Server Quick Start Guide

By : Dejan Sarka
Book Image

Data Science with SQL Server Quick Start Guide

By: Dejan Sarka

Overview of this book

SQL Server only started to fully support data science with its two most recent editions. If you are a professional from both worlds, SQL Server and data science, and interested in using SQL Server and Machine Learning (ML) Services for your projects, then this is the ideal book for you. This book is the ideal introduction to data science with Microsoft SQL Server and In-Database ML Services. It covers all stages of a data science project, from businessand data understanding,through data overview, data preparation, modeling and using algorithms, model evaluation, and deployment. You will learn to use the engines and languages that come with SQL Server, including ML Services with R and Python languages and Transact-SQL. You will also learn how to choose which algorithm to use for which task, and learn the working of each algorithm.
Table of Contents (15 chapters)
Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
Index

Finding clusters of similar cases


With cluster analysis, you try to find specific groups of cases, based on the similarity of the input variables. These groups, or clusters, help you understand your cases, for example, your customers or your employees. The clustering process groups the data based on the values of the variables, so the cases within a cluster have high similarity; however, these cases are very dissimilar to cases in other clusters. Similarity can be measured with different measures. Geometric distance is an example of a measure for similarity. You define an n-dimensional hyperspace, where each input variable defines one dimension, or one axis. Values of the variables define points in this hyperspace; these points are, of course, the cases. Now you can measure the geometric distance of each case from all other cases.

There are many different clustering algorithms. The most popular one is the K-means algorithm. With this algorithm, you define the number of K clusters in advance...