Transcript Office 2003 PowerPoint Presentation

Improving Business Insight
Microsoft Business Intelligence – BI for the Masses
Charles Russell, Microsoft; Joe Crisologo, Microsoft;
Agenda
Setting the Scene
• The opportunity
How Can Microsoft Help?
• Microsoft Business Intelligence Solutions
Business Productivity Optimisation Model
Business Intelligence in Action
• Partner
Summary & Call to Action
The View from the Analysts
“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
Where are CIO’s investing in Australia
2006 CIO Technology Priorities*
Au
2006
Rank
Global
2006
Rank
Collaboration Technologies
1
4
Business Intelligence Applications (Data mining, warehousing)
2
1
Security Technologies ( access control, authenication, etc)
3
2
Networking, Voice & Data Comms
4
8
Mobile Workforce Applications
5
3
Workflow Management
6
7
Service oriented appications & architecture (SOA, SOBA)
7
6
Technical Infrastructure management & development
8
13
Virtualisation (Storage, Computing, Data Center)
9
9
10
11
Knowledge Management
Gartner Report
Key Drivers of Adoption Rankings
1.
2.
3.
4.
5.
6.
7.
8.
Corporatre Performance management
Sales Analytics
Customer/marketing analytics
Human Resources analytics
Supply chain analytics
E-Commerce analytics
Manufacturing analyticss
Analytics across a combination of areas
Business Intelligence Adoption Challenges
Users lack necessary skills
TCO is high
Difficult to learn and use
Sources:
- Gartner: The Business Intelligence Market Trends and Directions, 2006
Microsoft Business Intelligence
Improving business insight
Performance
Management
Reporting
and Analysis
Improving organizations
by providing business insights
to all employees leading to
better, faster, more relevant
decisions
Data
Warehousing
Business Productivity Infrastructure
Streamline the way people do business with 2007 Office System
Unified
Communications
And Collaboration
Workflow
Business
Enterprise Content
Management
Intelligence
Search
Business
Data
Catalog
Extensible
UI
Open
XML File
Formats
Secured, Well-Managed Infrastructure
Website
And
Security
Framework
Application Platform Infrastructure
Advance your business IT solutions that maximise business opportunity
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 and 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
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
Microsoft Business Intelligence
An end-to-end integrated offering
Performance
Management
Applications
End User
Tools
BI
Platform
ERP,
CRM,
SCM
Business
Scorecard PerformancePoint Server
ProClarity
Analytics 6
2007
Manager 2005
Office SharePoint Server 2007
Office Excel 2007
SQL Server 2005 SQL Server 2005
SQL Server 2005
Integration Services Analysis Services Reporting Services
SQL Server 2005
Map Your Infrastructure Journey
Improve business insight with Business Intelligence
Data silos, custom
and IT dependent
reporting,
Limited automation
of data management
IT is a cost
center
Disconnected
scorecards and IT
dependant reporting
and analysis on
subjectoriented data
Automation of data
loading
IT is a more efficient cost
center
Infrastructure for
enterprise-wide
centralized
scorecards and selfservice reporting
Centralized data
management
IT is a business
enabler
Federated document
and records mgmt
within and outside
enterprise. Single
search across
desktop, enterprise
content
and LOB
IT is a strategic
asset
Next Steps
View the Business Intelligence website
http://www.microsoft.com/bi
Review the Business Intelligence Product Guide
http://www.microsoft.com/office/preview
Download the SQL Server evaluation copy
http://www.microsoft.com/sql/downloads/trial-software.mspx
Download 2007 Office system Beta 2
http://www.microsoft.com/office/preview
Summary
The Microsoft foundation for
ubiquitous Business Intelligence
is now in place
– AMR research, October 2005
 Complete and integrated BI offering
 Widespread delivery of intelligence through Microsoft Office
 Enterprise grade and affordable
Call To Action
Register your interest on your session EVAL form for:
A Microsoft Solutions Specialist to deliver a deep dive demonstration
and business update to you and your key IT decision makers
A Microsoft Infrastructure Optimisation Workshop (including
workshops providing guidance and best practice on identifying,
building and deploying Microsoft Solutions) delivered by a Microsoft
Partner
A visit for your IT Decision Makers to our immersive demonstration
facility the Microsoft Business Productivity Centre.
Coming soon: Attend an in-depth Industry Briefing in ECM by
Microsoft in your capital city in February & March.
21