Data Mining with SQL Server 2005 and 2008

Well this is a surprise one! The original session I had planned on BI has been canned and this put in place! This has been happening a fair bit this week and a few of the BI/Analysis Services ones have been cancelled very last minute! Ah well on with the show!

Wow apparently Data Mining is the exact opposite of cryptography! Legal Hacking!!!!

Oh yeh its Rafal again so more Microsoft failures may be posted!

Not only for Business Intelligence but mining can be used for database logs and server logs to explore the hidden answers that exist within any data.

For those who dont know what Data Mining is....

• 
  
  Technologies for analysis of data and discovery of (very) hidden patterns.
  
• 
  
  Uses a combination of statistics, probability analysis and database technologies
• 
  Fairly young (<20>

And this is what it does...

Explores your data --------> Finds Patterns--------> Performs Predictions

OLAP and Data Mining is PREDICTIVE ANALYSIS!

We can apparently even use Data Mining to correct and improve the ETL Process for the Datawarehouse! It works out if things are missing! Surely this is the best thing since sliced bread!

Sorry Im running out of photos now.

Create Mining Model (Sytanx)

CREATE MINING MODEL MyModel

(

[CustID] Text KEY,

[Gender] Text DISCRETE,

...

[Home Ownership] TEXT DISCRETE PREDICT,

...

) USING Microsoft_Decision_Trees

PREDICT is what you want the Mining Model to predict. You can PREDICT Multiple items.

A demonstration followed showing the steps involved with creating a Mining Model and starting to drill!