Ben Robb MVP, SharePoint Server cScape Ltd OFC204 What to expect in this session A short background to why BI is important Useful for talking.

Download Report

Transcript Ben Robb MVP, SharePoint Server cScape Ltd OFC204 What to expect in this session A short background to why BI is important Useful for talking.

Ben Robb
MVP, SharePoint Server
cScape Ltd
OFC204
What to expect in this session
A short background to why BI is important
Useful for talking to the boss...
An overview of SharePoint 2010 investments in
Business Intelligence
This is a Level 200 session
Functional demos
I won’t be doing deep dive technical demos
Using Business Intelligence to…
Business Intelligence in action
SharePoint 2010
The business collaboration platform for the Enterprise and the Web
Microsoft BI Vision
Specialized
BI Tools
BI for
Everyone
Relevant Information is everywhere
Scorecards
Spreadsheets
IM/chat
Newspapers
Meetings
Financial reports
Email
Documents
Portals
Business books
Slide decks
Webcasts
Presentations
RSS feeds
Project plans
Intranet
Blogs
Dashboards
Magazines
Television reports
Internet
Analytic
applications
Charts and graphs
Cause for Optimism
BI Architecture
BI User Experience
BI Middle Tiers
BI Backend Engine
Product line up
Office Investments
SharePoint Designer
Visio
Access
Excel
SharePoint
Chart Web Part
Analytics
Performance Point Services
SQL
Reporting and Analytics
PowerPivot
Architectural Changes in SharePoint
Impact on BI solutions
New service model
Secure store service
Security model changes
PerformancePoint becomes a SharePoint service
Excel and Excel Service investments
Excel
Conditional Formatting
Sparklines
Slicers
Search Filters
Named Sets
Pivot Charts
Excel Services
More workbooks
Client fidelity
Edit
Collaboration
REST
JSOM
Visio and Visio Services
Office Investments
SharePoint BI investments
Chart Control
SharePoint BI investments
Usage Analytics
PerformancePoint in SP2010
Extensive set of features in SharePoint to
compliment BI
Centralized content management
Security
Extensibility and Customization through views
and templates
Scale and performance
Filters
PerformancePoint in SP2010
SharePoint Investments
SQL Server RS
One step integration configuring SSRS
integration via RS add-in
Alternative Access Mapping in server
SharePoint user support in data extensions in
server
Performance improvements
ULS logging
PowerPivot
PowerPivot for Excel (Client)
PowerPivot for SharePoint (Server)
www.powerpivot.com
PowerPivot
Use what you already own
Familiar tools for end users
Self-service access and insight
Data exploration and analysis
Predictive analysis
Rich, contextual data visualization
Integrated content and collab.
Thin client experiences
Scorecards and Dashboards
Collaboration
Search
Sound and scalable platform
Analysis Services
Reporting Services
Integration Services
Master Data Services
Data Warehousing
Resources
www.microsoft.com/teched
www.microsoft.com/learning
Sessions On-Demand & Community
Microsoft Certification & Training Resources
http://microsoft.com/technet
http://microsoft.com/msdn
Resources for IT Professionals
Resources for Developers
Complete an evaluation
on CommNet and enter to
win an Xbox 360 Elite!
© 2009 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.