微软SQL数据挖掘_数据仓库技术研讨会材料.ppt

欢迎光临微软SQL数据挖掘/数据仓库技术研讨会 今日安排 微软SQL数据挖掘技术概述 左洪 微软公司 数据仓库在电信的应用 贝志城 明天高科 数据挖掘在CRM中的应用 王立军 中圣公司 灵通IT Service维护管理服务系统 邹雄文 广州灵通 Agenda What is Data Mining The Data Mining Market OLE DB for Data Mining Overview of the Data Mining Features in SQL Server 2000 QA What Is Data Mining? What is DM? A process of data exploration and analysis using automatic or semi-automatic means “Exploring data” – scanning samples of known facts about “cases”. “knowledge”: Clusters, Rules, Decision trees, Equations, Association rules… Once the “knowledge” is extracted it: Can be browsed Provides a very useful insight on the cases behavior Can be used to predict values of other cases Can serve as a key element in closed loop analysis What drive high school students to attend college? The deciding factors for high school students to attend college are… Business Oriented DM Problems Targeted ads “What banner should I display to this visitor?” Cross sells “What other products is this customer likely to buy? Fraud detection “Is this insurance claim a fraud?” Churn analysis “Who are those customers likely to churn?” Risk Management “Should I approve the loan to this customer?” … Mining Process - Illustrated The Data Mining Market The $$$: Y2000 Market Size DM Tools Market: $250M 40% - license fees 60% consulting The Players Leading vendors SAS SPSS IBM Hundreds of smaller vendors offering DM algorithms… Oracle –Thinking Machines acquisition The Products End-to-end Data Mining tools Extraction, Cleansing, Loading, Modeling, Algorithms (dozens), Analysts workbench, Reporting, Charting…. The customer is the power-analyst PhD in statistics is usually required… Closed tools – no standard API Total vendor lock-in Limited integration with applications DM an “outsider” in the Data Warehouse Extensive consulting required Sky rocketing prices $60K+ for a single user license What the analysts say… “Stand-alone Data Mining Is Dead” - Forrester “The demise of [stand alone] data mining” – Gartner