Microsoft Office Tutorials and References
In Depth Information
Filtering data with a search filter
Analyzing data by using PowerPivot
As data collections increase in size, the need to analyze
hundreds of thousands or even millions of rows of data grows.
Starting in Excel 2007, individual Excel worksheets could store
1,048,576 rows of data. This increased capacity came at a
price—worksheets that stored large data collections
calculated more slowly, as did PivotTables and other workbook
elements based on the large data set.
As of this writing, PowerPivot is available only for users who
have installed Office 2013 Professional Plus, SharePoint 2013
Enterprise Edition, SharePoint Online 2013 Plan 2, and the E3
or E4 editions of Office 365. It is possible that Microsoft will
subsequently make both PowerPivot and the related add-in
Power View available to all users, as was the case in Excel
2010.
When Microsoft released Excel 2010, the programming team
also released PowerPivot. PowerPivot was made available
as an add-in for Excel 2010, but its basic functions have
been incorporated into Excel 2013. Using PowerPivot, you
can manage data collections that contain many millions of
rows without spreading the data across multiple worksheets.
Calculations and summaries run quickly regardless of the size
of your data collection, you can define relationships among
multiple tables to combine the data in meaningful ways, and
Excel 2013 greatly compresses the data to reduce the overall
size of your workbook file.
You can extend the functionality of PowerPivot in Excel 2013
by installing the PowerPivot add-in. Installing the add-in lets
you filter data while you import it, rename tables and
columns during import, define relationships among tables, and
define Key Performance Indicators for business intelligence
applications.
A full discussion of PowerPivot is beyond the scope of this
book, but you can find much more information by visiting
www.powerpivot.com .
Search JabSto ::




Custom Search