THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Advanced DAX Workshops in the upcoming months –#dax #tabular #powerpivot

The adoption of DAX is slowly growing and we can see that from comments to article, blog posts, web site traffic (including DAX Formatter usage). For this reason, the demand for more advanced training about DAX is also increasing. We had great feedback from our last white papers (Using Tabular Models in a Large-scale Commercial Solution and SSAS Tabular as Analytical Engine) and we see that this reflect in a broader adoption. For this reason, also the demand for more advanced DAX content is growing, and we planned a number of courses in the next future.

I and Alberto Ferrari will travel a lot in the upcoming months to deliver many Advanced DAX workshops, but we still have some more introductive training coming soon.

This is the list of upcoming Advanced DAX Workshop (only in Europe by now, hopefully US coming next…):

We will have two pre-conferences at PASS Summit (3-4 November, 2014 – Seattle, WA):

If you want to learn SSAS Tabular starting from scratch, you have these other options to attend the SSAS Tabular Workshop:

We are also working on other content for the next months, and remember that we can deliver onsite training if your team is too large and/or too far from one of the public classroom sites. I look forward to see new things announced in the next weeks/months, and I am pretty sure DAX will grow its popularity (despite the lack of a good editor!).

Published Tuesday, September 30, 2014 10:48 AM by Marco Russo (SQLBI)
Filed under: , ,



David Mitchell said:

Hi Marco,

Hoping to see some UK dates in the future too.



September 30, 2014 4:19 AM

Marco Russo (SQLBI) said:

We had one in June!

Next one will be in first half of 2015 (date not yet defined)

Thanks for the feedback!


September 30, 2014 5:11 AM

Nick Singleton said:

Is Microsoft planning on adding dynamically generated DAX rather than MDX in Excel pivot tables?  If not, is MDX as fast as DAX for tabular models?

October 13, 2014 5:32 PM

Marco Russo (SQLBI) said:

I don't have info about that, but I think this is not going to happen. SSAS supports both DAX and MDX as Query languages and MDX is better for hierarchical navigation (such as a Pivot Table), whereas DAX is better for tabular reporting (such as SSRS and Power View).

Performance are similar - DAX could be slightly better in certain particular conditions, but remember that a MDX Query generates a specific Query plan and internally measures are Always written in DAX.

October 13, 2014 11:24 PM

Nick Singleton said:

How do you handle customizations for clients?  For example, each client has a crosswalk table/spreadsheet that they would like to use in their reporting.  For maintenance purposes, I don't like maintaining this information.  With PowerPivot, would it be possible for the user to keep their crosswalk locally and then add it to the Tabular model?  Essentially moving the customizations local to client.  Is this possible?

October 15, 2014 1:14 PM

Marco Russo (SQLBI) said:

If you mean customizing the data model, the answer is that it can be done, but you don't have a ready-to-use tool today. You can deploy schema changes to the server (provided you have authorization to do that) and then reprocess the information on the server. Or you might have data local to client (Excel) and push that on the server by copying the file in a place where it can be read from SSAS, or by copying table content to a SQL Server table (ora another RDBMS). But you don't have a tool to do that, you can write macros and Excel Add-In using the existing API (we did that several times).

October 15, 2014 1:33 PM

Nick Singleton said:

This is great.  Do you have examples of using macros or using the Excel Add-In API for this use case in any of your books or articles?

October 15, 2014 3:05 PM

Marco Russo (SQLBI) said:

We have samples of using XMLA in the SSAS Tabular book, but after that the AmoTabular library has been released ( I suggest you to take a look at that library for connecting to the server. We developed Excel Add-In for customers, so the code cannot be shared, but it's no different than sample Excel Add-In you can find for C# and VB.Net.

October 15, 2014 4:42 PM
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement