What Is SQL Server PowerPivot?

Archived Published: 09 July 2010 ID: G00200975


Not a Gartner Client?

Want more research like this?
Learn the benefits of becoming a Gartner client.

contact us online


Microsoft SQL Server PowerPivot enables users to combine and visually analyze large amounts of data in Excel, and to manage it in SharePoint. While some Excel challenges remain, it strengthens Microsoft's ad hoc analysis capabilities and its position against innovative data discovery vendors.

Table of Contents

  • Analysis
    • 1.0 What Is SQL Server PowerPivot (Formerly Gemini)?
    • 2.0 Is SQL Server PowerPivot for Excel the Primary Front End to SQL Server Analysis Services?
    • 3.0 How Are SQL Server Analysis Services Authoring and Administration Capabilities Used by SQL Server PowerPivot?
    • 4.0 How Does PowerPivot Differ From the Native Analysis Services Mode?
    • 5.0 Why Did Microsoft Develop PowerPivot and How Does the Introduction Affect the BI Market?
      • 5.1 SQL Server PowerPivot Is Central to Microsoft's BI Strategy
      • 5.2 SQL Server PowerPivot Addresses a Key Limitation in Microsoft's BI Portfolio
      • 5.3 SQL Server PowerPivot Enables Microsoft to Address a Key Competitive Requirement for Easier-to-Use Tools
      • 5.4 When Will It Be Available?
      • 5.5 What Are the Product Requirements and the Pricing Model?
      • 5.6 What Are the Big Limitations in the First Release That Will Be Addressed in Subsequent Releases?
      • 5.7 What Does This Mean for BI Program Managers?
      • 5.8 What Does This Mean for BI Users?
  • Recommended Reading
© 2010 Gartner, Inc. and/or its Affiliates. All Rights Reserved. Reproduction and distribution of this publication in any form without prior written permission is forbidden. The information contained herein has been obtained from sources believed to be reliable. Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartners research may discuss legal issues related to the information technology business, Gartner does not provide legal advice or services and its research should not be construed or used as such. Gartner shall have no liability for errors, omissions or inadequacies in the information contained herein or for interpretations thereof. The opinions expressed herein are subject to change without notice.

Free Research

Discover what 12,000 CIOs and Senior IT leaders already know.

Free Access

Why Gartner

Gartner delivers the technology-related insight you need to make the right decisions, every day.

Find out more