Business Intelligence in Microsoft SQL Server 2005

1
(No Transcript)
2
Business Intelligence in Microsoft SQL Server
2005

• Marin Bezic
• Microsoft EMEA
• SQL BI PRODUCT MANAGER
• marinb_at_microsoft.com

3
Agenda

• Overview of SQL Server 2005 Business Intelligence
• Vision
• Microsoft BI offering
• Integrate
• Report
• Analyze
• Office Business Scorecard Manager
• Demo!

4
(No Transcript)
5
(No Transcript)
6
Improving organizations by providing business
insights to all employees leading to better,
faster, more relevant decisions.

• Integrated platform and applications
• Secure and personalized
• Collaborative
• Cost effective and comprehensive

7
BI For The Entire Enterprise
Operational
Strategic
Tactical

• 24x7 BI
• Enterprise ETL
• Embedded
• New Form Factors

• Data Access
• Analysis
• Collaboration

Execs
Strategic Value
Analysts/ Middle Mgrs

• Timeliness
• Ease of Use
• High-Level View

Ops
Number of decisions
8
Integrated Offering
Integrated BI Offering
9
Microsoft BI Offering
Integrated BI Offering
10
SQL Server 2005 Business Intelligence
Management Tools
Development Tools
Reporting Services
Analysis Services OLAP Data Mining
Integration Services ETL
SQL Server Relational Engine
11
SQL Server 2005 Business Intelligence

• Partitioning Support
• Online operations
• Snapshot isolation
• Insert and load improvements
• T-SQL enhancements
• Native XML
• .NET Framework

Management Tools
Development Tools
Reporting Services
Analysis Services OLAP Data Mining
Integration Services ETL
SQL Server Relational Engine
12
SQL Server 2005 Business Intelligence

• Major investment
• New ETL pipeline
• Complex data routing
• Scale and performance
• DW BI Savvy
• Rich transformations
• Integration with Analysis Services
• Enhanced designer and control flow

Management Tools
Development Tools
Reporting Services
Analysis Services OLAP Data Mining
Integration Services ETL
SQL Server Relational Engine
13
SQL Server 2005 Business Intelligence

• Unified Dimensional Model
• Integrating relational and OLAP views
• Pro-active caching
• Bringing the best of MOLAP to ROLAP
• Advanced Business Intelligence
• KPIs, MDX scripts, translations, currency
• Data Mining
• Smart applications

Management Tools
Development Tools
Reporting Services
Analysis Services OLAP Data Mining
Integration Services ETL
SQL Server Relational Engine
14

• Traditional and interactive reports
• Scalable, manageable and embeddable server
  infrastructure
• Integration with SharePoint Portal Server,
  Office, browser and other familiar tools
• Support for relational, OLAP, XML and other data
  sources
• End user report building tool

Management Tools
Development Tools
Reporting Services
Analysis Services OLAP Data Mining
Integration Services ETL
SQL Server Relational Engine
15
SQL Server 2005 Business Intelligence

• A complete, integrated environment
• Integration Services, Relational, OLAP, Data
  Mining, Reports, KPIs, code, web pages,
• Supports the entire life cycle
• Prototyping, development, test, deployment,
  modification
• Supports enterprise development
• Teams, source control, versioning, etc.

Development Tools
Management Tools
Reporting Services
Analysis Services OLAP Data Mining
Integration Services ETL
SQL Server Relational Engine
16
Business Intelligence Suites Microsoft
Microsoft SQL Server 2000 Reporting Services,
SQL Server 2000 Analysis Services, SQL Server
Accelerator for Business Intelligence overall
vote 24.4 vote, Large Enterprises 20.4
vote, SMEs 25.7 Satisfaction Rating 75
Runner-upCognosCognos Enterprise BI Series
Multidimensional Analysis (OLAP) Microsoft
Microsoft SQL Server 2000 Analysis Services
overall vote 26.0 vote, Large Enterprises
21.6 vote, SMEs 30.3 Satisfaction Rating
78 Runner-upCognosCognos PowerPlay 7.3
1
1
Extract, Transform and Load Informatica
PowerCenter overall vote 29.0 vote,
Large Enterprises 41.5 vote, SMEs 20.4
Satisfaction Rating 81 Runner-upMicrosoft
Microsoft SQL Server 2000 Data Transformations
Services (DTS)
Ad Hoc Query Reporting Microsoft Microsoft
SQL Server 2000 Reporting Services overall
vote 22.2 vote, Large Enterprises 13.6
vote, SMEs 28.9 Satisfaction Rating 74
Runner-upBusiness ObjectsWebIntelligence
1
2
17
OLAP Leadership

• http//www.olapreport.com

18
Core BenefitsDeep contextual insight
Office Business Scorecard Manager

• Rapidly display and share scorecards on Web pages
• Gain immediate access to analysis and
  unstructured data functionality
• Drill down through KPIs for deeper transactional
  insight
• Get all-on-one-page interaction

Charting and Analysis
Scorecard
Report
Documents Spreadsheets
MapPoint / Visio / OWC / Reporting Services
Integration
19

• DEMO Office Business Scorecard Manager

20
Summary

• SQL Server 2005 is a major BI release
• Complete, end-to-end BI platform
• From data collection to delivery
• SQL Server 2005 brings OLTP abilities to BI
• SQL Server 2005 makes BI development easy
• SQL Server 2005 BI is enterprise ready