Introduction to SQL Server Analysis Services
(Prerequisite: Advanced Applications of SQL or equivalent experience. Students should have experience with primary and foreign keys, Pivot command, and set operations.) This course introduces the Multidimensional Expressions (MDX) language as it is used in Microsoft Analysis Services. Learn how to perform ad-hoc data retrieval from online analytical processing (OLAP) cubes to select the information you need. Topics include establishing the order of the output, selecting slices of the cube, using MDX functions, and developing calculated members of dimensions. Understand the differences and similarities between online analytical processing and online transactional processing.
Fee: $239