At the recent London Data Culture Day, organised by Jen Stirrup, I gave a presentation on Excel Cube Functions, querying a SQL Server database uploaded into Power Pivot to provide the cube, focusing on using MDX to enhance the capability of the function.
Jen has already posted the slides on SlideShare, but for anyone that is interested, you can grab my demo files from my OneDrive.