PowerPivot for Excel, Microsoft’s business intelligence tool, manages large amounts of data and organizes it into a more manageable format.
In this video, Senior SharePoint evangelist for Allin Consulting, Richard Harbridge describes SharePoint 2010’s importance for companies that use the BI tool and how to manage PowerPivot data using SharePoint 2010’s dashboard.
Read the full transcript from this video below:
SharePoint 2010 lends a hand to Microsoft PowerPivot
Richard Harbridge: It's really more of an interface for it. I would say
in most scenarios with business intelligence, it's your dash boarding
mechanism, right? It's where people come to a location; it's
targeted, audience targeting, all those typical scenarios why
you'd want to use a dashboard. SharePoint does that well. I
think SharePoint is a phenomenal dashboard. I think it's a great
at servicing reports. It's great at surfacing different data, especially
now with of the performance-point integration and the web parts,
and stuff like that.
From a PowerPivot perspective, I sort of see that more on the
Excel side, to be honest. So, you talked about for the masses:
Excel already... I would say most organizations, if you started to
ask them what they're business intelligence is, and how they make
those judgments, it's from Guys' Excel documents. Maybe, they
have a lot of material in there, or maybe it's massaged and
massaged until it finally gets up to the level where decisions are
made on that information.
The advantage of PowerPivot is just, it takes that Excel and all these
technical things that are challenges around that size of data where it
just doesn't make sense -- where the size of the file gets too big, and
so on and so forth -- and it really is a database on the back end,
and basically, you have this Excel-like interface for database and
database management, and so it makes this sort of entry level very easy.
People who can use Excel very well will love PowerPivot because now
you're dealing with copious amounts of data, and having fun with that.
When it comes into SharePoint, all you're really doing is you're surfacing
that into SharePoint. It could be surfaced in Excel still. We might still take
this content, the key parts from this PowerPivot, pop them into an Excel,
and then surface that in an Excel web part in SharePoint, where we can
actually see, using the Excel web services. There's lots of different ways
that it can be used, but that's sort of my best answer.