Introduction to the SQL Server Analysis Services Linear Regression Data Mining Algorithm

In this tip we walk through how to setup and view data using SQL Server Analysis Services Linear Regression Data Mining Algorithm. In data mining and machine learning circles, the linear regression algorithm is one of the easiest to explain. The linear regression algorithm generates a linear equation that best fits a set of data containing an independent and dependent variable. In this tip, we show how to create a simple data mining model using the Linear Regression algorithm in SQL Server Analysis Services 2014. Before we start, we will execute the following T-SQL code to create our sample dataset with 10,000 rows.