Transcript What is Data mining?? - Zulfiqar`s web

Data mining using SQL SERVER
2005
My name: ZULFIQAR SYED
 Holds BSEE from Illinois Institute of
Technology.
 MCP in ASP.net (C#)
 SQL SERVER, ASP.NET, C#, DATA
MINING, ANALYSIS SERVICES.
 CONTACT:
[email protected]
 HTTP://ZULFIQAR.TYPEPAD.COM

Business Problem..


Adventure Works Bike Store (sample database)
On a limited marketing budget.
 Maximize

profits.
Biggest “bang” for the buck..
Random selection.
 Magic bowl.
 Data mining (between random and magic)

Today, we will go over…

Introduction to data mining.
What??
 Why??
 How??


Data mining demo.
Prepare Data
 Create analysis and prediction
 Report on predictions.

Prerequisites for data mining


SQL SERVER
T-SQL
What is Data mining??


The process of analyzing data to identify
patterns or relationships.
Searching large volumes of data looking for
patterns that accurately predict behavior in
customers and prospects.
Basics of data mining??
1.
2.
3.
4.
Create mining model based on an algorithm.
Train model by passing historical data.
Newly trained model contains data patterns.
Analyze or make predictions on new data by
using it against the trained model.
Demonstration

Demo on data mining.
Demonstration recap.





Used Integration Services to create the “test”
and “train” data.
Created the model and trained it using train data.
Evaluated different models using test data.
Created report using reporting services.
Managed different projects from the same
solution.
Q and A

Books



Please fill out the evaluation form.



Data mining Techniques (Berry/Linoff)
Data mining with Sql Server 2005. (Tang/MacLennan)
NAME: ZULFIQAR SYED
SESSION: Data mining using SQL Server 2005
My contact information:


[email protected]
Web log: HTTP://ZULFIQAR.TYPEPAD.COM
These slides will be posted on my web log.