Powerpivot Add in

Last Post 27 May 2010 06:58 AM by keithbu. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Dave Larkin
New Member
New Member

--
21 May 2010 06:33 AM

How does powerpivot connected into the MS BI story? How valuable is sharepoint in the overall story?
How can you best look to deploy in an SME?

Cheers

Dave

Andrew Fryer
New Member
New Member

--
27 May 2010 04:37 AM
PowerPivot is a tactical solution designed for teams and departments to develop their own ad hoc analysis of diverse data from multiple sources.  The existing BI stack from Microsoftis IT driven and enterprise wide, and supports the strategic goals of an organisation.  

Sharepoint is used to deliver a personalised experience to each memeber of the organisation and to allow your users to collaborate.  Nowhere is this as important as in decision making.  So you deploy your PowerPivot tot SharePoint to share it with the rest of the team.  Once a PowerPivot is saved in SharePoint it can be used as a source in the same way as a cube e.g. you can build reporting services reports, performance point dashboard and analytic reports based on it as well as being able to slice it direclty fromthe PowerPivot gallery. Tow other key part of this are the ability to refressh the source data in a PowerPivot on a scheduled basis, and to be able to see usage and performance of the PowerPivots from the management dashboard in SharePoint Administration.

Is it an SME solution? yes absolutley as you can get started with some basic trianig and without all the heavy IT wokr ned to build a traditional BI solution. The license costs might seem high but should be offset against reduced service costs, and enoirmous flexibility and agility.

I Hope this helps, if you need to discuss further please contact me via my blog (http://blogs.technet.com/b/andrew)
Andrew

keithbu
New Member
New Member

--
27 May 2010 06:58 AM
To add to Andrew's reply.

With Excel 2010 and Powerpivot you can load vast quantities of data into Excel and create pages containing charts and pivot tables from the data.

However without SharePoint 2010 you still have a few potential issues eg:
1) You will have multiple copies of the Excel sheet being handed around the organisation.
2) You will have to manually refresh the data instead of having being able to define a data refresh schedule in SharePoint which move the data from the source server based datastores to the server based powerpivot store.
3) All the consumers of the data will view the data through a web browser and therefore don't necessarily have to have Excel 2010 installed.
4) You can monitor useage and performance of the powerpivot sores using the management dashboard.

Remember you also require a SQL Server 2008 R2 Enterprise Edition installation for the SharePoint 2010 backend to work with powerpivot.
You are not authorized to post a reply.

Acceptable Use Policy