• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

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.
  • 3
1 Solution
RamzyNEbeidAuthor Commented:
please i need help
Reza RadCommented:
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:
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now