Document 387609
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
© Copyright 2024