Transcript right information, right time, right format

Radu Pasol
Consultant
Microsoft Consulting Services
Improving organizations by
providing business insights to all
employees leading to better,
faster, more relevant decisions
 Complete and integrated BI offering
 Widespread delivery of intelligence
through Microsoft Office
 Enterprise grade and affordable
What Is Business Intelligence (BI)?
Business Intelligence drives fact-based decision making and management
leading to better business performance.
Statistical Content
Business
Performance
Predictive
Analytics
Analytical Insight
Reporting
Retrospective
Business Process
Mgt.
Query/Ad Hoc
Exploration
Current
Prospective
right information, right time, right format
Too much data not too little
Enterprise-wide to business unit specific
Across various subjects areas
Executive, operational, and tactical levels
right information,
right time, right format
What am I looking at?
Historic data
Real-time
Predictive
When do I need it?
Now
Future
right information, right time, right
format
Integrated data presentation
Easy to understand
Multiple views, same information
Mail/online/spreadsheet/dashboard/diagrams
Comprehensive BI
For the Integrated Enterprise
Enterprise
BI Platform
Performance
Management
Enterprise
BI Platform
Business Performance Management
Issue
Solution
Must align all actions with
strategic business objectives
and provide immediate
insight
Provide a Web-based scorecard
solution with integrated business data,
customized by user role
Scorecard technology usually
has limited functionality and
interactivity
Implement a solution that
encompasses the entire scorecard cycle
with interactive metrics
Most solutions require significant
development and provide little
flexibility
Use standards based, familiar
technology that can be easily
changed as your business grows
Office PerformancePoint
Server 2007
What happened?
Report
Enterprise
BI
Platform
What will happen?
Forecast
Single
Data Model
What is happening?
Scorecard
Why?
Analyze
What do I want to happen?
Plan
Office PerformancePoint
Server 2007
Articulate
Goals
Monitor
Metrics
Define strategy
Adaptable to
scorecard
methodology
Monitor KPI’s
Personalized
scorecards
Business Scorecard Manager
Business modeling & Forecasting
Analyze
Issues
Drill down and
context
Unstructured data
in context
ProClarity analytics
Enterprise
BI
Platform
Collaborate
and Act
Share and
communicate
strategy
Enterprise Reporting
Enterprise
BI Platform
Enterprise Reporting
Issue
Solution
Reports are in-flexible, not
available when and where
needed, and difficult to interpret
Implement reporting solution that
delivers reports anytime, anywhere,
in the format you require
Reports take too long to get
and are often out-of-date,
limiting their usefulness
Get real-time, refreshable reports
without having to rely on IT to run
them every time
Users require flexibility in
report format and layout
Implement a single, integrated
enterprise solution for the entire
reporting cycle
Office SharePoint Server 2007
Server-based spreadsheets ,
BI portal, reporting portal
and repository
Server-based forms
and workflow with
smart client and
browser interfaces
Business
Intelligence
Business
Processes
Windows
SharePoint
Services
Content
Management
Integrated document, records
and Web content
management
Collaboration
Enterprise
BI
Platform
Next generation e-mail,
project management,
workflow, blog and
wiki support
Portal
Enhanced SharePoint Portal
aggregation and
personalization
Search
Great relevance
with rich people and
business data search
Enterprise
BI
Platform
• Scalable Server
– Rich, Enterprise Reporting Platform (static and
interactive)
– Multiple data sources with multiple delivery
options
– Scalable, manageable and embeddable Web
Services architecture
– Scheduling, Snapshots, Caching, more…
• Advanced Authoring Tools
• End-user, Ad Hoc Reporting
• Strong Management Story
–
–
–
–
SOAP Web Service APIs
Report Manager portal
Extensible security model
Integration with AS, IS, management tools
Powerful Analytics
Enterprise
BI Platform
Analyzing Your Business
Issue
Solution
People need access to accurate
data and analysis to make day-today business decisions
Support decision making across
entire enterprise at every level:
strategic, tactical, operational
Business data is not easily
accessible and is often “lost” in
line of business applications
Implement a real-time analytical engine
and embed BI into critical business
processes
Always viewing business information
in hindsight, with little ability to
forecast future activity
Deliver one version of the
truth with advanced analytics including
powerful data
mining tools
Enterprise
BI
Platform
• Single version of the truth
– Key Performance Indicators
• Unified Dimensional Model
• Pro-active caching – real-time BI
• Data Mining in the platform
• Integrated Developer Tools
• Failover Clustering
Corporate Data
Warehouse
Enterprise
BI Platform
Corporate Data Warehouse
Issue
Solution
Difficulty accessing data from
diverse sources
Easy data connectivity from multiple
formats, platforms and devices
Costly and complex data
integration
Fast, semi-automated data
integration from data extraction
to loading
Poor data quality, recovery and
scalability
Proven performance and scalability
for large scale DW implementations
Fast, scalable warehouse capabilities
Enterprise
BI
Platform
• Scalability & Performance
• Data table & index partitioning
• Multi TB Data warehouse
• High availability
• Db mirroring
• Clustering
• Online index operations
• Security
• Manageability
• Extensibility
Enterprise
BI
Platform
• Enterprise ETL platform
– High performance
– High scale
– More trustworthy and reliable
• Best in class usability
– Rich development environment
– Source control
– Visual debugging of control
flow and data
– Great range of transforms
out-of-the-box
• Highly extensible
–
–
–
–
Custom tasks
Custom enumerations
Custom transformations
Custom data sources