Introducción A Sql Server Data Mining

11/3/2009

Introduction to Data Mining with SQL Server

Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions
l l l lIntegrated platform and applications Secure and personalized Collaborative Cost effective and comprehensive

Integrate
Data acquisition from source systems and integration Data transformation andsynthesis

Analyze
Data enrichment, with business logic, hierarchical views Data discovery via data mining

Report
l l

l

l

l

l

Data presentation and distribution Data access for themasses

1

11/3/2009

Project objective: Capture transaction level sales and
store stock position to increase sales and improve profitability

Customer Business Challenge
l l l

Solution:Microsoft BI
l

Customer Results/Benefits
l

l

Instances of store out of stock Inappropriate stock levels Difficult to perform analysis of large data volumes Overburdened operational systemsl

End to end business intelligence with: SQL Server, Reporting Services, Analysis Services, Integration Services and Data Mining 1.6 TB Raw Data, 64-bit, 20-way server

l

l

50% reductionin development time over Oracle SQL Server Integration Services shows up to 400% performance improvement Deliver more meaningful, up-to-date info

A Definition
}

Data mining is the process ofextracting patterns from data. As more data are gathered, with the amount of data doubling every three years,[1] data mining is becoming an increasingly important tool to transform these data intoinformation. It is commonly used in a wide range of profiling practices, such as marketing, surveillance, fraud detection and scientific discovery.

What does Data Mining Do?

Explores Your DataFinds Patterns

Performs Predictions
Data Mining Why How

Query, Reporting, Analysis What

2

11/3/2009

Comparative Benefits
Predictive Projects versus Nonpredictive Projects
80% 70% 60%...