Transcript Drive pervasive business performance

Improving Business Insight
Building a cube using Analysis Services
Gustavo Santade
Business Intelligence Project Manager
People Drive Business Outcomes
The New World Of Work
Workplace
Trends
Role of
Software
One world
of business
Simplify
working together
Always on,
always connected
Find info and
improve
business insight
Transparent
organization
Secure and
manage content
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
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
Search
Business
Intelligence
Business
Data
Catalog
Enterprise Content
Management
Open
Extensible XML File
UI
Formats
Secured, Well-Managed Infrastructure
Website
And
Security
Framework
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
Business
ProClarity Analytics
Scorecard PerformancePoint Server
2007
6
Manager 2005
Office SharePoint Server
2007
Office Excel
2007
SQL Server
SQL Server 2005
2005 Analysis
Integration Services
Services
BI
Platform
SQL Server 2005
SQL Server 2005
Reporting
Services
Demo
© 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