X
ODT

Introduction to MDX
On-Demand Training

Starting At: $495.00
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Introduction To MDX
$495
Per User Per Year
Business Intelligence Pack
$995
Per User Per Year
Unlimited Elite Pack
$1295
Per User Per Year
Free Trial
3:13
3:13
2:00

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message

Course Details

By taking this course, you’ll learn how to use MDX for use with SSAS in your enterprise. This class begins with 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.

What Will You Learn?

  • How to write MDX queries to retrieve data from an Analysis Services cube
  • Common functions for creating sets and performing set-based operations
  • MDX and Cube security
  • Optimization techniques for queries

Prerequisites


Some experience with Analysis Services.

System Requirements


  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

  • AdventureWorks Cube installed on the Analysis Services instance

Curriculum For This Course

Image

Mitchell Pearson

BI Consultant and Trainer

As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS, and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.



Related Courses

Course Info
7 Comprehensive Modules
14 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Duration:
6h 40m
Download Syllabus
Enrollment Price:
$495/Year

Share this course with your friends