SQL Server SSAS (Multidimensional MDX) – an Introduction

Back To All Courses

92 Lessons

All

Skill Level

7:55h

course Duration

English

Audio

Eng & Esp

Subtitles

Share This Class:

Overview

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

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 to get information about? 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.

Completing this course will help you:

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

Learning Path

Installing software

Installing SQL Server Developer
Installing Visual Studio
Downloading AdventureWorks

Creating cubes

Creating our first cube
Creating a new cube, and enhancing it.

Creating MDX Statements

Creating MDX Statements – Measures
Creating MDX Statements – Dimensions
Hierarchies and Date hierarchies
Creating and joining sets
Functions
Key Performance Indicators
Using Cubes in Excel and SSRS

What people are saying

“One of the best cources I ever did on Udemy. Exactly what I looked for. Thank you”
Patrik
“Phillip is an amazing tutor. SSAS is exactly same with SAP Universe Designer or with multidimensional cubes, it is fun to explore. If you are coming from SAP space, this course is def for you.”
Bahar
“I went from knowing vey little to understanding quite a lot in a very short amount of time. I have enough knowledge now to continue on learning more advanced concepts of SSAS and MDX.”
Tim
“Philip did an amazing job on this one as on all the other courses he created that I already took. Thanks for sharing knowledge so understandable even for a secondary language speaker.”
Philipp
Previous
Next