Querying Analysis Services Data from Matlab

Virtually all major statistical and analytical software packages have provision for obtaining data from a relational data source using SQL queries. Unfortunately, many of the tools that work with SQL do not help when the data source is an Analysis Services database and the query language is MDX or DAX. As mentioned in the previous […]
Read More ›

Editing DAX Queries with DAX Studio

Among the new features sported by Excel 2016 is the highlighting of DAX keywords in the Power Pivot formula bar. (Just as an aside, this example definition makes use of the new DAX variables.) Any help writing DAX is greatly appreciated, but while the colorization is a nice feature, it would be nicer still to […]
Read More ›

Excel 2016: DAX Variables

  DAX Variables Well, DAX variables weren’t actually introduced with Excel 2016; they weren’t even introduced in 2016. Come to think of it, DAX variables aren’t even variables. Nevertheless, DAX variables are one of the most interesting and exciting recent additions to DAX. DAX variables were introduced to the Power Pivot engine in 2015, so […]
Read More ›

Executing DAX Queries From R

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 […]
Read More ›

How to Write DAX Summary Queries In Excel Using PowerPivot: The SUMMARIZE Function

In the previous segment, we saw how to write DAX statements in Excel to query Power Pivot Data. In this segment, we will take a first look at the SUMMARIZE function. While the DAX queries discussed here could be executed in the Management Studio against an Analysis Services tabular mode database, here we will be […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.