Sticky Glue

This year I had the priviledge in presenting at the Tech-Ed Africa Conference for Microsoft for the 4th year running.. One of the sessions I presented was killer real world powerpivot examples.

The session was origanally done by a “crazy” Australian ,Grant Paisley from Angry Koala, at the North American Tech-Ed. I took the same principle but gave it a bit of a South African Twist.

First I began with a dataset from the National Sea Rescue Institute , and focused around end-user functions in PowerPivot as well as some basic banding in DAX. I then looked at a proof of concept PowerPivot example which originally connected to SAP and was based around HR data. Then I went into some common examples of ATM transactions and Aged Payment Analysis. Final I showed some tricks around Maps and Data (courtesy Microsoft).

All in All I believe the session went off well and the ratings from the audience, seems that they appreciated it.

As promised, Attached to this post is the PPT files as well as all the Excel Examples for anyone to play around with. Thanks everyone for attending

PowerPivot – Shark Attack Example

PowerPivot – HR Example

PwerPivot – ATM Transactions Example

PowerPivot – Aged Payments Example

PowerPivot Presentation