Introduction to MDX

Learn MDX for SSAS in our virtual training course. Master multidimensional expressions for cube calculations, querying, and retrieving data. Elevate your enterprise analytics.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

Learn MDX for SSAS in our virtual training course. Master multidimensional expressions for cube calculations, querying, and retrieving data. Elevate your enterprise analytics.

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

During this MDX virtual training course, you will learn how to use MDX for use with SSAS in your enterprise. This class starts by explaining the basic concepts related to multidimensional expressions and how they are used to enhance cubes with calculations as well as to query cubes to retrieve data for reports. Then the class continues by explaining how to write MDX queries to retrieve data from an Analysis Services cube. This class also covers the following topics: common functions for creating sets and performing set-based operations, development of calculations that can be used as measures or as dimension member, addition of calculations and named sets to a cube for re-usability, script assignments for complex calculations, MDX and cube security, and optimization techniques for queries.

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Introduction to MDX - What you need to get started

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Mitchell Pearson

Data Engineer (Azure) Trainer

Mitchell Pearson has been with Pragmatic Works for 11 years as a Data Platform Consultant, Trainer and Team Lead. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform, Microsoft Azure and Fabric.

Learn More

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

- 2 GHz or faster CPU - 2 GB of available RAM (recommended 4 GB) - 20 GB of free hard drive space - SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/20142016 - SQL Server Database Engine - SQL Server Analysis Services Multidimensional - SQL Server Data Tools (SQL 2012/2014/2016) or Business Intelligence Development Studio (SQL 2008/2008R2) - SQL Server Management Studio - Follow this [installation guide](https://www.youtube.com/playlist?list=PLcwrIWK7WBcRXS59lktaU9SJwb3cGgvCw) to ensure all items are installed correctly - AdventureWorksDW2008R2 or AdventureWorksDW2012 database installed on the instance. - AdventureWorks Cube restored to the Analysis Services instance. Need additional help installing the SQL Server tools? Check out our video series on installing these requirements [here](https://www.youtube.com/playlist?list=PLcwrIWK7WBcS6yAJb-FjYMndzWPxmbQ0_).

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

6+ hours hours of training
Access on mobile and browser
Certificate of Completion