O'Reilly logo

PowerPivot for the Data Analyst: Microsoft by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4. Getting Your Data into PowerPivot

There are a number of ways to get your data into PowerPivot:

• You can link to Excel data that has been converted to a table.

• You can copy and paste Excel data into PowerPivot. Later you can paste append to an existing table.

• You can import from a database such as Access or SQL Server.

• You can import from any SharePoint report that has an Atom symbol in the header.

• You can import from many Atom data feeds. Many Internet databases have Atom feeds, and Atom is a new way to publish data from SQL Server, so there will be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required