Pro+ Content/SQL Server Insider

Thank you for joining!
Access your Pro+ Content below.
March 2011, Vol. 5

Importing SQL Server data into PowerPivot for Excel

Microsoft PowerPivot for Excel 2010 is a data analysis tool that lets you easily import data from SQL Server and other sources into the Excel environment. Because of PowerPivot’s efficient compression algorithms and in-memory analysis, you can import and manage large quantities of data. In addition, PowerPivot uses the VertiPaq engine, a column-based data storage technology from SQL Server Analysis Services that puts the power of multicore processors and gigabytes of memory at your fingertips. As a result, you can process millions of rows of data in the time it used to take to process thousands. And because you’re working within Excel, you can leverage a familiar, user-friendly collection of tools. This is good news for users who want to incorporate complex relational data from SQL Server into analytical calculations within Excel workbooks, which can be integrated into a SharePoint workflow for collaborations efforts. To use PowerPivot, you must be running Microsoft Office 2010 with the PowerPivot add-in installed; for details ...

Access this Pro+ Content for Free!

By submitting you agree to recieve email from TechTarget and its partners. If you reside outside of the United States you consent to having your personal data transferred and processed in the United States. Privacy Policy

Features in this issue

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

-ADS BY GOOGLE

Close