Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX

by dennyglee Categories: Analysis ServicesTags: · Leave a comment

Want to know more about SQL Server 2012 Analysis Services – Multidimensional and Tabular?  Well, check out SQL Server 2012 Analysis Services with MDX and DAX!  The book is co-written by my SQL BI teammates – so thank goodness for that (to compensate for my lack of writing grace)!   So what’s in the book? Shows how to utilize SQL Server Data Tools to build Analysis Services multidimensional and tabular databases Shares fundamental concepts of DAX and MDX and dives into advanced concepts such as parent-child hierarchies and time-based analysis Demonstrates methods for analyzing and optimizing DAX and MDX query…

Rate this:

Pivots, Cube Formulas, Named Sets … Oh my!

by dennyglee Categories: PowerPivotTags: · · 8 Comments

Over the last few days, @PowerPivotPro has been calling me out for diving into the deep end into his world of Excel and getting the proverbial egg on my face (Joker picture not-withstanding).  He’s called me out, challenged my geek hood, and sliced / diced my postings (pun intended).  I was going to let this all slide…and then he started using “eh?!” in his postings!!!!  So the gloves are coming off!!!  … Or are they? CubeSet and CubeRankedMember cube formulas are great! For starters, in paying homage to someone who is vastly superior in Excel (I’m sure in other things…

Rate this: