Updated: July 11, 2020 (November 7, 2011)

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 will deliver 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, called authors, to create and share Excel workbooks for analyzing large data sets to look for patterns, track business metrics, or perform other business intelligence (BI) tasks. This new version of PowerPivot builds on the earlier version and adds tools to make creation, easier sharing, and reporting possible. The new version also underlies the new Power View functionality included in SQL Server 2012 intended to make the information within PowerPivot workbooks more approachable to all users.

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