50 likes | 61 Views
Data Mining in SQL Server 2005. Corie Curcillo Central Ohio SQL SIG http://sqlsig.geodocs.com. Agenda. Create Decision Tree and Naïve Bayes Data Mining Models View Mining Accuracy Charts http://msdn.microsoft.com/sql/learning/2005labs/default.aspx. Explores Your Data. Performs Predictions.
E N D
Data Mining in SQL Server 2005 Corie CurcilloCentral Ohio SQL SIG http://sqlsig.geodocs.com
Agenda • Create Decision Tree and Naïve Bayes Data Mining Models • View Mining Accuracy Charts http://msdn.microsoft.com/sql/learning/2005labs/default.aspx
Explores Your Data Performs Predictions Finds Patterns What does Data Mining Do?
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
LOB Application Model Browsing Web Historical Dataset .Net Native Reporting Data Transform (DTS) SQL OLE/DB Text File Prediction Mining Models Cube Operations (DTS) Data Mining Data Flow Cube New Dataset