PowerPivot Data Refresh

In this posting we will take a look at the data refresh facility in PowerPivot for SharePoint and show you how to use it for maximum benefit. To start off, let’s begin with a simple question: So . . . what is data refresh? And why should I care? Data refresh is all about keeping… Read more

Sharing workbooks using PowerPivot Gallery

Now that you have downloaded the PowerPivot for Excel November Technology Preview at PowerPivot.com, you have probably built a really interesting BI application right there in the workbook.  Importing and mashing up data from different sources, building calculations with business logic using DAX, and then creating rich interactive views in Excel with pivots, charts and… Read more

November Technology Preview of PowerPivot is here!

If you thought everything in the August Technology Preview was great (for a reminder of what was there see the Overview of Gemini Features posting from August) please take a look at what will be offered in the November Preview. What’s New in PowerPivot in SQL Server 2008 R2 November CTP PowerPivot for Excel PowerPivot… Read more