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?)
(Seeder question - if you have over 2000 reputation points here, please refrain from answering this question for a week or so)
Answer by Bob Leithiser ·
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
Answer by Chris H ·
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.