1 / 28

SharePoint 2010 Insights

SharePoint 2010 Insights. SharePoint 2010 Insights Overview. Challenges. Business Challenges. SharePoint 2010 Insights Features. SharePoint 2010 Solutions. Excel Services – New Features. Improved Usability Multi-user Collaboration Delegate Services Permissions Slicer feature Sparklines

shaman
Download Presentation

SharePoint 2010 Insights

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SharePoint 2010 Insights

  2. SharePoint 2010 Insights Overview

  3. Challenges

  4. Business Challenges

  5. SharePoint 2010 Insights Features

  6. SharePoint 2010 Solutions

  7. Excel Services – New Features • Improved Usability • Multi-user Collaboration • Delegate Services Permissions • Slicer feature • Sparklines • Fidelity across multiple browsers • Improved Management • Unattended Service Account • Manage Service Applications • Trusted Locations • Windows PowerShell

  8. Collaborating In Real Time • Edit Web Spreadsheets (Excel Workbooks) in the Browser • Multiple users can edit, values will sync across user sessions

  9. PowerPivot Add-in with Excel

  10. PerformancePoint Services • Dashboards • Scorecards • Report Views • Filters • Rich Analytic Visualizations • Data Sources • Chart Web Part

  11. Dashboards • Deployed to SharePoint • Filters • Scorecards • Report Views

  12. Scorecards • KPIs • Created from multiple data sources • KPI weighting • KPI scoring • Annotation capabilities • Calculate KPI builder • Multiple attributes and targets • Variance calculations • Scorecards • Dynamic • Navigation (OLAP) • Balanced

  13. Analytic Reports • Full analytic navigation • Drill down/up • Expand/collapse • Cross drill • Filtering/Sorting • Analyze in decomposition tree

  14. Visio Services • Rendering • Browser-agnostic • Full Fidelity rendering using • Down-level experience in PNG • Visual Refresh of Data Diagrams • Refresh diagrams connected to: • Automatic refresh SQL Excel SP Lists OLEDB ODBC Custom ODC

  15. Visio Services Features • SharePoint Integration • Visio Web Access web part • JavaScript Mash-up API • Supports web part connections • Administration • Visio Services is a Shared Service • Customizable in Central Administration and PowerShell

  16. SQL Server Reporting Services • Report tools • Create • Deploy • Manage • Office UI • Publish reports

  17. SharePoint 2010 BI Center • Center Panel • Dashboard library • Data Connections library • Documents library • PerformancePoint Content list

  18. Architecture

  19. Physical Architecture Client Access Authoring Farm Browser PowerPoint 2007 & 2010 Excel 2007 & 2010 WFE SharePoint 2010 Insights Services SQL Server Reporting Services Visio Services Excel Services Publishing Functions AppSrv DbSrv SQL Excel SP Lists OLEDB ODBC Custom Data Sources

  20. Planning

  21. Hardware and Software Platforms • 64-bit Servers • Enabling 2010 features will require more power! • Dedicate SQL power to Logging DB and Web Analytics • Recommended Hardware Requirements: • WFE and Apps Servers - Dual processor, 8 GB RAM • SQL Server - Quad Core, 16 GB RAM • Recommended Software Requirements • Client – IE7 (IE8 preferred) / Fire Fox 3.5/ Safari for Mac browsers • 64-bit Windows Server 2008 (or 2008 R2) • 64-bit SQL Server 2008 R2, 64-bit SQL Server 2008 or 64-bit SQL

  22. Insights Tools Planning Visio & Visio Services Excel and PowerPivot Excel Services PerformancePoint Services Report Builder Reporting Services

  23. Excel Services 2007 Architecture • Tiers • Web Front End • Application Server • Configurations • Simple - Single Server • Complex – Multiple Servers • Security Provided by SharePoint • Performance and Scalability • Optimized for Multi-User Access • Caching at Multiple Levels • Allow/Disallow Data Refresh • Settings to Limit Workbook Size or Request Duration

  24. Web Front End Excel Web Access (EWA) Web Part Excel Web Services ECS Proxy Application Server ECS Interface Excel Calculation Server (ECS) Excel Services 2007 Architecture • Web Front-End • SharePoint UI • HTML Rendering and Web Services • Application Server • Loads Spreadsheets, Refreshes Data, Performs Calculations • Maintains State for Interactivity • File & Query Caches for Performance • The Office Servers Provide • Solution Platform • Store: Spreadsheets, Connection Files • Management: Settings, UI, Scripting • Security: Authentication, Authorization External Data Sources

  25. PerformancePoint Services Architecture • Shared Services and Deployment • WFE (Web Front End) and Application Server • PerformancePoint Web Services • Content Storage • SharePoint Hierarchy - Web Applications, Site collections and Sites • Content storage in Lists & Document Libraries • PerformancePoint Content Types • Security Model • Trusted Locations • Secure Store

  26. Architecture Walkthrough 2. Upload it to SharePoint 4. Visio Services refreshes data and diagram PNG/ XAML VDW VDW Visio Services Consumer 3. Consumer requests diagram Creator 5. Diagram rendered in browser 1. Create data connected diagram in Visio Data Source

  27. Visio Services Usage • When should you select Visio Services? • Integration Options • Visio Web Access web part • Web Part Connections • Visio JavaScript Mash-up API

  28. Reporting Services Deployment • Reporting Services deployment • Native mode • SharePoint Integrated mode • Native mode with Web Parts • Addressing

More Related