I am new working with BI using Microsoft SQL server 2008R2
I did create my Data warehouse and I fill it with data.
I did build my cube.
So far everything is working fine.
It is for Retail Sales.
Now I want to move to the next step which is to use data mining
I am very specific for 3 algorithms:
1. Time Series (Sales Forecasting)
2. Association (cross selling items)
3. Decision Tree (which I am confused when to use it)
I want to build all the above algorithms using the Cube not DSV.
I need an example and a complete walkthrough for every algorithm.
I am also asking do I need to change the cube structure to be able to work with every algorithm? Let me explain more in time series algorithm the time key must not be duplicated at all so I need to build DSV with specific structure (SQL grouping the sales by months or years) to result with a monthly sales then I will use this DSV in my time series algorithm.