Microsoft Business Intelligence Overview

Myles Matheson

• Solution Specialist – Application Platform
• DAT202

Today’s Session

• Microsoft BI Vision
• The BI Reporting Maturity Model
• Integration Services Overview
• Demo of Integration Services
• Business User BI Tools
• Demo of Analysis Services
• Demo of Re[porting Services and Performance Point
• BI Road Map

Microsoft Business Intelligence Stack

• Data Infrastructure & BI Platform – SQL Server 2008
• Business Collaboration Platform – Office SharePoint Server 2007
• Business User Experience – Office

BI Demystified - It’s simpler than you might think

• Your existing systems – Data collected in your systems like CRM, ERP, Finance, etc.
• Data collection – Data repository
• Dashboards & Scorecards

Integration Services – Enterprise Data Integration Platform

• Scalable Platform
• Comprehensive transformations
• Extensible Platform

Analysis Services 2008 – Drive Pervasive Insights

• Design Scalable Solutions
• Extend Usability
• Deliver Actionable Insight

Reporting Services 2008 – Deliver Enterprise Reports

• Author Impactful Reports
• Manage Enterprise Workload
• Deliver Personalized Reports

Integrated Predictive Analysis – Predictive KPIs

• Integration with Microsoft Office PerformancePoint Server 2007
• Analytics

BI Roadshow for Business Decision Makers

• November 16-18 in NZ

Kimball University

• Microsoft Data Warehouse in Depth 20-23 Oct 2009
• Kimball University courses 2010

Microsoft Data Warehouse in Depth

• Sydney
• Hosted by Altis Consulting
• AU$3700
• Taught by Joy Mundy & Warren Thornthwait, co-authors of the best selling Microsoft Data Warehouse Toolkit