Transcript Microsoft Business Intelligence

Microsoft
Business Intelligence
Simon Lidberg
Principal System Engineer
Microsoft Sweden
People Drive Business Outcomes
Amplify the impact of people to empower your company
Develop
Customer
Relationships
Drive
Innovation
Improve
Operations
Build Partner
Connections
Business Intelligence
Improving business insight
“A broad category of applications
and technologies for gathering,
storing, analyzing, sharing and
providing access to data to help
enterprise users make better
business decisions.”
– Gartner
Microsoft Business Intelligence
Improving organizations
by 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
Business
Intelligence for
Everyone
Specialized
BI Tools
BI for
Everyone
At the Center is Trust
YOUR
INSIGHTS
YOUR
DATA
YOUR
DECISIONS
Microsoft Business Intelligence
Performance Management
Applications
Corporate Decisions: Support decision making
and action within corporate processes
End-user Tools
Personal and team Insights: Support individuals
gaining and sharing insight throughout the
organization
BI Platform
Sound Data: Manage consistent and quality
data once for all BI and Performance
Management needs
Performance
Management
Applications
End-user Tools
BI Platform
Microsoft Business Intelligence
Performance
Management
Applications
End-user Tools
SCORECARD/
DASHBOARD
ANALYSIS
PLANNING
BI Platform
DATA
WAREHOUSING
DATA
INTEGRATION
DELIVERY
REPORTING
OLAP
DATA MINING
Our End-to-End BI Offering
DELIVERY
SharePoint Server
Reports
Excel
Dashboards Workbooks
Analytic
Views
Scorecards
Plans
END USER TOOLS & PERFORMANCE MANAGEMENT APPS
Excel
PerformancePoint Server
BI PLATFORM
SQL Server
Reporting Services
SQL Server
Analysis Services
SQL Server DBMS
SQL Server Integration Services
Microsoft Business Intelligence
Delivering on customer needs
Performance Management
Applications, models, workflows to align, measure
and track “the business”
Performance
Management
Reporting & Analysis
Tools for reporting, analyzing and sharing
information on data
Reporting &
Analysis
Data Warehousing
Servers and tools for integrating, storing and
querying vast amounts of data
Data
Warehousing
Performance Management
Integrated solution to align and measure the business
Improve corporate performance
Scorecards to orient measurement to corporate goals
Single model to align planning and analysis to the business process
Span the organization with planning and measurement capabilities
Accelerate management decision making
Office Performance Point Server to integrate scorecarding, analysis and planning
Integrated workflow for simpler consolidation and reporting
Common model for planning used in analysis
Enable collaborative analysis
Integration with Office Excel for broad deployment
of analysis capabilities
Personalized scorecards and KPIs for individual views
Collaborative environment with context for analysis
Reporting & Analysis
Broad reach tools for insight
Analyze information with powerful and familiar tools
New Office Excel Pivot Tables for analyzing information using business terms
Tight integration between Office Excel and Microsoft SQL Server Analysis Services
ProClarity for additional advanced analysis and visualization capabilities
Enabling end-users with ad hoc reporting capabilities
Report Builder for ad hoc reporting of relational or OLAP data
Microsoft SQL Server Reporting Services for personalized
views of management data
ProClarity for personalization of reports and briefing books
Share reports and analysis over the web
Excel Services for web based viewing of analysis
Scorecards and dashboards for quickly
disseminating information
Report Center for centralized report management
and repository
Data Warehousing
Centrally managed, integrated, single version of the truth
Integrate information from disparate sources
Access corporate data in a heterogeneous environment
Cleanse and transform data with high performance
Ensure high quality data
Store and manage vast amounts of detail data
Maintain high performance for multiple users with
varying workloads
Tap multiple terabytes of atomic data for analysis
Access granular and aggregate data for reporting
Analyze information with an integrated view of your business
Proactive Caching for real time analysis
A centrally managed KPI engine for usage across the business
Data mining for predictive analytics to determine what “will” happen
Name
Title
Organization
TITLE OF DEMO
Final Points
Microsoft offers a Complete and Integrated BI Offering:
Performance Management Applications
End User Tools
BI Platform
Intelligence where users want it:
Manage data “once” in the platform
Ease of use and familiarity of Office for interaction
Ready for the Enterprise:
Server tools built for Enterprise scale
Priced and packaged so Enterprises can afford it!
http://www.microsoft.com/bi
Summary
Drive pervasive business performance
Implement a complete and integrated business intelligence
solution
Deliver widespread intelligence through Microsoft Office
Meet enterprise needs with affordable economics
The Microsoft foundation for
ubiquitous Business Intelligence
is now in place.
-AMR research, October 2005
http://www.microsoft.com/bi
20
© 2006 Microsoft Corporation.
All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The
information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must
respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any
information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS
PRESENTATION
APPENDIX SLIDES
Office PerformancePoint Server 2007
An Integrated Performance Management Solution
Scorecards
Cascading
scorecards with
interactive charts
and data from
multiple sources
including SAP
BW 3.5, and
other relational
sources
Analytics
Multi-dimensional
slice and dice for
advanced analytics
including
decomposition tree,
performance map,
and perspective
view
Planning &
Budgeting
Plan, budget,
forecast at
corporate,
divisional, and
operational
levels with visual
modeling, driverbased ‘what if’
scenarios, and
process
management
Consolidation &
Reporting
Multiple GL data
integration including
pre-built integration
with Dynamics AX,
intercompany
eliminations and
reconciliations,
multiple currency
translations, and
report wizards.
Office Excel 2007
New 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
Publish
The Server 2007
Pivot Table
Against SQL
Server Analysis
Services
Analyze data
with new
PivotTable tools
and enhanced
support for SQL
Server Analysis
Services
Enhanced
Sorting and
Filtering
Sort by cell color
or filter data by
quarter to work
with only the
data you need
Office SharePoint Server 2007
A single entry point for all your information
Publish from Excel
The Excel Services
menu enables
you to specify which
items to display and
how users can work
with the work-sheet.
Then save directly
to SharePoint
Server 2007
Excel Services
Create fully
interactive
web based
data-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 Webenabled 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 Office
Excel 2007
spreadsheets
SQL Server 2005 Analysis Services
Enhanced OLAP and data mining capabilities
Unified
Dimensional
Model
Enjoy the power
of a combined
metadata model –
the UDM –
bridging the
flexibility of
relational reporting
with the
performance of
the classic OLAP
KPI Framework
Experience the
manageability of a
rich centralized
repository for
definition and
storage of KPI’s
that are easily
made available
for end-user
consumption via
e.g. BSM, Excel
SharePoint
Business
Intelligence
Wizards
Enable 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
SQL Server 2005 Reporting Services
Presentation Quality Enterprise Reporting
Report
authoring
Visually design
reports &
layout via the
Report
Designer
End user report
creation
Enable end users
to dynamically
create their own
Ad-hoc reports
via the
Report Builder
Report
management
Manage report
categorization,
data sources,
security,
subscriptions
via the Report
Manager
Model design
Design
semantic
models that
map to real
business
entities via the
Model
Designer
SQL Server 2005 Integration Services
Enterprise 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
Our Perspective On BI Market
Market In Transition
Rationalization
occurring
Evolving to
meet business
needs
Not Pervasive
www.microsoft.com/bi