VTL Consulting

Archrived Webcasts Info

Overview

Microsoft SQL Server PowerPivot for Excel 2010

PowerPivot for Excel 2010 (formerly known as "Gemini") is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. It provides users with the ability to analyze mass quantities of data and IT departments with the capability to monitor and manage how users collaborate by integrating seamlessly with Microsoft SharePoint Server 2010 and Microsoft SQL Server 2008 R2.

You can give your users the power to gain deeper insight into any business aspect and compress decision cycles. You can enable your users to share their findings with others effortlessly and securely. You can increase the efficiency of your IT department through the PowerPivot Management Dashboard.

What’s New in BI

(Click to Expand)

PowerPivot technology redefines how IT departments deliver and succeed with BI:

Give users the best data analysis tool available
Build on the familiarity of Excel to accelerate user adoption. Expand the existing capabilities with column-based compression and in-memory Bi engine, virtually unlimited data sources, and new Data Analysis Expressions (DAX) in familiar formula syntax.

Facilitate knowledge sharing and collaboration on user-generated BI solutions.
Deploy SharePoint 2010 to provide the collaboration foundation with all essential capabilities, including security, workflows, version control, and Excel Services. Install SQL Server 2008 R2 to enable support for ad-hoc BI applications in SharePoint, including automatic data refresh, data processing with the same performance as in Excel, and the PowerPivot Management Dashboard. Your users can then access PowerPivot workbooks in the browser without having to download workbooks and data to every workstation.

Increase BI management efficiency.
Use the PowerPivot Management Dashboard to manage performance, availability, and quality of service. Discover mission-critical applications and ensure that proper resources are allocated.

Provide reliable access to trustworthy data.
Take advantage of SQL Server Reporting Services data feeds to encapsulate enterprise systems and reuse shared PowerPivot workbooks as data sources in new analyses.

Get Started Now

Start your PowerPivot for Excel journey today. Create and share robust workbook applications directly in Office 2010:

Related Links

Take a closer look

Next Steps

Download the CTP

The Community Technology Preview allows you to experience SQL Server 2008 R2 before final release.

Connect with the SQL Server development team

Learn more about upcoming releases and other important product information.

Let us know what you think

Collaborate and evaluate SQL Server 2008 R2 to ensure the product exceeds your expectations and needs.

Attend PASS summit for a deep dive

Join thousands of other SQL Server professionals in Seattle from November 2-5.

What's New in R2 Editions

Learn What's New in SQL Server 2008 R2 Editions

What top companies are doing right with their BI initiatives and what you can learn from them. By Doug Henschen, Intelligent Enterprise

Manufacturers and retailers lead the way in using up-to-the-minute point-of-sale data to avoid stock-outs and overproduction. By Doug Henschen, InformationWeek

This comprehensive data platform is secure, reliable, and scalable for your mission critical applications and provides rich services for any data type.

Learn more about this enterprise class, low-cost, feature-rich and easy-to-use data platform

The Blueprint Poster by Advaiya gives IT managers a comprehensive view of how Business Intelligence & Search technologies work within their IT environment.

In a platform-aligned environment, organizations can easily and inexpensively poll existing data sources and live business processes to get the most recent and accurate picture of the environment.

Find out how Microsoft BI can help you in IT, Finance, Operations, and Sales

Microsoft BI offers a complete, fully integrated set of BI technologies that can help reduce the complexity of organizing and distributing information, enable better business decisions, and improve your bottom line.

Improving business insight and performance with business intelligence.