Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


SSAS and what is Data mining?

Posted on 2011-09-06
Medium Priority
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 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.
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal


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 "http://www.learnitfirst.com" is this one good or bad?
LVL 17

Accepted Solution

k_murli_krishna earned 1000 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)...

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.

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 1000 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 : http://www.thearling.com/text/dmwhite/dmwhite.htm

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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

618 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