Category Archives: PowerPivot

PowerPivot Capacity Specification

PowerPivot for Excel is an add-in that you can use to perform powerful data analysis in Excel 2010, bringing self-service business intelligence to your desktop. PowerPivot for Excel includes a window for adding and preparing data, and a PowerPivot tab on the Excel … Continue reading

Posted in PowerPivot | Leave a comment

How to restore PowerPivot excel file as a SSAS Database.

Basically PowerPivot stores the data inside the In memory analysis services (Vertipaq). You can restore the inside database into the SSAS tabular or SharePoint instance. Following are the easy steps to get the inside database from the PowerPivot file: 1. … Continue reading

Posted in PowerPivot, SSAS | Leave a comment