SQL Server SSAS (Multidimensional MDX) – an Introduction

Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool)

Created by: Phillip Burton • 880000+ students so far
Best Selling Instructor - over 880,000 students so far

Created by: I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

What Will I Learn?

• 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.

Requirements

• You don't need to know or do anything before starting this course.
• I'll show you have to download the Developer Edition of SQL Server 2022 for FREE.
• You need to have a Windows computer, or use a Mac computer which can dual-boot into Windows or using Parallel Desktop with Windows. (However, it will not work under Windows ARM - for example, a Mac M1 or M3.)

Target audience

• This is for you if you want to learn about SQL Server Analysis Services.
• No previous experience using SSAS is necessary.
• It would be useful if you have previously used SQL Server (T-SQL), but far from essential.