1 / 14

SQL Server Data Mining

Brian Knight, President Pragmatic Works. SQL Server Data Mining. Do the demos with me. Prerequisites : AdventureWorksDW2008R2 or 2012 SSAS 2008 + (MOLAP mode). About Brian. Was never good with grils Visit if you enjoy reading about collecting Hot Wheels.

zariel
Download Presentation

SQL Server Data Mining

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. Brian Knight, President Pragmatic Works SQL Server Data Mining Do the demos with me. Prerequisites : AdventureWorksDW2008R2 or 2012 SSAS 2008 + (MOLAP mode)

  2. About Brian Was never good with grils Visit if you enjoy reading about collecting Hot Wheels SQL Server MVP Pragmatic Works Founder Author of 13 books Blogs at BIDN.com Twitter: @brianknight

  3. Explores Your Data Performs Predictions Finds Patterns What does Data Mining Do?

  4. BusinessUnderstanding DataUnderstanding Data Preparation Modeling Evaluation Deployment Data Mining Process “Doing Data Mining” Data “Putting Data Mining to Work” www.crisp-dm.org

  5. BusinessUnderstanding DataUnderstanding Data Preparation Modeling Evaluation Deployment Data Mining Process in SQL SSAS (OLAP) DSV SSIS SSAS (OLAP) Data SSIS SSAS(OLAP) SSRS Flexible APIs SSAS (Data Mining) www.crisp-dm.org

  6. Clustering Time Series Naïve Bayes Sequence Clustering Association Rules Complete set of algorithms Decision Trees Introduced in SQL Server 2000 + Linear Regression Logistic Regression Neural Networks

  7. Demo • What is the end-game?

  8. Embedded Data Mining • Make Decisions without Coding • Client Customization • Automatic Update

  9. Data Mining EXpressions • OLE DB for Data Mining specification • Now part of XML/A specification • See www.xmla.org for XML/A details • Connect to Analysis Server • OLEDB, ADO, ADO.Net, ADOMD.Net, XMLA Dim cmd as ADOMD.Command Dim reader as ADOMD.DataReader Cmd.Connection = conn Set reader = Cmd.ExecuteReader(“Select Predict(Gender)…”)

  10. Demo • Decision Tree

  11. Demo • Time Series

  12. BI Integration • Integration Services • OLAP • Reporting Services • .Net

  13. Demo • Integration into the BI stack

  14. Thank you for attending this session and the 2013 PASS Summit in Charlotte, NC

More Related