Home > DAX > DAX #1 – Learning DAX

DAX #1 – Learning DAX

I recently attended a virtual training of Tabular and Power Pivot for Developers taught by Kathy Vick at Pragmatic Works. Kathy had a comment (also an inside joke for developers I think) that for those who already have multidimensional cube and MDX skills, learning about the tabular (and PowerPivot, DAX) model doesn’t make any sense.

Putting the inside joke aside, I think the comment did raise a question in my mind. Why do I need to learn the tabular model? After some thinking, I came up with this answer, to learn DAX.

After 4 days training, and many slides and many demos, I realized that in the back of mind, what I really wanted to learn is another query language, DAX (Data Analysis Expressions).

Yes, this is on top of two query languages, SQL and MDX, most SQL Server developers are already familiar with.

A simple Googling and Bing, the search results are quite interesting.

  • SQL Server 2012 SQL language: over 15 million results.
  • SSAS MDX language: adequately 163 thousand results
  • SSAS DAX language: barely 52 thousand results.
  1. April 26, 2014 at 1:57 am

    Any chance you can share some insights to our community group?

    Like

  2. April 28, 2014 at 6:18 pm

    Derek, I’d love to do that. Let’s reconnect in August to coordinate.

    Sherry

    Like

    • April 28, 2014 at 11:32 pm

      Thank you so much.
      Will contact you when time is approaching

      Like

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: