Enterprise Data Mining with Microsoft SQL Server

Mark Tabladillo Ph.D.MentorSolidQ http://solidq.com

DBI326

Enterprise

Enterprise Challenge

Enterprise Challenge

Enterprise Challenge

Enterprise Challenge

Data Mining

Definitions

Phrase Goal

“Data Mining” Inform actionable decisions

“Machine Learning” Determine best performing algorithm

SQL Server 2008 R2

Server Physical Architecture

http://msdn.microsoft.com/en-us/library/ms174776.aspx

Server Logical Architecture

http://msdn.microsoft.com/en-us/library/ms174587.aspx

Outline

Contoso Retail and FundamentalsEnterprise-Level Data Mining Demo for SQL ServerWhat is my next step?

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

What are the fundamentals?

Readin’ (reading)‘Riting (writing)‘Rithmetic (arithmetic)

What Enterprise Tools support Data Mining?

SQL Server Management Studio (SSMS)Business Intelligence Development Studio (BIDS)

SQL Server Integration Services (SSIS)

PowerShell version 2

demo

Contoso Retail:Enterprise Data MiningMark Tabladillo

Documentation

Data Mining Structureshttp://msdn.microsoft.com/en-us/library/cc645741.aspx http://msdn.microsoft.com/en-us/library/ms174757.aspx

Data Mining Modelshttp://msdn.microsoft.com/en-us/library/cc645779.aspx

What is my next step?

SQL Server 2008 R2 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

Conclusion

Data mining leaders can tackle enterprise data mining challenges with

SQL Server Management StudioBusiness Intelligence Development StudioPowerShell version 2

Become leaders of leaders of leaders

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

Graphics

Ship graphics Copyright © 1995-2006 Nova Development and its licensors. All rights reserved. Used with permission.

Related Content

Breakout SessionsDBI203 Introducing the Next Generation Design Tools for Microsoft SQL Server Analysis ServicesDBI207 Using Knowledge to Cleanse Data with Data Quality ServicesDBI209 A Lap around Microsoft Business IntelligenceDBI330 Can Your BI Solution Scale?

Interactive SessionsDBI381-INT Microsoft BI Roadmap: Unplugged

Related Content

Hands-on LabsDBI272-HOL Advanced Dashboard Creation Using PerformancePoint Services

Pre-Conference SeminarPRC12 Build Your First Microsoft BI Solution with SQL Server 2008 R2

Related Certification Exam: MCITP: Business Intelligence Developer 2008

Find Me Later:Message me through http://marktab.netTwitter Feed @marktabnet

What’s Next?

Follow, Tweet and Enter to win an Xbox Kinect Bundle

GAME ON! Join us at the top of every hour at the BI booth to compete in the Crescent Puzzle Challenge and Win Prizes

Sign up to be notified when the next CTP is available at: microsoft.com/sqlserver

@MicrosoftBI

/MicrosoftBI

Join the Conversation

Resources

www.microsoft.com/teched

Sessions On-Demand & Community Microsoft Certification & Training Resources

Resources for IT Professionals Resources for Developers

www.microsoft.com/learning

http://microsoft.com/technet http://microsoft.com/msdn

Learning

http://northamerica.msteched.com

Connect. Share. Discuss.

Complete an evaluation on CommNet and enter to win!

Scan the Tag to evaluate this session now on myTech•Ed Mobile