SQL Server SSAS (Multidimensional MDX) – an Introduction

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Welcome to Udemy

Lecture 3: Introduction to Udemy

Lecture 4: Do you want auto-translated subtitles in more languages?

Lecture 5: Which version of Visual Studio should I install?

Chapter 2: Installing SQL Server

Lecture 1: Downloading SQL Server Developer 2022

Lecture 2: Installing SQL Server Developer 2022

Lecture 3: Installing SQL Server Management Studio

Lecture 4: Installing Visual Studio 2022

Lecture 5: Installing SSAS in Visual Studio 2022

Lecture 6: Is your Visual Studio a trial version? No!

Lecture 7: AdventureWorks

Lecture 8: Downloading AdventureWorks

Lecture 9: Investigating AdventureWorks in SSMS.

Chapter 3: Creating our first cube

Lecture 1: Creating our first project

Lecture 2: Looking at our working environment, and Facts, Measures, Dimensions and Cubes

Lecture 3: Creating a Data Connection

Lecture 4: Creating a Data Source View

Lecture 5: Creating a Cube

Lecture 6: Your Windows User Name and Password

Lecture 7: Creating a role, and playing with the cube

Lecture 8: Looking at the cube using Excel

Lecture 9: Adding an extra table, and Creating a dimension

Lecture 10: Updating the cube, and using Excel again.

Lecture 11: Looking at the cube using SSMS

Lecture 12: Visual Studio 2022 update

Lecture 13: Looking at the cube in SSRS

Chapter 4: Creating a new cube, and enhancing it.

Lecture 1: Practice Activity – Let's do it again!

Lecture 2: Practice Activity – your instructions

Lecture 3: Practice Activity – The Solution

Lecture 4: Updating dimensions, and creating translations

Lecture 5: Adding a new table into the Data Source View, and replacing it with a query

Lecture 6: Adding a hierarchy – two levels

Lecture 7: Adding a hierarchy – three levels

Lecture 8: Introduction to Practice Activity 3

Lecture 9: Practice Activity Number 3

Lecture 10: Practice Activity Number 3 – Solution

Chapter 5: Creating MDX Statements – Measures

Lecture 1: MDX Resources

Lecture 2: Default measure, and using the WHERE clause for measures

Lecture 3: Adding measures onto the Column axis, and creating a Set of measures

Lecture 4: "Go"

Lecture 5: Creating a temporary measure using MDX

Lecture 6: Creating a permanent measure using Visual Studio

Lecture 7: Practice Activity Number 4

Lecture 8: Practice Activity Number 4 – Solution

Chapter 6: Creating MDX Statements – Dimensions

Lecture 1: Referring to Dimensions, Hierarchies, Levels and Members

Lecture 2: Quiz – referring to Dim Date dimensions, hierarchy, levels and members

Lecture 3: Visual Studio – changing the appearance and order of months of the year

Lecture 4: Referring to multiple members and Using the Range : operator

Lecture 5: Getting rid of NULLs – using Non Empty

Lecture 6: Creating a tuple

Lecture 7: Changing the aggregation using tuples

Lecture 8: Practice Activity Number 5

Lecture 9: Practice Activity Number 5 – Solution

Chapter 7: Hierarchies

Lecture 1: Parents and children

Lecture 2: Ancestors and Ascendants

Lecture 3: Descendants, firstchild and lastchild

Lecture 4: Siblings functions

Lecture 5: Practice Activity Number 6

Lecture 6: Practice Activity Number 6 – Solution

Chapter 8: Date hierarchies

Lecture 1: Getting YTD and MTD to work

Lecture 2: LastPeriods – going into the past

Lecture 3: ParallelPeriod, and combining with YTD

Lecture 4: Practice Activity Number 7

Lecture 5: Practice Activity Number 7 – Solution

Chapter 9: Creating and joining sets

Lecture 1: topcount, toppercent, bottomcount, bottompercent

Lecture 2: Creating sets

Lecture 3: UNION and RANK

Lecture 4: Intersect and Except

Lecture 5: Practice Activity Number 8

Lecture 6: Practice Activity Number 8 – Solution

Chapter 10: Functions

Lecture 1: Subcubes

Lecture 2: Hierarchize

Lecture 3: Order

Lecture 4: Filter

Lecture 5: format_string

Lecture 6: Formatting using custom coding

Chapter 11: Key Performance Indicators

Lecture 1: Introduction to KPIs

Lecture 2: Revisiting parallelperiod

Lecture 3: The CASE statement

Lecture 4: IIF – an alternative to CASE

Lecture 5: IsEmpty

Lecture 6: Introduction to Practice Activity 10

Lecture 7: Practice Activity Number 10

Lecture 8: Practice Activity Number 10 – Solution

Lecture 9: Adding KPIs into your SSAS Cube

Lecture 10: How complicated can your KPI definition go?

Chapter 12: Using Cubes in Excel and SSRS

Lecture 1: Opening a cube in Excel, both through Visual Studio and making a connection