MDX Fundamentals
Offered By: Pluralsight
Course Description
Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
This course provides an introduction to MDX by explaining key concepts, introducing commonly used functions, and demonstrating working examples of MDX queries.
This course explains how to use MDX to query an Analysis Services multidimensional database. It begins with an introduction to the language, showing how it can be used beyond developing a cube, as well as an introduction to important concepts such as tuples and sets. The course then focuses on how to structure queries and how to create sets to use on a query axis. The course then continues with an exploration of the multiple navigation functions used to traverse hierarchical data. Last, it explains how to build more complex queries by adding calculations in the form of calculated measures, calculated members, and named sets. This course was written for SQL Server 2012 Analysis Services, but most principles apply to SQL Server 2005 and later.
This course explains how to use MDX to query an Analysis Services multidimensional database. It begins with an introduction to the language, showing how it can be used beyond developing a cube, as well as an introduction to important concepts such as tuples and sets. The course then focuses on how to structure queries and how to create sets to use on a query axis. The course then continues with an exploration of the multiple navigation functions used to traverse hierarchical data. Last, it explains how to build more complex queries by adding calculations in the form of calculated measures, calculated members, and named sets. This course was written for SQL Server 2012 Analysis Services, but most principles apply to SQL Server 2005 and later.
Syllabus
- Introduction to MDX 35mins
- Basic MDX Queries 37mins
- Sets 70mins
- Hierarchies in MDX 26mins
- Calculations 47mins
Taught by
Stacia Misner Varga
Related Courses
Microsoft BI Certification TrainingEdureka Building Websites with MDX and Gatsby
egghead.io Theme UI
egghead.io unified - the compiler for your content
egghead.io Introduction to Gatsby, v2
Frontend Masters