Microsoft Power BI 2.0
Nov 30,
2015
What is it about version 2.0? Perhaps when software reaches version 2.0 it seems to have gained some maturity and respectability, but is still young enough to be filled with excitement and energy. In any case, Microsoft’s Power BI Version 2.0, announced for general availability July 24, is generating considerable excitement within the community of […]
Executing DAX Queries From R
Nov 24,
2015
Christine, a student in Learning Tree’s course SQL Server Analysis Services for Business Intelligence, writes “I just created my first Analysis Services tabular model database, and I am having lots of fun. But now I want to do some more sophisticated statistical analysis using R. I can’t seem to find a way to use DAX […]
Writing DAX Summary Queries Using PowerPivot and Excel QueryTable Objects
Feb 15,
2015
Don’t get me wrong. Excel PivotTables are one of the best things since pizza and beer. (And considering how much I enjoy that particular combination of snack and beverage, that’s really saying something.) Nevertheless, there are times when you want to take full control, write your own DAX query, and display the results in a […]