Microsoft Office Tutorials and References
In Depth Information
Figure 5-42. Data connection authentication error
So far, you’ve seen how to consume data from data sources small and large in Excel and how to publish Excel
workbooks to SharePoint. However, an even bigger question is whether Excel is capable of doing complex calculations
and processing lots of information in a short time. You’ll see how some of these challenges can be addressed in the
next section.
PowerPivot for Excel
As it becomes increasingly important to support large amounts of data, the need for additional infrastructure that can
support Excel also becomes significant. The PowerPivot feature of Excel 2013 helps support such requirements. Here’s
a summary of PowerPivot features and capabilities:
Handle larger data sets
Process large amounts of data much more quickly
Access various data sources, including databases, feeds, text files, reporting services, and so on
Rich-client interface running over the PowerPivot engine
Integrate with existing Excel features such as Slicers, PivotCharts, and Tables
Excellent BI and data-management capabilities, such as the PowerPivot Management
Dashboard
Run analytics on data and calculations faster; uses powerful capabilities such as Data Analysis
Expressions (DAX). (To learn more about DAX, go to
http://technet.microsoft.com/en-us/library/ee835613.aspx . )
Enhanced security
The major components involved are the Excel 2013 client and PowerPivot for SharePoint. In earlier versions of
Excel, PowerPivot was available as an add-in. But in Excel 2013, PowerPivot is built into Excel. There’s no need to
install the additional PowerPivot Add-In if you are using Excel 2013. Excel workbooks with PowerPivot data can be
published to SharePoint Server 2013 with Excel Services.
 
 
Search JabSto ::




Custom Search