Analyzing data from multiple sources using the PowerPivot plug-in


show more Analyzing data from multiple sources using the PowerPivot plug-in provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features show less
please wait ...

Analyzing data from multiple sources using the PowerPivot plug-in

In this movie, I want to show you the new PowerPivot plug-in. Say that three times fast. PowerPivot was originally called Project Gemini, and you might have heard that name bantered about a little bit. This is a free plug-in from Microsoft, and you could get it at PowerPivot.com and what it does is it puts PivotTables kind of on steroids. You can query Excel sheets, databases, and many other sources all at the same time. And this generally falls under the category of business intelligence, and let's talk about some of the main advantages over regular PivotTables.

PowerPivot has the ability to handle millions and millions of rows of data. You may know that Excel 2007, and now 2010 will give you about a million and change rows. But using PowerPivot, you can query tens of millions of rows from a database that you are looking at. You could import data from many different types of databases. We will look at that as we go. You can import data from web sites, text files, just about anything...

Analyzing data from multiple sources using the PowerPivot plug-in
Video duration: 12m 23s 1h 51m Appropriate for all

Viewers:

Analyzing data from multiple sources using the PowerPivot plug-in provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features

Subject:
Business
Software:
Excel
Author:
please wait ...