SQL SERVER SSAS: Multidimensional MDX – an introduction

OVERVIEW

This course is an introduction to SQL Server SSAS and MDX Cubes. You may have become experienced with creating SQL statements in SQL Server Management Studio. Building databases is ideal when you want to quickly add data – that’s why they are called OLTP – Online Transaction Processing – they are designed for speed for adding transactions. However, OLTP databases are not designed for retrieving an analysis from this data. A process of pre-aggregated data is needed. Cubes are full of pre-aggregated data. SQL Server Analytical Services– or SSAS – (Online Analytical Processing) allows you to make these cubes.

On completion, you will be able to:

• Create cubes in SSAS, based on fact and dimension tables.
• Process the cubes, and analyse them in Excel, SSRS, and access them in SSMS.
• Learn some of the more advanced items, such as translations.
• Learn MDX language to query your cubes.

.

WHO IS THE COURSE FOR?

This course is for those who want to learn about SQL Server Analysis Services (SSAS).

No prior knowledge is required. This course is designed for the complete beginner in Multidimensional cubes, or those who want to refresh their memory.

Some knowledge of SQL Server T-SQL is beneficial but not essential.

.

LEARNING PATH

REVIEWS

“Phillip Burton is a very knowledgeable instructor and this course meets the quality of his other courses. The structure of the lessons and the development of each lesson on the previous is very well done. The practice activities develop the skills that he teaches.” Louis

“Phillip is an excellent instructor and if you are even remotely interested in multidimensional cubes and deployment you will find this useful. Exceptional!” Cisca

“Amazing Trainer. I love his teaching style. The content and the explanations are very clear beyond doubt.” OmMuruga

.