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.
- Data Mining and Machine Learning have been available in SQL Server since 2000.
- You don't need Cubes to use the mining structures.
- 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:
Querying a model:
Querying a prediction from the model with a C# application: