Bi con sql 2008

Microsoft Business Intelligence Strategy Overview
®

Juan Manuel Alvarado juan@gyssa.com MVP SQL SERVER

Understanding Business Intelligence
Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions BI applications include the activities ofdecision support, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining

Feb-2008

Microsoft Developer & Platform Evangelism

2

Understanding Business Intelligence
Or put simply…

It is the application of knowledge derived from analyzing an organization’s data to effect a more positive outcome

Feb-2008

Microsoft Developer &Platform Evangelism

3

Applying Business Intelligence
BI is used to…

Understand the health of the organization
Collaborate on a shared view of business drivers Reduce the time to decision

Its goal is often to…
Impact the bottom line by measuring specific operations Enhance competitive advantage
BI is no longer a luxury afforded by a few large companies—it is now considered anessential part of the IT portfolio
Feb-2008 Microsoft Developer & Platform Evangelism 4

Addressing Common Business Problems
Common Business Questions

Common Information Problems
Common Information Requirements

Feb-2008

Microsoft Developer & Platform Evangelism

5

Common Business Questions
How are the sales territories performing?

How are the sales people performing?
Whichcustomers are likely to buy from us? What products do our customers buy together?
What data-related problems might arise when answering these questions?

Feb-2008

Microsoft Developer & Platform Evangelism

6

Common Information Requirements
Decision makers need

Reliable, secure access to data to do their job effectively
Flexibility in the ways they access data Tools to browse andanalyze data and view reports

Low time-to-impact; low latency query results

Feb-2008

Microsoft Developer & Platform Evangelism

7

Delivering Information to Decision Makers

DEMO 1

Feb-2008

Microsoft Developer & Platform Evangelism

8

Integrated Reporting and Analytics
9: process of warehouse and reporting 8: 7: 6: Delivering 5: Manual useBI can bedata to query continuousdata sources 4: Stagingmayvarioussimplify the datafordata reduce data 3: The sourcesaccesstoolssources directlyto warehouse 2: Datadataareasenablesmanages populated from business improvement 1: Clients needaccessperiodicallydatathecleanse dirty contention warehouse ismayabe required to analyzingpopulation cleansing to data warehouse mirrored/replicated may Data Sources
Data Warehouse Data MartsStaging Area

Client Access
Manual Cleansing
Feb-2008 Microsoft Developer & Platform Evangelism

Client Access
9

Introducing the Microsoft BI Platform
Microsoft’s BI Strategy and Vision

The Microsoft BI Platform
Microsoft SQL Server 2008 2007 Microsoft Office System

Microsoft-Based BI Solutions

Feb-2008

Microsoft Developer & Platform Evangelism

10

Microsoft’s BIStrategy and Vision
To improve organizations by providing business insights to all employees, leading to better, faster, more relevant decisions

• Microsoft has a long-term commitment to delivering a complete and integrated BI offering • SQL Server has led innovation in the BI space for more than a decade • There is widespread delivery of intelligence through Microsoft Office • The platforms areenterprise-grade and affordable
Feb-2008 Microsoft Developer & Platform Evangelism 11

Microsoft BI Platform Integration

Powerful Cost Effective Fast Time-to-Market Choice of Integration Points

Integrated BI Solution

Performance Management

Enterprise Grade Pervasive Integrated Flexible Full Featured Interoperable Extensible
Feb-2008

Information Worker Platform

Data Platform...