1 / 22

How to set up Reporting Services and PowerPivot in SharePoint 2010

How to set up Reporting Services and PowerPivot in SharePoint 2010. Environment Permalink - http://go.cloudshare.com/JPW.html Please log in now Service Passwords – P@ssword1. Who Am I?. SharePoint Server MVP SQL Server v-TS CTO/Co-Founder of UnlimitedViz http://www.unlimitedviz.com

africa
Download Presentation

How to set up Reporting Services and PowerPivot in SharePoint 2010

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. How to set up Reporting Services and PowerPivot in SharePoint 2010 Environment Permalink - http://go.cloudshare.com/JPW.html Please log in now Service Passwords – P@ssword1

  2. Who Am I? • SharePoint Server MVP • SQL Server v-TS • CTO/Co-Founder of UnlimitedViz • http://www.unlimitedviz.com • SharePoint Focus – BI, Forms and Workflow • +20 Years in IT Field • http://whitepages.unlimitedviz.com • @diverdown1964 • about.me/diverdown

  3. Agenda • Installation • Configuration • Deployment • Troubleshooting • Changes coming in 2013

  4. Start - SharePoint 2 Server Farm

  5. Integration – The Wrong Way

  6. Architecture

  7. PowerPivot Installation

  8. SSRS SharePoint Mode Installation

  9. Hands On Walkthrough

  10. Excel 2013 Now has PP model “baked in” Excel Services supports interactivity via “Analysis Services SharePoint Mode” PowerPivot for SharePoint still needed for auto data refresh Changes In 2013

  11. Resources • MSDN Configuration Guide • http://msdn.microsoft.com/en-us/library/ee210616.aspx • ULS Log Viewer • http://archive.msdn.microsoft.com/ULSViewer • The Health Analyzer and PowerPivot for SharePoint • http://whitepages.unlimitedviz.com/2012/06/the-health-analyzer-and-powerpivot-for-sharepoint/ • Installing and/or Upgrading a Multi-Server SQL Server Reporting Services 2012 SharePoint Mode Farm • http://whitepages.unlimitedviz.com/2012/09/scaling-out-andor-upgrading-to-sql-server-reporting-services-2012-in-sharepoint-mode

More Related