PowerPivot Strengthens Analytics in Excel, SharePoint 2010

Wes Miller analyzes and writes about Microsoft’s security, identity management, and systems management technologies. Before joining Directions on Microsoft, Wes... more

SQL Server 2012 delivers a more powerful and flexible version of the PowerPivot for Excel 2010 add-in and PowerPivot for SharePoint Server 2010 add-in. Like its predecessors available since May 2010, PowerPivot enables expert users to create and process large data sets (called models) embedded in Excel workbooks to analyze the data to look for patterns, track business metrics, or perform other BI tasks. This new version of PowerPivot adds functionality to make model creation and sharing easier. The new version also underlies the new Power View functionality included in SQL Server 2012, which is intended to make the information within PowerPivot workbooks more approachable to all users. (See the chapter “Power View Delivers Self-Service Data Visualizations“.)

PowerPivot Delivers Approachable Business Intelligence

PowerPivot is a database engine that enables users to create and process large data sets (called models) embedded in Excel files (workbooks). PowerPivot models are intended to provide efficient analysis of large data sets at multiple levels of detail.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now