Data Mining in SQL Server 2005

1
Data Mining in SQL Server 2005

• Corie CurcilloCentral Ohio SQL SIG
• http//sqlsig.geodocs.com

2
Agenda

• Create Decision Tree and Naïve Bayes Data Mining
  Models
• View Mining Accuracy Charts
• http//msdn.microsoft.com/sql/learning/2005labs/de
  fault.aspx

3
What does Data Mining Do?
4
BI Integration

• DTS
• Data Mining processing and results integrate
  directly into the operational pipeline
• OLAP
• Process Mining Models from Universal Dimensional
  Models (Cubes), use learned content to slice
  cubes based on data-specific patterns
• Reporting
• Embed Data Mining results directly into Reporting
  Services reports

5
Data Mining Data Flow
Cube
New Dataset