Bi con sql 2008
®
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...
Regístrate para leer el documento completo.