enterprise data mining for sql server professionals 20110319
DESCRIPTION
Presentation from SQL Saturday 70 -- Columbia, SC -- SQL Server Data Mining, Enterprise Level (SQL Server Management Studio, Integration Services, PowerShell)TRANSCRIPT
![Page 1: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/1.jpg)
ENTERPRISE DATA MINING FOR SQL SERVER PROFESSIONALSMark Tabladillo Ph.D.
http://marktab.net
@marktabnet
March 19, 2011
©2010 MARK TABLADILLO
![Page 2: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/2.jpg)
INTRODUCTION
Phrase Goal
Data Mining Inform actionable decisions
Machine Learning Determine best performingalgorithm
©2010 MARK TABLADILLO
![Page 3: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/3.jpg)
“SQL SERVER PROFESSIONAL”
AnalystArchitectDeveloper
©2010 MARK TABLADILLO
![Page 4: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/4.jpg)
ENTERPRISE CHALLENGE
©2010 MARK TABLADILLO
![Page 5: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/5.jpg)
ENTERPRISE CHALLENGE
©2010 MARK TABLADILLO
![Page 6: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/6.jpg)
ENTERPRISE CHALLENGE
©2010 MARK TABLADILLO
![Page 7: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/7.jpg)
ENTERPRISE CHALLENGE
©2010 MARK TABLADILLO
![Page 8: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/8.jpg)
SERVER PHYSICAL ARCHITECTURE
http://msdn.microsoft.com/en-us/library/ms174776.aspx
©2010 MARK TABLADILLO
![Page 9: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/9.jpg)
SERVER LOGICAL ARCHITECTURE
http://msdn.microsoft.com/en-us/library/ms174587.aspx
©2010 MARK TABLADILLO
![Page 10: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/10.jpg)
ENTERPRISE SOLUTIONS
SQL Server Management Studio (SSMS)Business Intelligence Development Studio (BIDS)
SQL Server Integration Services (SSIS)PowerShell version 2
©2010 MARK TABLADILLO
![Page 11: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/11.jpg)
OUTLINE
Contoso Retail and FundamentalsEnterprise-Level Demo for SQL Server ProfessionalsWhat is my next step?
©2010 MARK TABLADILLO
![Page 12: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/12.jpg)
WHAT IS CONTOSO RETAIL?
Demonstration dataset for SQL Server Database Engine and Analysis Serviceshttp://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=868662dc-187a-4a85-b611-b7df7dc909fc
©2010 MARK TABLADILLO
![Page 13: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/13.jpg)
WHAT ARE THE FUNDAMENTALS?
‘Readin (reading)‘Riting (writing)‘Rithmetic (arithmetic)
©2010 MARK TABLADILLO
![Page 14: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/14.jpg)
XMLA
http://msdn.microsoft.com/en-us/library/ms174518.aspx
©2010 MARK TABLADILLO
![Page 15: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/15.jpg)
DATA MINING STRUCTURES
http://msdn.microsoft.com/en-us/library/cc645741.aspx
http://msdn.microsoft.com/en-us/library/ms174757.aspx
©2010 MARK TABLADILLO
![Page 16: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/16.jpg)
DATA MINING MODELS
http://msdn.microsoft.com/en-us/library/cc645779.aspx
©2010 MARK TABLADILLO
![Page 17: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/17.jpg)
WHAT IS MY NEXT STEP?
SQL Server 2008 Enterprise (includes database engine, Analysis Services, SSMS and BIDS)
http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx
Microsoft Office 2010 Professionalhttp://office.microsoft.com/en-us/try
Powershell 2.0http://support.microsoft.com/kb/968929
Data Mining Portal and Bloghttp://www.marktab.net
©2010 MARK TABLADILLO
![Page 18: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/18.jpg)
©2010 MARK TABLADILLO
![Page 19: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/19.jpg)
©2010 MARK TABLADILLO
![Page 20: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/20.jpg)
©2010 MARK TABLADILLO
![Page 21: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/21.jpg)
CONCLUSION
Analysts, Architects and Developers can tackle enterprise data mining challenges with
SQL Server Management StudioBusiness Intelligence Development StudioPowerShell version 2
©2010 MARK TABLADILLO
![Page 22: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/22.jpg)
HOW CAN I IMPROVE DATA MINING PERFORMANCE?
Use SQL Server Analysis Services for what it does best: store and provide models
Use Best Practices for SQL Server Analysis Services as published by SQLCAT http://sqlcat.com (requires as much professional study as you would like to invest)
Practice model parsimony (requires as much mathematical study as you would like to invest)
Send your data mining performance question: http://marktab.net
©2010 MARK TABLADILLO
![Page 23: Enterprise Data Mining for SQL Server Professionals 20110319](https://reader034.vdocuments.us/reader034/viewer/2022052601/558bf5a8d8b42a4a578b469c/html5/thumbnails/23.jpg)
WHERE CAN I FIND MORE INFORMATION?
http://marktab.net Data Mining Resourcehttp://marktab.net/datamining Data Mining Bloghttp://sqlserverdatamining.com SQL Server Data Mininghttp://technet.microsoft.com Microsoft’s TechNet
©2010 MARK TABLADILLO