Using PowerPivot with Excel 2010

In this blog article, we’ll step through using PowerPivot for Excel 2010 for building a rich application in Excel. Note: following screenshots describe the SQL Server 2008 R2 August Community Technology Preview (CTP) functionality for a feature codenamed Gemini.

See the rest here: 
Using PowerPivot with Excel 2010

Introduction to Data Analysis Expressions (DAX) in Gemini

The rest is here:
Introduction to Data Analysis Expressions (DAX) in Gemini

Gemini and DAX Extend the Power of PivotTables Excel PivotTables are not new, but Excel PivotTables that are based on multiple tables of data are new with the Gemini add-in for Excel 2010.

Getting Access to the Gemini CTP

See more here:
Getting Access to the Gemini CTP

As indicated in the previous blog post, you can get access to the Gemini CTP if you are a member of the Office 2010 Tech Preview by visiting http://www.microsoft.com/officebusiness/office2010/Default.aspx?vid=Gemini . If you are not a member of the Office Tech Preview, you can still apply for the Gemini CTP.