This course provides the fundamental skills required to query cubes using the MDX SELECT statement and customize cubes with the MDX scripting language and functions. At the end of the course delegates will be able to confidently query existing cubes as well as create their own measures and named sets derive information from stored cube data and aggregations. The course covers the most commonly used set of MDX functions and scripting statements and provides the first step in a career of writing MDX statements and scripts. The course covers versions of SQL Server Analysis Services up to an including SQL Server 2016.
The course assumes no prior knowledge of MDX and provides an overview of Multi-dimensional Databases & Cubes, but it would be beneficial to have a basic knowledge and awareness of Multidimensional Databases and Cube terminology including terms such as Cubes, Facts, Measures, Measure Groups, Dimensions, Hierarchies, Members, Rollups.