Category Archives: Uncategorized

London Data Culture Day 2015

Posted on December 15, 2015 by wessexbob

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 … Continue reading →

Posted in CUBE Functions, Excel, Pivots, Power BI, Power Pivot, Uncategorized | Tagged | Leave a comment

One Slicer To Control Them All

Posted on July 4, 2015 by wessexbob

In Excel 2007, Microsoft added structured tables. Although far from being my favourite Excel feature, they are certainly a step in the right direction, and Microsoft are using them more and more in other functions. Excel 2010 saw the addition … Continue reading →

Posted in Uncategorized | Tagged , , , , , | 2 Comments

PASSBAC 2015 Revisited

Posted on April 29, 2015 by wessexbob

As promised at my session on Excel’s CUBE functions at PASSBAC 2015 in Santa Clara on 22nd April, here are the files that I used at that session. It was my intention to have just two Excel workbooks, a starting … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , , , , , | 2 Comments

Patterns in the Sand

Posted on March 19, 2015 by wessexbob

I have just received my copy of Marco Russo and Alberto Ferrari’s book, DAX Patterns (paid for copy!). I am not sure how much value I will get out of the book, I think Marco and Alberto work in a domain that … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | Leave a comment