Slice ‘n Dice with PowerPivot

Today, I found two really good video presentations from Microsoft’s Tech Ed about Excel’s PowerPivot:

Building Sophisticated BI Applications Using Microsoft PowerPivot for Microsoft Excel

Enriching Microsoft PowerPivot for Microsoft Excel Applications Using DAX (Data Analysis Expressions)

Will PowerPivot be the next big thing? I think so.
Drag&Drop, Slice&Dice, what else do you want? 🙂


Podcast recommendations

Well, while I’m typing these posts…I’m usually listening to one of my favorite podcasts.

Made an easy clickable-iTunes-instant-download-list of the Club, House & Trance podcasts I’m listening to:

Release Yourself – Hosted by Roger Sanchez
Radio 538: Dance Department – Hosted by Dennis Ruyer
Push the Night – Mixed by Brad Miller
Beach House podcast – Mixed by Royce Cocciardi
Bar Grooves podcast
Funky Deep Tech House London – Mixed by Tinker
We Love Ibiza – Hosted by Tom Brown

I’ll be updating this list once I’ve found other great podcasts.
Got a podcast recommendation? Leave a comment!

Recursive Stored Procedure query

I stumbled upon a great stored procedure for Recursive Queries (here), but I wanted to recreate it for AdventureWorks.

Note: This one only works on the previous AdventureWorks database (not 2008R2, the Employee table has changed). Soon I’ll be posting a modified version of this based upon the AdventureWorks2008R2 database.

Basicly the Employee-table is self referencing table with levels (also known as ‘Tree Walking‘) has an EmployeeId and ManagerId I’m going to use.

The code:

How to execute:

And ofcourse, the results are shown here:

A really nice thing about this SP is that it uses a parameter Root, which can be used to ‘climb’ the tree. For example, if I set @Root to be 12:

Want the SQL sourcecode? Click here