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.
Download Course Outline View Schedule/Book OnlineWho 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, participants 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
Reviews
There are no reviews yet.