SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Very new to Data Mining


Very new to Data Mining

Author
Message
saurabh.deshpande
saurabh.deshpande
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 114
Hi All

As I am very new to Data Mining.

I like to know

1. What is Data Mining.
2. How it is different from Business Intelligence.
3. What are way's to implement it.
4. How is market (Job) for the same.

Thanks
Raunak Jhawar
Raunak Jhawar
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1645 Visits: 1944

1. What is Data Mining?


Data mining can be related with self explanatory terms such as knowledge discovery, machine learning or predictive analysis. The term mining means to determine and discover patterns which are used to reason a fact. There are many data mining algorithms available which can be used to train the data.


2. How it is different from Business Intelligence?


Data mining is a bundled package which comes with Business Intelligence. It is not different from BI. Most important, BI is not a product it is a technology.


3. What are way's to implement it?


Please refer Question 1


4. How is market (Job) for the same?


The area is fairly untouched and now a days it is gaining momemtum. It is fairly interesting.

It is nice to hear that after several attempts the forum is gaining visibility.

I would recommend,if you are interested, Data Mining for SQL Server 2008 by Jamie MacLennan

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
saurabh.deshpande
saurabh.deshpande
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 114
Raunak

It's really good start here. And thanks for quick answering a these tiny question.
Raunak Jhawar
Raunak Jhawar
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1645 Visits: 1944
Pleasure.:-)

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5405 Visits: 4639
Raunak Jhawar (10/7/2010)
[quote]
Data mining is a bundled package which comes with Business Intelligence. It is not different from BI. Most important, BI is not a product it is a technology.


I was under the assumption that BI is a "concept" (in the sense that describes the general specifications of what is supposed to deliver) while Data Mining is a "technology" (in the sense that actually delivers what was promised by BI) - Is that a fair statement?

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Raunak Jhawar
Raunak Jhawar
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1645 Visits: 1944
PaulB-TheOneAndOnly (10/7/2010)
Raunak Jhawar (10/7/2010)
[quote]
Data mining is a bundled package which comes with Business Intelligence. It is not different from BI. Most important, BI is not a product it is a technology.


I was under the assumption that BI is a "concept" (in the sense that describes the general specifications of what is supposed to deliver) while Data Mining is a "technology" (in the sense that actually delivers what was promised by BI) - Is that a fair statement?


To err is human, to recurse is divine:-):-)

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
saurabh.deshpande
saurabh.deshpande
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 114
What I got is,

In BI, you already aware of patterns in Datasets.
In case of BI you have Question with you and you are looking for
Answer to that Question in the Datasets.

Ex : "Give me a breakdown of last month’s sales by salesman in the
poorest performing region" is question asked by Business, and
in response to this question you will generate some Report in BI
tool.

In Data Mining, you like to see hidden/unknown pattern in Datasets.
here you don't have Question with you.

Ex : Buying behavior of customers.
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5405 Visits: 4639
saurabh.deshpande (10/8/2010)
In Data Mining, you like to see hidden/unknown pattern in Datasets.

Let me ilustrate with a purchasing pattern discovered in a major drug store chain.

1-Pattern: "from 9pm to 6am 90% of people buying baby diapers also buy beer"

2-Root cause of the pattern: "husbands are the ones buying baby diapers at night so they take advantage of the trip to the drug store to by beer for themselves"

3-Business action: "Put beer close to the baby diapers"

There is no question business could have asked to find that.

Here is how it works...

1- Data mining shows the pattern a.k.a. correlation in between sales of two products in a specific timeframe.

2- Business investigates to find the rationale behind the pattern.

3- Business takes action to take advantage of the pattern - provided pattern is potentialy positive.

Hope this helps.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5405 Visits: 4639
Raunak Jhawar (10/7/2010)
PaulB-TheOneAndOnly (10/7/2010)
Raunak Jhawar (10/7/2010)
[quote]
Data mining is a bundled package which comes with Business Intelligence. It is not different from BI. Most important, BI is not a product it is a technology.


I was under the assumption that BI is a "concept" (in the sense that describes the general specifications of what is supposed to deliver) while Data Mining is a "technology" (in the sense that actually delivers what was promised by BI) - Is that a fair statement?


To err is human, to recurse is divine:-):-)


Thank you for clarifying Raunak - I'll take that as a "yes" :-)

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Raunak Jhawar
Raunak Jhawar
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1645 Visits: 1944
Best. Baby Diapers and Beer. Couldn't have asked a better example. You Rock. :-D

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search