I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already know MDX, you might wonder how to “translate” your MDX knowledge in DAX. I think that this is another way you can improve your knowledge about DAX: it has different concepts behind and this comparison should be helpful in this purpose. This is a first step in this comparison, I will continue with other articles in this series based on feedback I will get.

And don’t forget PowerPivot! This is still the best way to start practicing with DAX now and you can solve many reporting needs by just using it. We did a roadshow in Europe in the last month, and now we announce the first PowerPivot Workshop online edition dedicated to Far East and Australia! It is scheduled for November 24-25, 2012, with this schedule:

Beijing: 8:00am-11:00am / 1:00pm-4:00pm
Hong Kong: 8:00am-11:00am / 1:00pm-4:00pm
–>Jakarta: 7:00am-10:00am / 12:00am-3:00pm
–>Mumbai: 5:30am-8:30am / 10:30am-1:30pm
–>New Delhi: 5:30am-8:30am / 10:30am-1:30pm
Perth: 8:00am-11:00am / 1:00pm-4:00pm
Seoul: 9:00am-12:00am / 2:00pm-5:00pm
–>Shanghai: 8:00am-11:00am / 1:00pm-4:00pm
Singapore: 8:00am-11:00am / 1:00pm-4:00pm
–>Sydney: 11:00am-2:00pm / 4:00pm-7:00pm
Tokyo: 9:00am-12:00am / 2:00pm-5:00pm
GMT: 0:00am-3:00am / 5:00am-8:00am

We are defining partnerships with training centers in these countries, after this online edition I hope you will find other options nearest to you. And if you run a training center and are interested in partnership, hurry up and contact us before this online edition (attending the workshop is a requirement for trainers before delivering the same course).

We know that US and other countries are waiting for the workshop, but we’re working on this, too – more news very soon, I hope!