question

Rob Farley avatar image
Rob Farley asked

What is the best way of learning MDX?

Suppose someone who is good at T-SQL wants to learn MDX, so that they can write better reports, and feel confident about tuning MDX queries.

How should they go about it?

Books? (if so, which ones?)

Courses?

Blogs?

Whitepapers?

(Seeder question - if you have over 2000 reputation points here, please refrain from answering this question for a week or so)

mdxseeder-questionlearning
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Bob Leithiser avatar image
Bob Leithiser answered

I've found the MS Press step-by-step books useful for learning things from scratch, they provide hands-on labs along with the instruction.

The MS Press book Microsoft® SQL Server® 2008 MDX Step by Step has a decent rating on Amazon and is probably a good start: http://www.microsoft.com/learning/en/us/book.aspx?ID=12914&locale=en-us

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Chris H avatar image
Chris H answered

I've found that a combination of books, on-line tutorials/examples, and some course material to be the best. Some of my favorite books are the Wrox SQL Books, sites with examples such as SQL Server Central, and Pragmatic works for examples of training. I don't like spending money on classes until I've read a book or two on the subject. This allows me to work through some examples, get a good handle on some of the terminology, gather questions, and finally taking courses getting more bang for my buck with my up front work. I'm just getting deeper into MDX myself having come from the dark ages of SQL Server 2000 and smack into 2008 Enterprise with BI. SSIS, SSRS and MDX are amazing; and I'm excited to approach future challenges with these tools.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.