Business Intelligence

1
Business Intelligence
Microsoft
Marin Bezic EMEA BI Product Manager Microsoft mari
nb_at_microsoft.com
2
Our Perspective On BI Market
Market In Transition
Not pervasive
Rationalization occurring
Must evolve to meet todays needs
3
Agility and Visibility
Business Intelligence
Business Process Management
Service Oriented Architecture
An agile business requires a flexible
infrastructure and dynamic applications.
4
Microsoft Business Intelligence
Improving organizationsby providing business
insights to all employees leading to better,
faster, more relevant decisions

• Drive pervasive business performance
• Implement a complete and integrated business
  intelligence solution
• Deliver widespread intelligence through Microsoft
  Office
• Meet enterprise needs with affordable economics

5
Business AnalyticsBI Roundup Views From
Gartner Summit
09 March 2006
6
Microsoft Business IntelligenceAn end-to-end
integrated offering
Business Scorecard Manager 2005
Performance Management Applications
ProClarity Analytics 6
PerformancePoint Server 2007
Office SharePoint Server 2007
SQL Server 2005 Reporting Services
SQL Server 2005 Integration Services
BI Platform
SQL Server 2005
7
Historical Real-Time Insight

• Acquire, transform, and synthesize historical
  data from multiple sources

• Deliver real-time insight into and alerts from
  in-flight business processes across systems

8
Microsoft Investing Heavily in BI

• FY06
• SQL Server 2005 Released Nov. 2005
• BSM 2005 Released Nov. 2005
• ProClarity Acquisition April 2006
• Beta 2 release of 2007 Office system
• PerformancePoint Announce June 2006
• 2007 Office system release end 2006
• FY07
• PerformancePoint beta Q2FY07
• PerformancePoint Release H2 07

9
Business Scorecard Manager 2005Align strategy
from the top down
Articulate goalsCentralized authoring and
accessright management of scorecardsand KPIs
Analyze issues Contextualized analysis of
scorecards, KPIs, reports and unstructured data
Collaborate and actStrong integration with
Portal and Office system
Manage your businessData-driven e-mail
notifications for scorecard and KPIs
9
10
ProClarity 6.3Advanced analytics for every
decision maker
SimpleProClarity simplifies how decision makers
receive information and gain insight into their
business
Powerful ProClarity provides organizations with
the tools they need to conduct powerful analytic
modeling
AdaptableProClarity works with a companys
existing business and technical infrastructure
and adapts to ongoing needs and changes.
Built for the Microsoft BI Platform
Fully integrated with SQL Server, Business
Scorecard Manager, SharePoint and Office
applications
10
11
Product RoadmapProClarity, BSM, and Biz
Become One
ProClarity Analytics Server
Business Scorecard Manager 2005
Scorecards
Analytics
Planning
Biz CTP
Biz
PerformancePoint Server 2007
Today
Mid CY07
November 06
12
PerformancePoint Server 2007Deliver
performance management in the Office tools people
know

• Full Office experience
• Complete perspective across all functions
• Easy to personalize scorecards, analytics, plans
• Priced for broad deployment

Finance
Sales
Operations
HR
SharePoint
Outlook
Excel
12
Microsoft Confidential.
13
Office Excel 2007New powerful analysis tools
for up to 1M rows of data
Conditional Formatting Spot trends and exceptions
in your data to better inform your decisions
Data Connection Library Quickly access the most
common data sources in your enterprise for data
analysis
Pivot Table Against SQL Server Analysis
Services Analyze data with new PivotTable tools
and enhanced support for SQL Server Analysis
Services
Publish The Server 2007
Enhanced Sorting and Filtering Sort by cell color
or filter data by quarter to work with only the
data you need
13
14
Office SharePoint Server 2007A single entry
point for all your information
Publish from Excel The Excel Services menu
enablesyou to specify which items to display and
how users can workwith the work-sheet. Then save
directly to SharePointServer 2007
Excel Services Create fully interactive web
baseddata-bound worksheets, including charts,
tables, and PivotTable views without any custom
coding
Secure Sharing Safeguard sensitive information by
controlling access to worksheets. With Excel
Services Web-enabled access, you can limit what
users can view, protecting the underlying data
and models
Dashboards Create rich, interactive dashboards
that assemble and display business information
from disparate sources, using built in web parts
such as dynamic (KPI) and OfficeExcel 2007
spreadsheets
14
15
SQL Server 2005 Reporting ServicesPresentation
Quality Enterprise Reporting
Report authoringVisually design reports layout
via the Report Designer
Report management Manage report categorization,
data sources, security, subscriptions via the
Report Manager
Model designDesign semantic models that map to
real business entities via the Model Designer
End user report creationEnable end users to
dynamically create their own Ad-hoc reports via
the Report Builder
16
SQL Server 2005 Integration ServicesEnterprise
Data Integration Platform
Metadata Management Impact and Lineage Analysis
from source systems to cubes
Development Productivity Development Environment
with visual debugging and version control
Enterprise Data Integration Scalable data
integration platform with parallel pipeline
architecture
Extensible Architecture Plug in custom components
written in C or call existing business logic
using VB.NET
17
SQL Server 2005 Analysis ServicesEnhanced
OLAP and data mining capabilities
KPI Framework Experience the manageability of a
rich centralized repository for definition and
storage of KPIs that are easily made available
for end-user consumption via e.g. BSM, Excel
SharePoint
Unified Dimensional ModelEnjoy the power of a
combined metadata model the UDM bridging the
flexibility of relational reporting with the
performance of the classic OLAP
Business Intelligence WizardsEnable even the
most novice users to build BI models and projects
addressing some of the more complex BI
scenarios
Data Mining Create new a breed of predictive
analysis applications through a rich set of data
mining tools and predefined algorithms
18
DEMO
19
SQL Server SP2 and Office

• SSAS features specific for Office 2007 for
  performance and usability
• SSRS integration with SharePoint integration of
  the report manager into the report center and
  improved web parts
• Data Mining add-in for Excel

20
BI and SOA Visibility and Agility

• BI promises visibility
• SOA promises agility and
• Microsoft delivers full stack for each enable
• Decision makers to increase business performance
• Real time alerts and views
• Proactively interact with the processes

11/7/2009
21
http//www.microsoft.com/bi
22
Summary

• Complete and integrated BI offering
• Widespread delivery of intelligence through
  Microsoft Office
• Enterprise grade and affordable

http//www.microsoft.com/bi