Learn MDX Query Development

Now that you understand the fundamentals of SQL Server 2008 R2 Analysis Services cube design, it’s time to learn how to query them.  This seventh unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights) on MSDN will introduce you to the basics of using Multi-Dimensional Expressions (MDX) to develop powerful queries against your cubes.  You will also learn how to use MDX to enhance the design of your cubes with calculated members, named sets and key performance indicators (KPIs).

Here’s an overview of the new unit:

7. Introduction to SQL Server 2008 R2 Analysis Services Query Syntax Presentation: Introduction to SQL Server 2008 R2 Analysis Services MDX
Presentation: Exploring SQL Server 2008 R2 Analysis Services MDX Query Techniques
Demo: Introducing SQL Server 2008 R2 Analysis Services MDX Query Development
Presentation: Exploring SQL Server 2008 R2 Analysis Services Cube Calculations
Demo: Enriching a SQL Server 2008 R2 Analysis Services Cube with Calculations
Hands On Lab: Building Your First Queries and Calculations with SQL Server 2008 R2 Analysis Services MDX

You can find SQLInsights on the MSDN Training and Certification Resources page at the following URL:

https://go.microsoft.com/?linkid=9761002

Watch the videos and review the hands-on labs. If you want to run the demos or hands-on labs on your own computer, download and install the offline training kit. You’ll find all the SQLInsights content in the Getting Started > BI Developers page.

Next week, we’ll publish our eighth SQLInsights unit, Accessing SQL Server 2008 R2 Analysis Services Data. We hope SQLInsights will help you get started developing your first Microsoft BI solution. Thanks again for your interest in SQL Server 2008 R2!