PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

PowerPivot.com demos are running again

For those interested, I’ve been able to get some of the PowerPivot demos running again. Here is a quick status:

Contoso Retail Warehouse workbook: RUNNING!
NFL Stats: (not yet – it points to the PowerPivot Gallery where the demos are stored!)
USDA Analysis: (not yet – it points to the PowerPivot Gallery where the demos are stored!)
NBA Stats: [...]

Using a SharePoint list as a data source

So . . . here I am playing around with PowerPivot to get ready for a demo. As this is a group from the SharePoint dev team (actually SharePoint Online), I wanted to include some cool SharePoint functionality into the demo. Trying to be cool and ‘wow’ them, I decide to use a SharePoint list [...]

Querying data within the PowerPivot Excel client add-in

Recently we have been seeing some users complain about how the PowerPivot Excel client add-in deals with queries. There are three limitations that you need deal with when working with SQL (TSQL, PL/SQL, or whatever) and stored procedures:

The result set must have a name associated with each column. If you are not returning the column [...]

Howto: Write to the ULS

As more and more folks start to get into PowerPivot and SharePoint, there is a need to programmatically write entries into the ULS. Since all of PowerPivot and all of SharePoint share this common logging infrastructure, why not also include log entries from your own processes. Here is some sample code for doing that:

First via [...]