1 / 23

Visualise you data with PowerPivot and PivotViewer in SharePoint 2010

Visualise you data with PowerPivot and PivotViewer in SharePoint 2010. Roger Noble BI Consultant. Who am I?. Roger Noble BI Consultant with LobsterPot Solutions specialising in SQL Server and SharePoint Certifications MCITP: SQL Server BI 2008

emily
Download Presentation

Visualise you data with PowerPivot and PivotViewer 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. Visualise you data with PowerPivot and PivotViewer in SharePoint 2010 Roger Noble BI Consultant

  2. Who am I? • Roger Noble • BI Consultant with LobsterPot Solutions specialising in SQL Server and SharePoint • Certifications • MCITP: SQL Server BI 2008 • MCTS: SharePoint Configuration and Development 2007 • MCPD: Web Developer • Web: www.rogernoble.com • Twitter: @Roger_Noble

  3. Overview • PivotViewer • PowerPivot • What does this have to do with SharePoint? • Installation overview • Solution Architechture • Creating a Pivot collection • Conclusion

  4. What is PivotViewer? • Interact with massive amounts* of data • Very visual • Able to get hands on with your data • * definitions of massive may vary

  5. Demo: PivotViewer

  6. What is PowerPivot? • Extension for Excel • Self service BI platform • Able to analyse and manipulate millions of records • Basis for next version of Analysis Services

  7. Demo: PowerPivot

  8. What does this have to do with SharePoint? • Solution is composed of 4 parts • PowerPivot • Reporting Services • SharePoint 2010 • PivotViewerfeature – web parts and list

  9. PowerPivot for SharePoint • Analysis Services integration with SharePoint • Data feed library and PowerPivot gallery

  10. Demo: PowerPivot for SharePoint

  11. Demo: Reporting Services for SharePoint

  12. Demo: PivotViewer for SSRS • PowerPivot • Reports • PivotViewer solution • Web Parts • List

  13. Solution Architecture

  14. Installation: Prerequistes • Requires SharePoint 2010 Enterprise Edition • Excel Services must be enabled • Must have been installed as a server farm – not stand alone

  15. Installation: PowerPivot for SharePoint • Either in a new or existing farm (requires SQL Server 2008 R2) • Run SQL Server 2008 R2 install and select SQL Server PowerPivot for SharePoint • PowerPivot is managed in Central Admin

  16. Installation: PivotViewer • Install PivotViewer solution and activate feature • Installs 2 web parts • BI Report Crawler • BI Data • Installs a list called BI Collection Administration

  17. Creating a Pivot collection: PowerPivot • Import data in to PowerPivot

  18. Creating a Pivot collection: Report Builder • Create a parameterised report • Only one parameter supported 

  19. Pivot collection schema • Collections are made up of Items • Items are made up of Facets

  20. Creating a Pivot collection: Wiring it up • Create a new list item • Specify MDX query – SSMS can help

  21. Conclusion • PivotViewer is a highly interactive way to explore your data

  22. Links PivotViewer for SSRS CTP2 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=796AFF73-37FC-4AC2-9595-2C9AA72EB278 PowerPivot http://www.powerpivot.com/ Install PowerPivot into an existing SharePoint 2010 farm http://msdn.microsoft.com/en-us/library/ee210616.aspx Install PivotViewer (via CristianPetculescu BI principal architect) http://petcu40.blogspot.com/2010/07/pivotviewer-extension-for-reporting.html LobsterPot Solutions example Pivot collections http://pivot.lobsterpot.com.au/

  23. Questions

More Related