How to create a SSAS data mining structure based on an algorithm model.

Problem: How to create a SSAS data mining structure based on an algorithm model.

Solution: Data mining Models

After collecting all the data in a SSAS Cube, based on this data we can create a data mining model based on an algorithm to predict future data. SQL Server Data Mining includes multiple standard algorithms

This is also called machine learning or predictive analytics.

To drive the predictive analysis, you should have datamining structures created on top of the cube dsv.

On the backend, datamining is done by queries based on the patterns and these queries are called DMX.

Example:

In this example, let’s see how to create a data mining model.

Step 0:  Create a dsv for using inside the data mining model.

Step 1: create a new datamining structure by right clicking on the mining structures from the project.

Step 2: now a wizard will be prompted to create a mining structure model and select the mining structure data source.

Step 3: Create mining structure model and from the drop down which technique do you want to use.

Step 4: Select the data source view

Step 5: Select the tables.

Step 6: Select the training data from where you want to input data and predict data and key columns.

Step 7: Specify data types and hit detect and content types.

Step 8: name the mining structure.

Results: