1 / 5

Data Mining in SQL Server 2005

Learn how to create Decision Tree and Naïve Bayes models, view accuracy charts, and integrate results into BI pipelines with SQL Server 2005.

russelh
Download Presentation

Data Mining in SQL Server 2005

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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/default.aspx

  3. Explores Your Data Performs Predictions Finds Patterns 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. 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

More Related