Access "Importing SQL Server data into PowerPivot for Excel"
This article is part of the March 2011, Vol. 5 issue of Top three SQL Server Denali features to watch
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. For more on Microsoft PowerPivot Learn about Microsoft PowerPivot and other connections to SharePoint Find out what’s new with Microsoft PowerPivot 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 ... Access >>>
Premium Content for Free.
Top reasons to get started with SQL Server Denali
by Roman Rehak, Contributor
The upcoming SQL Server Denali is chock-full of new features, such as super-fast column-store indexes and a new Web-based reporting tool. But what does it mean for businesses?
Four tips on boosting SQL Server scalability
by Don Jones, Contributor
SQL Server scalability is high on the list of system properties, and scaling up is easier than scaling out. Follow these four tips and you’ll be on your way to optimum performance.
- Top reasons to get started with SQL Server Denali by Roman Rehak, Contributor
Importing SQL Server data into PowerPivot for Excel
by Robert Sheldon, Contributor
Microsoft PowerPivot is designed to give BI capabilities to users who lack IT’s technical know-how. The first step is importing SQL Server data, and you have to know your options.
- Importing SQL Server data into PowerPivot for Excel by Robert Sheldon, Contributor
More Premium Content Accessible For Free
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...
Microsoft has worked to address the big issue of "big data," as companies are dealing with a constant influx of digital information. SQL Server is no...
Are you going to upgrade to SQL Server 2012? This edition of SQL Server Insider sets out to help you decide whether the investment is worth it or not...