Transcript Business Intelligence Features in SharePoint 2010

Name
Title
Company
Microsoft SharePoint 2010
The business collaboration platform for the Enterprise and the Web
Tool
Excel 2010
Excel Services
Scenario
End-user data creation, manipulation, and
analysis
Share with large number of users; protect
IP, offload processing
PerformancePoint Dashboards, scorecards, and key
Services
performance indicators (KPIs)
Work with large, heterogeneous data
ECS & PowerPivot
sources directly in Excel
SQL Reporting
Services
Create & Process Custom Reports
Visio Services
Building a visual representation of
business structures that are bound to
data.
5
Thin Rendering
in Browser
View and
Interact
Author and Publish
Spreadsheets
Open Spreadsheet
or Snapshot
Excel 2007
Client
Microsoft Office
Excel 2007
Web Services
Access
Custom
Applications
Authoring
Exploration and Consumption
Thin rendering
View, Interact,
Create, Edit
Author and Publish
Spreadsheets
Excel
in browser
Download a Copy or
Snapshot, Open for editing
Excel
Web Services,
REST API,
JavaScript OM
Custom
applications
Authoring
Exploration and Consumption
Excel Web
Access
Excel Web
Services
REST API
JSOM
Excel Proxy
User-Defined
Functions
External Data Sources
Excel Calculation Service
SharePoint Content Database
XLSX / b / m
20
PowerPivot component
Purpose
Queries and manages
PowerPivot System Service
PowerPivot data in Excel
and Analysis Services service
workbooks
Intercepts and directs HTTP
PowerPivot Web service
requests to PowerPivot
servers in the farm
Location
Service Application
Windows Service
Web Front End Server(s)
PowerPivot service
application
A configured instance of a
PowerPivot System Service
Application Server(s)
PowerPivot application
database
PowerPivot Service
Application configuration
Farm Database Server(s)
PowerPivot Workbooks
SharePoint Content
Databases
*Plan for scale*
PowerPivot content and
libraries
SSRS 2008 R2 Add-in
SharePoint 2010 WFE
SSRS 2008 R2
Reporting Services Add-in
Report Server in SharePoint Mode
(SSRS 2005 SP2, 2008, 2008 R2)
Report
Report
Viewer web management
part
UI
SSRS
Proxy
SharePoint Object Model
Security
Extension
Data
Management
SharePoint Object Model
SharePoint Config & Content Databases
SSRS Report Database
Share Diagrams in SharePoint
• Visualize business intelligence with Visio diagrams
• Diagrams can be viewed without having Visio client installed
• Full Fidelity rendering with Silverlight, or PNG
Connect Diagrams to Data
• Use data graphics to build front ends for real-time business
intelligence solutions
• Diagrams can be connected to various Data sources
Build Dashboards
• Use Web Part Connections to integrate with other SharePoint Web
parts
• Use the Mashup API to fully customize dashboards and manipulate
data
Location of
Search Term
Find Similar
Reports
Report
Preview
http://<SSRServer>/ReportServer
SharePoint
Crawler
FAST
Server
BI IFilter
SharePoint
WFE
Office IFilter
IFilter interface
Unmanaged binary
BI Search Manager
Communication using
Socket
Filters
BI Filters
Processo
Prers
Processors
Original Office IFilter
dll appended with
detailed information
Managed Windows
Service hosting filter
Managed Service
Data Sources used
by Excel Pivot
tables or Report
Services reports
http://technet.microsoft.com/en-us/library/ff394320(office.14).aspx
http://technet.microsoft.com/en-us/library/ee424405(office.14).aspx
http://technet.microsoft.com/en-us/library/ee855124(office.14).aspx
http://technet.microsoft.com/en-us/library/ee210682(SQL.105).aspx
http://technet.microsoft.com/en-us/library/ee681486(office.14).aspx
http://technet.microsoft.com/en-us/library/ee210649(SQL.105).aspx
http://technet.microsoft.com/en-us/library/ee663482(office.14).aspx