Predict stock prices with SQL Server Analysis Services Mining Models

📸 Image Content: This post contained 3 embedded images from the original BlogEngine.NET blog.

Images preserved in migration but content summarized due to size constraints.

Predictive analytics and supervised machine learning with SSAS and C#.

 

In this demo I use MS Time Series Mining structure to predict stock prices using the Auto Regressive Integrated Moving Average (ARIMA) method. 

  1. Data Mining and Machine Learning have been available in SQL Server since 2000.
  2. You don't need Cubes to use the mining structures.
  3. Accessing the models with C# and SSMS is easy

It's a basic mining structure example to demonstrate what SQL Server has been capable of. Please leave a comment if it helped or if you have any suggestions. 

The walk through consist of:

Creating a model:

Predict stock prices with SQL Server Analysis Services Mining Models

Predictive analytics and supervised machine learning with ssas and c#.