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
Who is Participating?
k_murli_krishnaConnect With a Mentor Commented:
Have a look at these:

SQL Server Analysis Services (SSAS) Data Mining
SSAS: Scenario Analysis - What-If Video Tutorial (Data Mining Add-in For Excel)
SSAS: Forecast Video Tutorial (Data Mining Table Analysis Tool)
SSAS: Detect Categories Video Tutorial (Data Mining Table Analysis Tool)
SQL Server 2008/R2 Analysis Services Data Mining: An Intro

Chapter 11: Data Mining with Analysis Services

There is a Download this entire chapter button and entire chapter can be purchased online.

Here is another good one:

Channels > SQL > SSAS

You should register and log-in to get access to videos. The entire list of videos at:
There are 11 pages in all with 545 videos in all.

Here is one more excellent common site for good videos from various other sites:
Neil RussellTechnical Development LeadCommented:
Neil RussellTechnical Development LeadCommented:
And the user creativecommIT has a whole host of usefull vids you can watch
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

RamzyNEbeidAuthor Commented:
I found this site
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.
RamzyNEbeidAuthor Commented:
can you help me with my search please?
RamzyNEbeidAuthor Commented:
is there any books ?
RamzyNEbeidAuthor Commented:
i need a examples for retail Sales

also i am looking for walkthroughs

any videos "" is this one good or bad?
One more: Top 10 Data Mining Video Sites
Mark WillsTopic AdvisorCommented:
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)... - and have a good look around there - there is BI TV, Labs, Resources etc. - some good documents / whitepapers and general highlights. - 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 :

and for the language of data mining DMX

and to really understand cube development :

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.
RamzyNEbeidAuthor Commented:
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
RamzyNEbeidAuthor Commented:
dear all
please i need your help
Mark WillsConnect With a Mentor Topic AdvisorCommented:
Well, you are asking a new question really.

And the single hardest question of all... What "business" decisions do I need to make as a result of having additional information and toolsets available to explore data.

I would be inclined to visit some of those links and tutorials available above and work through pre-existing examples.

Some of the type of questions which a retail sales environment might be asking would involve a bit of predictive analysis along the lines of :
1) What impact on "product x" if I discount "product y"
2) Who would be the new retailers who will stock "product x" in a new promotion / campaign
3) What is the geographical distribution of "product x" and what other product (mix) does each location share
4) What will happen to sales of "product x" in the coming months (particularly suspect seasonal products)

The biggest challenge is "knowing" the business issues and business model where any such question might make sense. That can include types of products and how the customers interact.

Customer facing roles for a sales force presents an entirely different set of problems from (say) a website selling products, or a customer call centre taking orders.

Here is another site talking about approach :

Have a really good walkthrough of the tutorial

You need to understand the principles of DM before you can start asking questions. You also need to think about the "pretend" business model and make sure the data kind of represents the types of transactions that your business model would normally perform. Then you can build the cube, then you can ask DM questions.

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.