Slide 1: SQL Server 2008 Business Intelligence for Architects
Lynn Langit Microsoft Developer Evangelist SoCal http://blogs.msdn.com/SoCalDevGal
Slide 2: Session Objectives and Agenda
Introduction to SQL Server 2008 for BI Architecture
SSAS – data storage, query SSIS – ETL tools Clients – Microsoft and more
Future Directions in BI
Slide 3: What is Business Intelligence?
Slide 4: Why use BI solutions?
Slide 5: SQL Server 2008 BI
Source Data OLAP ETL / SSIS (SQL Server) SSAS Client / SSRS MOSS / PPS
Slide 6: SQL Server BI Stack
Slide 7: SSAS considerations
Slide 8: SSIS considerations
Slide 9: Client considerations
Slide 10: SQL Server 2008 BI Focus Areas
Slide 11: New in SSAS for OLAP Cubes
Slide 12: New in SSAS for Data Mining
Slide 13: New in Excel Integration
Slide 14: New in SSIS
Slide 15: New in SSRS & SharePoint
Slide 16: DM Resources
SQL Server Data Mining http://www.sqlserverdatamining.com http://www.microsoft.com/bi/bicapabilities/data-mining.aspx Technical Communities, Webcasts, Blogs, Chats & User Groups http://www.microsoft.com/communities/default.mspx Microsoft Learning and Certification http://www.microsoft.com/learning/default.mspx Microsoft Developer Network (MSDN) & TechNet http://microsoft.com/msdn http://microsoft.com/technet Trial Software and Virtual Labs http://www.microsoft.com/technet/downloads/trials/default.mspx
Slide 17: Learning more - DM Webcasts
Fri, 02 Nov 2007 MSDN Webcast: Build Smart Web Applications with SQL Server Data Mining (Level 200) Thu, 08 Nov 2007 MSDN Webcast: Building Adaptive Applications with SQL Server Data Mining (Level 300) Mon, 19 Nov 2007 MSDN Webcast: Extending and Customizing SQL Server Data Mining (Level 300) Fri, 30 Nov 2007 MSDN Webcast: Creating Visualizations for SQL Server Data Mining (Level 300) Thu, 01 Nov 2007 TechNet Webcast: Deliver Actionable Insight Throughout Your Organization with Data Mining (Par Thu, 15 Nov 2007 TechNet Webcast: Deliver Actionable Insight Throughout Your Organization with Data Mining (Par Thu, 29 Nov 2007 TechNet Webcast: Deliver Actionable Insight Throughout Your Organization with Data Mining (Par
Slide 18: BI Resources from Lynn Langit
1. “Foundations of SQL Server 2005 Business Intelligence”
(published by APress in April 2007)
2. http://blogs.msdn.com/SoCalDevGal
3. “Smart Business Intelligence Solutions with Microsoft SQL Server 2008”
(MSPress Fall 2008)
Slide 19: Summary
Mature BI from SQL Server 2008
Complete & integrated suite – data storage, ETL and clients Scalable, Securable, Enterprise-level performance
Usability – particularly around ease of design for SSAS Performance & Scalability –
Improvements in SQL Server 2008 BI
SSIS pipeline, SSRS report renderer SSAS scale out SSAS wizards SSRS removal of IIS dependency
Simplified configuration and management
