SQL Server Analysis Services - MDX Training
Course Code: MDXE
Course Duration: 1 Day
Overview
This one-day hands-on, instructor led course will guide you
step-by-step through how to utilise the Multidimensional
Expression (MDX) query language for SQL Server Analysis
Services. You will learn a practical approach to solve real-world
problems using MDX expressions, calculations and
queries, which will provide you the ability to extract valuable
information.
Benefits
At the end of the course you will have skills and experience in
developing MDX expressions, formulas, KPIs, calculations and
queries and will take home many useful, real-world examples to
adapt to your own environments.
Who Should Attend
This course is designed for anyone who uses Microsoft Analysis
Services and wants to gain a greater understanding of MDX. This
includes report writers, business analysts and anyone that designs
and builds OLAP solutions.
Course Objectives
After completing this course, students will be able to:
- Construct and execute MDX queries
- Work with tuples, sets, and expressions
- Develop sets to retrieve the data users need
- Perform aggregation functions and navigate data
hierarchies
- Customize an Analysis Services cubes using MDX
- Develop MDX-driven reports in SQL Server Reporting
Services
Course Prerequisites
Before attending this course, participants should have:
- An understanding of basic database design, administration, and
implementation concepts
Participants should also have an understanding of basic OLAP
database concepts in SQL Server Analysis Services, including:
- Creating databases, dimensions, and cubes
- Creating simple calculated members
- Working with shared and private dimensions
- Processing a cube