visualise you data with powerpivot and pivotviewer in sharepoint 2010 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Visualise you data with PowerPivot and PivotViewer in SharePoint 2010 PowerPoint Presentation
Download Presentation
Visualise you data with PowerPivot and PivotViewer in SharePoint 2010

Loading in 2 Seconds...

play fullscreen
1 / 23

Visualise you data with PowerPivot and PivotViewer in SharePoint 2010 - PowerPoint PPT Presentation


  • 301 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Visualise you data with PowerPivot and PivotViewer in SharePoint 2010' - emily


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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
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
overview
Overview
  • PivotViewer
  • PowerPivot
  • What does this have to do with SharePoint?
  • Installation overview
  • Solution Architechture
  • Creating a Pivot collection
  • Conclusion
what is pivotviewer
What is PivotViewer?
  • Interact with massive amounts* of data
  • Very visual
  • Able to get hands on with your data
  • * definitions of massive may vary
what is powerpivot
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
what does this have to do with sharepoint
What does this have to do with SharePoint?
  • Solution is composed of 4 parts
    • PowerPivot
    • Reporting Services
    • SharePoint 2010
    • PivotViewerfeature – web parts and list
powerpivot for sharepoint
PowerPivot for SharePoint
  • Analysis Services integration with SharePoint
  • Data feed library and PowerPivot gallery
demo pivotviewer for ssrs
Demo: PivotViewer for SSRS
  • PowerPivot
  • Reports
  • PivotViewer solution
    • Web Parts
    • List
installation prerequistes
Installation: Prerequistes
  • Requires SharePoint 2010 Enterprise Edition
    • Excel Services must be enabled
    • Must have been installed as a server farm – not stand alone
installation powerpivot for sharepoint
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
installation pivotviewer
Installation: PivotViewer
  • Install PivotViewer solution and activate feature
  • Installs 2 web parts
    • BI Report Crawler
    • BI Data
  • Installs a list called BI Collection Administration
creating a pivot collection powerpivot
Creating a Pivot collection: PowerPivot
  • Import data in to PowerPivot
creating a pivot collection report builder
Creating a Pivot collection: Report Builder
  • Create a parameterised report
    • Only one parameter supported 
pivot collection schema
Pivot collection schema
  • Collections are made up of Items
  • Items are made up of Facets
creating a pivot collection wiring it up
Creating a Pivot collection: Wiring it up
  • Create a new list item
  • Specify MDX query – SSMS can help
conclusion
Conclusion
  • PivotViewer is a highly interactive way to explore your data
links
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/