Link to home
Start Free TrialLog in
Avatar of RamzyNEbeid
RamzyNEbeidFlag for Egypt

asked on

SSAS and what is Data mining?

dear all
i am looking for videos about SSAS Data mining
i need to know what is it for and how can use it
i am working on Retail Sales business
Avatar of Neil Russell
Neil Russell
Flag of United Kingdom of Great Britain and Northern Ireland image

And the user creativecommIT has a whole host of usefull vids you can watch
http://www.youtube.com/user/creativecommIT
Avatar of RamzyNEbeid

ASKER

I found this site http://www.learnitfirst.com
I saw the reviews and it was very good, so I am thinking to purchase the these videos
So please I need advice in case there may be something better.
can you help me with my search please?
is there any books ?
i need a examples for retail Sales

also i am looking for walkthroughs

any videos "http://www.learnitfirst.com" is this one good or bad?
ASKER CERTIFIED SOLUTION
Avatar of k_murli_krishna
k_murli_krishna
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
One more: Top 10 Data Mining Video Sites
http://mydatamine.com/?p=1012
Avatar of Mark Wills
Data Mining can be a very interesting beast. It is part of the SSAS offering with Business Intelligence, but really is the next step in analytics. It can be quite intensive in terms of models and the resources (machine and time) required to crunch data.

It takes BI a few steps forward in trying to identify patterns from data relationships, trends and exceptions to help with predictive analytics. It uses a slightly different language from what you might expect - called DMX and that takes a bit of getting used to, so you will want to study up a bit on that. Good examples / sample databases to play with are the best way.

There are some good links above and to add just a few more for you (more for background)...

http://www.microsoft.com/BI/en-us/Solutions/Pages/Product%20Overview.aspx - and have a good look around there - there is BI TV, Labs, Resources etc.

http://www.microsoft.com/sqlserver/en/us/solutions-technologies/business-intelligence/data-mining.aspx - some good documents / whitepapers and general highlights.

http://www.sqlserverdatamining.com/ssdm/Home/tabid/36/Default.aspx - slightly older but one I came across for SQL 2005 and had some good downloads, samples, tutorials - now - data mining has changed from the early days and become more powerful, but, it can still be a good place to start the learning process if you really want a thorough education.

Now, there are also some good e-books like : http://www.amazon.com/Data-Mining-Microsoft-Server-2008/dp/0470277742/ref=sr_1_1?s=books&ie=UTF8&qid=1316988688&sr=1-1

and for the language of data mining DMX http://www.amazon.com/Practical-Queries-Microsoft-Analysis-Services/dp/0071748660/ref=sr_1_18?s=books&ie=UTF8&qid=1316988930&sr=1-18

and to really understand cube development : http://www.amazon.com/Expert-Development-Microsoft-Analysis-Services/dp/1847197221/ref=pd_bxgy_b_img_c

There are some more books of course, and some more general introductions to SSAS as well, so choose carefully. The above books are available as kindle books which you can download and run on your PC (or mac etc) you do not need a kindle.

Oh, and be gentle on yourself. It can take a while to get to grips with, it often takes a slightly different mindset to really get on top of the concepts and "think" in a cube oriented world. Some of our programmers and T-SQL experts did make the transformation quite easily, but a few struggled and they still approached the subject in a linear way, and not quite grasping the importance of thinking about the "business" perspective and not just "data". It is the business that you want to
be able to deliver information to, not just simply crunch some raw data.
Dear all
Thank you very much for all their information you gave me.
I am working now on my proof on concept,
1 - I did create the data warehouse
2 - Then I fill it with real data
3 – I did create the CUBE.
For Retail sales
Now I want to make data mining, the problem for me here is what are the question do I need to ask myself to start data mining how I can answer these question from data mining?
Is there an example for Data mining and Retail Sales?
I am new to BI so I am trying to find answers to all what in my mind.
So please be patient
Thanks,
dear all
please i need your help
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial