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, I Do Data Limited
Udemy 8h 14,065 enrolled English4.5

What you'll 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.)

About this course

Welcome to this course on SQL Server SSAS and MDX Cubes – an Introduction.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

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.

But what if you want to get information out quickly? OLTP databases are not based designed for this. What you need instead is a process whereby data is pre-aggregated – in other words, a lot of the calculations you may write have been calculated before you ask for them. It saves a lot of time. It would also be useful if the end user didn’t have to bother with SQL queries, and could use something a bit more hands-on, although retaining something more advanced for advanced users. That’s where cubes come in, full of pre-aggregated data, and SQL Server Analytical Services– or SSAS – (Online Analytical Processing) allows you to make these cubes.

This course is designed for the complete beginner in Multidimensional cubes, or someone who wants to refresh their memory. We’ll create a cube to start with from an ordinary database, and then I’ll ask you to create one from a special database known as a Data Warehouse. We’ll export our cube in SQL Server Management Studio, and into SSRS – and we’ll even have a bit of a look at the more advanced way of querying that is MDX.

Related coupons

Udemy Course Reviews

Udemy Coupon Insights for SQL Server SSAS (Multidimensional MDX) - an Introduction

This Udemy coupon unlocks a guided path into SQL Server SSAS (Multidimensional MDX) - an Introduction, so you know exactly what outcomes to expect before you even press play.

Phillip Burton, I Do Data Limited leads this Udemy course in Development, blending real project wins with step-by-step coaching.

The modules are sequenced to unpack SQL Server Analysis Services (SSAS) step by step, blending theory with scenarios you can reuse at work while keeping the Udemy course reviews tone in mind.

Video walkthroughs sit alongside quick-reference sheets, checklists, and practice prompts that make it easy to translate the material into real projects, especially when you grab Udemy discounts like this one.

Because everything lives on Udemy, you can move at your own pace, revisit lectures from any device, and pick the payment setup that fits your budget—ideal for stacking extra Udemy coupon savings.

Phillip Burton, I Do Data Limited also keeps an eye on the Q&A and steps in quickly when you need clarity. You'll find fellow learners trading tips, keeping you motivated as you sharpen your Development skill set with trusted Udemy discounts.

Ready to dive into SQL Server SSAS (Multidimensional MDX) - an Introduction? This deal keeps the momentum high and hands you the tools to apply SQL Server Analysis Services (SSAS) with confidence while your Udemy coupon is still active.

Frequently Asked Questions

Is SQL Server SSAS (Multidimensional MDX) - an Introduction free with coupon?
Yes, SQL Server SSAS (Multidimensional MDX) - an Introduction is currently available with our exclusive coupon code "VOUCHER202510" for significant savings.
How do I apply the SQL Server SSAS (Multidimensional MDX) - an Introduction discount code?
Simply click the "Enroll Now" button on this page. The coupon code will be automatically applied at checkout.
What will I learn in SQL Server SSAS (Multidimensional MDX) - an Introduction?
In SQL Server SSAS (Multidimensional MDX) - an Introduction, you'll learn Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool). This Udemy course provides practical, hands-on training.
How long do I have access to SQL Server SSAS (Multidimensional MDX) - an Introduction?
Once enrolled, you get lifetime access to SQL Server SSAS (Multidimensional MDX) - an Introduction. You can complete the course at your own pace.
Is SQL Server SSAS (Multidimensional MDX) - an Introduction a Udemy course?
Yes, SQL Server SSAS (Multidimensional MDX) - an Introduction is a comprehensive Udemy course with lifetime access and certificate of completion.