Exploring MDX Using Microsoft SQL Server 2012

This book is for anybody who wants to learn MDX language. We have assumed that you have got some relational database design and SQL language experience, and know basic concepts of SQL Server Analysis Services (SSAS). Throughout the book, we used practice database "Adventure works", which is very popular among users of Microsoft SQL Server environment. Inside this book you will find: - More than 350 MDX queries. - MDX functions are explained with simple examples. - Some topics like "All Level" explained in detail with various examples. - Detail analysis of each component of queries. MDX query architecture explained in detail with examples. - Contains simplified definition of functions with examples and their possible values. - Explains how to improve performance of MDX queries and best practices. This book is an important and valuable reference for those interested in learning and improving their MDX skill.

Ashim has been working as designer, architect and trainer of various software and databases for last two decades. He studied undergraduate in computer engineering at National Institute of Technology, Kurukshetra, India and pursued graduate studies in computer science and automation at Indian Institute of Science, Bangalore, India. Ashim worked for various software companies around United States. He continues to have special interest in database, business intelligence, data analysis and sharepoint. Ashim is a regular visitor and contributor in MSDN forums.