In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class will provide you with the skills to use MDX with SQL Server Analysis Services in your enterprise.
Stacia Misner, course instructor and SQL Server MVP, will start 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, she will continue by explaining how to write MDX queries to retrieve data from an Analysis Services cube.
Stacia will also cover the following topics:
Throughout the 30-day course, you will learn how to:
- Build MDX queries
- Create sets with functions and use functions for set operations
- Work with hierarchical sets
- Build calculated members and add calculations to a query
- Debug a MDX script
- Implement dynamic security and configure cell-level security
- Use SQL Server Profiler to analyze queries
- Optimize queries for the Formula Engine and the Storage Engine
Course Structure and Cost
Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.
The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.
Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (Download link via e-mail).
Pragmatic Works is also offering a live, four-day version of the Introduction To MDX class for $795. For more information about this option, visit Pragmatic Works’ site.