Introduction to SQL Server 2008 R2 Analysis Services Query Syntax Now that you understand the fundamentals of cube design, it’s time to learn how to query them. This unit will introduce you to the basics of using SQL Server 2008 R2 Analysis Services 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). Hands-On Labs Hands On Lab: Building Your First Queries and Calculations with SQL Server 2008 R2 Analysis Services MDX This Hands On Lab will show you how to write basic SQL Server 2008 R2 Analysis Services MDX queries. Videos Presentation: Introduction to SQL Server 2008 R2 Analysis Services MDX This presentation provides an introduction to SQL Server 2008 R2 Analysis Services MDX. MDX stands for "multi-dimensional expressions", and is used to write queries, formulas and calcuations for performing multi-dimensional analysis and reporting. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Presentation: Exploring SQL Server 2008 R2 Analysis Services MDX Query Techniques This presentation explores query techniques used in SQL Server 2008 R2 Analysis Services MDX, including defining an axis, creating a set, set manipulation, using functions and keywords, asymmetrical queries and cell properties. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Introducing SQL Server 2008 R2 Analysis Services MDX Query Development This demonstration introduces simple SQL Server 2008 R2 Analysis Services MDX query statements. MDX, or Multi-Dimensional eXpressions, makes it easy to perform powerful analytic queries and calculations against cube data. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Presentation: Exploring SQL Server 2008 R2 Analysis Services Cube Calculations This presentation covers calculations and formulas in SQL Server 2008 R2 Analysis Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Enriching a SQL Server 2008 R2 Analysis Services Cube with Calculations This demo shows how to enrich a SQL Server 2008 R2 Analysis Services cube with calculated members, named sets and key performance indicators (KPIs). These calculations make it possible to incoporate consistent business rules in a Unified Dimensional Model. Presenter: Peter Myers, Mentor, Solid Quality Mentors.