Description: Multidimensional expression, MDX, is an industry standard query language used to retrieve data as well as perform data definition and data manipulation operations for Analysis Services. MDX can be used in various tools to create ad hoc or reusable scripts to work with Analysis Services cubes. An important part of ensuring a BI solution is operating efficiently is monitoring the performance of the different SQL Server instances being used, including SQL Server Analysis Services, the data warehouse, and Reporting Services. In this course, you will learn how to create MDX calculations to obtain the desired result set. You will also learn how to monitor the performance of the SQL Server instances to get optimal performance. This course is one of a series in the Skillsoft learning path that helps individuals prepare for the Designing Business Intelligence Solutions with Microsoft SQL Server exam (70-467).

Target Audience: Database and business intelligence administrators and developers who are responsible for designing a BI infrastructure, IT professionals interested learning how to design BI infrastructures and how they're related to data systems, and individuals interested in taking the Designing Business Intelligence Solutions with Microsoft SQL Server exam (70-467)

Duration: 03:01