Importing PowerPivot data


show more Importing PowerPivot data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Importing PowerPivot data

PowerPivot helps you analyze large datasets efficiently but you do have to import data into PowerPivot to get started. In this movie I will show you how to bring data from an Excel workbook into PowerPivot. First thing you do is click the PowerPivot tab on the Ribbon and then in the Launch group click the PowerPivot Window button. Then inside of PowerPivot on the Home tab click the Ctrl that will let you get the data from the type of source that you want, and you have many different sources available. For example you can get your data from a database, SQL Server, Access, Analysis Services, or even another PowerPivot workbook.

You can also get your data from a report, and that would be something like a Microsoft SQL Server Reporting Services report. You can also download data from the Azure DataMarket, from RSS data feeds, from text files, or in this case we're going to use Other Text Sources because at the bottom of this list you'll find Microsoft Excel and that is the type of fi...

Importing PowerPivot data
Video duration: 3m 14s 3h 43m Intermediate

Viewers:

Importing PowerPivot data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

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