SQL Server 2008 R2 and Data Mining algorithm

Dear all
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.
Who is Participating?
Reza RadConsultant, TrainerCommented:
you can read the MCTS--70 448 book of Microsoft press ( Chapter 9 )
there are samples of all Decision tree, Association rules, time series, clustering.... completely there , all explained as a walk through. just follow all steps described in chapter 9 practices.
RamzyNEbeidAuthor Commented:
please i need help
RamzyNEbeidAuthor Commented:
I found the Data mining tool that works with excel and it is very nice for me till now

So I am asking can I do everything with excel instead of BIDS in the part of data mining or there will be some restriction and if yes what are these restrictions?

You are going to ask me why I did that because I am not able to understand data mining inside BIDS and there is no one to help me here in egypt
RamzyNEbeidAuthor Commented:
i need more help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.