PowerPivot for Excel 2010 internally builds a SQL Server Analysis Services (SSAS) database. The data is highly compressed and is stored within the .xlsx file itself in the SSAS database format.
OK…so where is it exactly stored then?
Create a sample PowerPivot application in Excel 2010 and save the resulting file to your local file system. Next, rename the .xlsx file extension to .zip (use command prompt in Win 7).
Now open the resulting .zip file and navigate to the xl\customData directory.
The .data file is where the PowerPivot data (the actual SSAS database) is stored.
Guess what….you can deploy that SSAS database in SSAS if you like!
More info on IMDB or VertiPaq? Click here.