Tag Archives: BA

PASSBAC 2015 Revisited

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

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

A CUBEMEMBERPROPERTY Equivalent With PowerPivot

I was recently asked how to use the CUBEMEMBERPROPERTY function with a Power Pivot model, to get the Customer Name with a formula by using a unique code such as the Customer Code. I can’t say that I use this function … Continue reading

Posted in CUBE Functions | Tagged , , , , , , | 9 Comments

PASS Business Analytics Conference – an Excel view

Chris Webb recently posted his thoughts on the first PASS Business Analytics Conference. Chris is a SQL Server MVP, but one of the first that I recall who acknowledged that Excel is the business’ choice, even for BI/BA. I am coming … Continue reading

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