1 / 78

Data Visualization in SharePoint 2013 Overview

Data Visualization in SharePoint 2013 Overview. Becky Isserman, @ mosslover , http://www.mosslover.com. Who Am I?. MVP 2011 & 2012 MCT MCPD SharePoint 2010 Worked with SharePoint for 9 Years Saint Louis Cardinal’s Fan Harmon.ie Top 25 Influencer. Credits. John Patrick White

shaylee-kinsella
Download Presentation

Data Visualization in SharePoint 2013 Overview

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. Data Visualization in SharePoint 2013 Overview Becky Isserman, @mosslover, http://www.mosslover.com

  2. Who Am I? • MVP 2011 & 2012 • MCT • MCPD SharePoint 2010 • Worked with SharePoint for 9 Years • Saint Louis Cardinal’s Fan • Harmon.ie Top 25 Influencer

  3. Credits • John Patrick White • CTO/Co-Founder of UnlimitedViz • SharePoint Server MVP, • SQL Server vTSP • http://whitepages.unlimitedviz.com • @diverdown1964 • Jason Himmelstein • Senior Technical Director, SharePoint at Atrion • SharePoint Server MVP • Microsoft vTSP • Blog: www.sharepointlonghorn.com • Twitter: @sharepointlhorn

  4. Overview • Framework & What’s New • Requirements, Architecture, Installation • Scaling & Authentication • Features

  5. The Microsoft BI framework Personal BI Team BI Organizational BI Our Context BI Solution created by power user. Context is for a small team & it’s managed on a server. My Context BI solution created by user. Context is only for user & exists as document. The Org’s Context BI Solution created by IT, Established corporate context & is reusable, scalable and backed up.

  6. The Microsoft BI Products Personal BI Team BI Organizational BI Excel Services PowerPivot for SharePoint PerformancePoint Visio Services Reporting Services Add-in KPIs Filter Web Parts Power View SQL Server Analysis Services Integration Services Reporting Services SQL Server Data Tools Excel PowerPivot Power View Visio

  7. Analytics vs. Structured Reporting Questions that we know we have Reports KPIs Dashboards Ad-hoc questions Drill-throughs Analytic charts/grids Pivot Tables/charts Decomposition trees Structured Analytics

  8. SharePoint BI 2010 • Excel Services • Reporting Services SP integrated mode • PowerPivot for SharePoint • PerformancePoint

  9. What’s New in Office/SharePoint BI Analysis Services SharePoint mode PowerPivot for SharePoint not required xVelocity engine in Excel client PowerPivot Power View Per-User Authentication Power View enhancements PerformancePoint Styling

  10. Requirements, Architecture, Installation, and Authentication

  11. Excel Services Family Requirements Excel Services SharePoint Enterprise CAL Included on SP media Deploys as service application Requires AS SP Mode for xVelocity and Power View interactivity Analysis Services SharePoint Mode SQL Server BI or Enterprise SQL Media Deploys as SQL service on independent servers Load balancing performed by Excel Services PowerPivot for SharePoint Requires AS SP Mode and Excel Services SQL Media Deploys as SP Service application Excel Office Pro Plus license xVelocity model enabled as required PowerPivot add-in included, must be enabled PowerView and-in included, enabled as needed

  12. Client Configuration • Enable the PowerPivot Add In • Enable the Power View add in • Turn on the internal model • Use PowerPivot

  13. X-Velocity/PowerPivot Versions Client versions SQL 2008R2 SQL 2012 SQL 2012 SP1 Excel 2013 Server versions PowerPivot for SQL 2008R2 PowerPivot for SQL 2012 Analysis Services SharePoint Mode (2012 SP1)

  14. X-Velocity Compatability Matrix * Can Only Refresh Slicers ** Cannot use SP1 features with Power View *** Limited to pre SP1 PowerPivot feature set

  15. Reporting Services Requirements (IM) SQL Server Standard SQL Server BI or Enterprise Alerting Self service subscriptions Power View Analysis Services Tabular Engine Required for BISM/Power View SharePoint Foundation Deploys as SP service application

  16. PerformancePoint Requirements SharePoint Enterprise Deploys as SP service application SQL Server Analysis Services For analytic charts/grids

  17. Installing SharePoint BI Components Office Excel Services PerformancePoint Other Stuff SQL Server Reporting Services PowerPivot Analysis Services

  18. Bad Farm Overview

  19. Correct Farm Approach

  20. Self Service BI Light Up Story SQL Server Analysis Services Reporting Services Power View PerformancePoint Services Excel Services Visio Services SharePoint 2013 Enterprise Deploy your SharePoint 2013 Enterprise farms and enable shared services, such as Excel Services, Visio Services and PerformancePoint Services. PowerPivot for SharePoint 2013 Reporting Services Power View PerformancePoint Services Excel Services Visio Services SharePoint 2013 Enterprise Native ECS Features 1 Install Analysis Services in SharePoint mode and register the server in Excel Services to enable the core PowerPivot functionality. Core BI Features 2 SQL Server Database Engine Install Reporting Services add-in and Reporting Services in SharePoint-integrated mode to unlock stunning browser-based data exploration, visualization, and presentation experiences. Power View 3 Deploy the PowerPivot for SharePoint 2013 Add-In to provide additional capabilities, such as full access to workbooks as a data source, scheduled data refresh, PowerPivot Gallery, and IT Management Dashboard. All PowerPivot Features 4

  21. Setup & Configuration of Analysis Services SharePoint Mode

  22. Configuration - Analysis Services (SP Mode)

  23. Configuration - Analysis Services (SP Mode)

  24. Configuration - Analysis Services (SP Mode)

  25. Configuration - Analysis Services (SP Mode)

  26. Configuration - Analysis Services (SP Mode)

  27. Configuration - Analysis Services (SP Mode)

  28. Setup & Configuration of PowerPivot for SharePoint

  29. Configuration – PowerPivot for SharePoint

  30. Configuration – PowerPivot for SharePoint

  31. Configuration – PowerPivot for SharePoint

  32. Configuration – PowerPivot for SharePoint

  33. Configuration – PowerPivot for SharePoint

  34. Configuration – PowerPivot for SharePoint

  35. Setup & Configuration Reporting Services in SharePoint Mode

  36. Configuration – SSRS in SharePoint Mode

  37. Configuration – SSRS in SharePoint Mode

  38. Configuration – SSRS in SharePoint Mode

  39. Configuration – SSRS in SharePoint Mode

  40. Configuration – SSRS in SharePoint Mode

  41. Configuration – SSRS in SharePoint Mode

  42. Configuration – SSRS in SharePoint Mode

  43. Configuration – SSRS in SharePoint Mode

  44. Configuration – SSRS in SharePoint Mode

  45. Setup & Configuration PerformancePoint

  46. Configuration – PerformancePoint

  47. Configuration – PerformancePoint

  48. Configuration – PerformancePoint

  49. Configuration – PerformancePoint

  50. Configuration – PerformancePoint

More Related