Tag Archives: Excel 2013

One Slicer To Control Them All

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 , , , , , | Leave a comment

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

Unpivot Nested Headings With Power Query

If you are a data analyst, you undoubtedly know and love Excel, and undoubtedly know and love pivot tables, they must be a core part of your analysis toolbox. No doubt at some time you will have faced the need … Continue reading

Posted in Power BI, Power Query | Tagged , , , , , , | 9 Comments

MDX CUBEd

I have posted a few times about Excel’s CUBE functions which are very useful for creating reports in a format and layout that pivot tables often just cannot achieve. They were useful when SSAS were the only cubes to work … Continue reading

Posted in CUBE Functions | Tagged , , , , , , | Leave a comment