How to Add Tables to a PowerPivot Model in Excel 2010


show more Adding tables to a PowerPivot model 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 ...

Adding tables to a PowerPivot model

PowerPivot lets you manipulate large datasets efficiently, but you should only import the tables you need. Importing unnecessary data can slow performance and make it harder for you to find the data you want. If you discover that you didn't import a table you actually need, you can add that table to your data model in a few steps. So to start out I'll open PowerPivot and to do that I'll click the PowerPivot tab on the Ribbon and then click the PowerPivot Window button. Now to bring my new data into PowerPivot I will need to import it and in this case the data that I want to bring in is in an Access database, so I will click the From Database button on the Home tab of the PowerPivot Window and then click From Access.

The Table Import Wizard dialog box appears and I can click Browse and then the data that I want is in the MonthTable database. so I'll double-click it and when I do the database name and full path appear appear in the database name field. If this database were pa...

Adding tables to a PowerPivot model
Video duration: 2m 27s 3h 43m Intermediate

Viewers:

Adding tables to a PowerPivot model 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 ...