The SQL Server team has annouced the official name for Project Gemini—Microsoft SQL Server PowerPivot for Excel 2010—at the SharePoint Conference in Las Vegas.

Introducing PowerPivot for Excel 2010

clip_image002PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. Leveraging familiar Excel features, users can transform enormous quantities of data from virtually any source with incredible speed into meaningful information to get the answers they need in seconds.

Using SQL Server PowerPivot for SharePoint 2010 (delivered thru SQL Server 2008 R2 in SharePoint 2010), end users can effortlessly and securely share their finding with others and work seamlessly in the browser with the same performance and features as the Excel client. PowerPivot for SharePoint even helps IT departments improve their operational efficiencies through SharePoint-based management tool called PowerPivot Management Dashboard. IT administrators can track usage patterns over time, drill down to obtain more details, discover mission-critical solutions, and ensure performance by making sure users have the appropriate resources.

PwrPiv-LowerLft[1]

Frequently Asked Questions

1. What’s PowerPivot and how does it relate to “Managed Self Service BI”?

PowerPivot has two distinct components. A client add-in to Excel 2010 called SQL Server PowerPivot for Excel and a server component delivered thru SQL Server 2008 R2 to SharePoint 2010 called SQL Server PowerPivot for SharePoint.

PowerPivot for Excel enhances self-service BI capabilities by providing you with greater flexibility of data manipulation using any size data set in structured or unstructured form using the familiar Office interface thru Microsoft Excel 2010. In addition, you can publish your analysis in SharePoint 2010 as a web application and share it with insights with your co-workers.

“Managed Self Service BI” means that IT also benefits greatly with PowerPivot for SharePoint. They can provision reports – thus providing a single version of truth – and have end users work directly with data from those reports via Data Feeds. In addition, IT can track the usage of PowerPivot applications and discover mission-critical Excel applications

2. What’s the licensing model for PowerPivot for Excel and PowerPivot for SharePoint?

Final decision has not been made and we’re not planning to disclose any pricing/licensing/packaging guidelines until later this year. Please stay tuned for the official licensing & packaging communiqué.

3. What version of Office supports the PowerPivot for Excel client? What about PowerPivot for SharePoint?

PowerPivot for Excel only works with Excel 2010.

PowerPivot for SharePoint will require SQL Server 2008 R2 and SharePoint 2010.

Call To Action

Customers and partners can start signing up to be notified about the upcoming PowerPivot Technology Preview at www.powerpivot.com

Be Social: Join the PowerPivot Facebook  (also opens Monday) community page & use the #powerpivot hash sign on your Tweets