Sharepoint Saturday EMEA – KPI roll-up

Didn’t you meet up at Sharepoint Saturday EMEA?

Too bad – I still haven’t recovered fully yet.

Even though most of the presentations were in the SP2010 sign, some WSS30/MOSS2007 presentations could also blow you away.

One of them were KPI roll-up in SharePoint 2007 (WSS and MOSS) by Christophe Humbert. Get the Slides.

It is really cool how he uses the DataView WebPart to display numbers in a table (using html formatting) as Progress bar and Traffic light as here:

From the presentation a couple of noticeable things were taught:

– This app was build without code. Can be done by Biz people.

– An advance over Excel Services: Immediate update of calculated columns – not only snapshot instances.

Enjoy some grapped img’s from his demo:

BU1-Pgm11 - Collapsed

BU1-Pgm11 - Expanded

Dashboard

BU1-Pgm11-Projects

BU1-Pgm11-Projects-Html formatting

BU1-Pgm11-Projects-Formula

Mode=CrossList

Before: Format as Text

After: Format as RichText

Neat trick.

The end.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: