SSAS and what is Data mining?

Posted on 2011-09-06
Last Modified: 2016-02-14
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
Question by:RamzyNEbeid
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 2
  • 2
  • +1
LVL 37

Expert Comment

by:Neil Russell
ID: 36493807
LVL 37

Expert Comment

by:Neil Russell
ID: 36493813
And the user creativecommIT has a whole host of usefull vids you can watch

Author Comment

ID: 36518541
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.
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.


Author Comment

ID: 36555717
can you help me with my search please?

Author Comment

ID: 36594733
is there any books ?

Author Comment

ID: 36595106
i need a examples for retail Sales

also i am looking for walkthroughs

any videos "" is this one good or bad?
LVL 17

Accepted Solution

k_murli_krishna earned 250 total points
ID: 36595435
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:
LVL 17

Expert Comment

ID: 36595451
One more: Top 10 Data Mining Video Sites
LVL 51

Expert Comment

by:Mark Wills
ID: 36596344
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.

Author Comment

ID: 36598425
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

Author Comment

ID: 36707826
dear all
please i need your help
LVL 51

Assisted Solution

by:Mark Wills
Mark Wills earned 250 total points
ID: 36713364
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.


Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question