Temperature Mashup Demo – Download the Workbook!

November 18, 2009

As promised, here is the workbook that contains everything I have demonstrated so far in the Temperature Mashup example.

       Click here to download workbook

(NOTE: I discovered a bug in the original file – the Qty per Day measure was returning incorrect results.  The version above is now is fixed.  Also no longer needs to be renamed from .DOCX).

And the updated demo walkthrus for this workbook are here:

     Joining the temperature data to my sales data

     Creating a Sales Qty Per Day Measure


PowerPivot CTP3 (Beta) Download Links

November 18, 2009

OK folks, everything is available as of today!  Here is a collection of the links you will need to grab PowerPivot and try it out:)

Office 2010 Beta 2

You must have the most recent Beta of Excel 2010 installed prior to installing the PowerPivot addin.

Download Here

Note:  Install 64-bit if you intend to use large data volumes.

PowerPivot for Excel 2010

This is the addin required to design PowerPivot models and reports in Excel 2010.

32-bit Public Download

64-bit Public Download

Note:  the addin must match the architecture of the Office build installed – 32- or 64-bit

(Once you have Excel 2010 and the addin installed, you are good to go.  You don’t need to install SharePoint or the SharePoint addin below until you are ready to try out the server story.)

SharePoint 2010 Beta 2

MSDN Subscribers Download Here

PowerPivot for SharePoint 2010

This is the SharePoint addin that allows you to publish, share, and manage PowerPivot reports.  Requires SharePoint 2010 Beta 2, above.

MSDN Download Here

TechNet Download Here

On both sites, expand Servers, then look for SQL Server 2008 R2 – that contains the PowerPivot SharePoint addin.

More Details

On PowerPivot.com