Database Reference
In-Depth Information
PowerPivot
It is important to understand what PowerPivot is and how it relates to Power View.
PowerPivot is a data analysis add-on for Microsoft Excel. With it, you can mash
large amounts of data together that you can then analyze and aggregate all in one
workbook, bypassing the Excel maximum worksheet size of one million rows. It uses
a powerful data engine to analyze and query large volumes of data very quickly.
There are many data sources that you can use to import data into PowerPivot. Once
the data is imported, it becomes part of a data model, which is simply a collection
of tables that have relationships between them. Since the data is in Excel, it is
immediately available to PivotTables, PivotCharts, and Power View.
PowerPivot is implemented in an application window separate from Excel that
gives you the ability to do such things as insert and delete columns, format text,
hide columns from client tools, change column names, and add images. Once
you complete your changes, you have the option of uploading (publishing) the
PowerPivot workbook to a PowerPivot Gallery or document library (on a BI site) in
SharePoint (a PowerPivot Gallery is a special type of SharePoint document library
that provides document and preview management for published Excel workbooks
that contain PowerPivot data). This will allow you to share the data model inside
PowerPivot with others. To publish your PowerPivot workbook to SharePoint,
perform the following steps:
1. Open the Excel file that contains the PowerPivot workbook.
2.
Select the
File
tab on the ribbon.
3.
If using Excel 2013, click on
Save As
and then click on
Browse
and enter the
SharePoint location of the PowerPivot Gallery (see the next screenshot).
If using Excel 2010, click on
Save & Send
, click on
Save to SharePoint
,
and then click on
Browse
.
4.
Click on
Save
and the file will then be uploaded to SharePoint and
immediately be made available to others.
