SQL Server SSAS (Multidimensional MDX) an Introduction

SQL Server SSAS (Multidimensional MDX) – an Introduction, available at $89.99, has an average rating of 4.65, with 92 lectures, based on 2226 reviews, and has 13048 subscribers.

You will learn about 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. This course is ideal for individuals who are This is for you if you want to learn about SQL Server Analysis Services. or No previous experience using SSAS is necessary. or It would be useful if you have previously used SQL Server (T-SQL), but far from essential. It is particularly useful for This is for you if you want to learn about SQL Server Analysis Services. or No previous experience using SSAS is necessary. or It would be useful if you have previously used SQL Server (T-SQL), but far from essential.

Enroll now: SQL Server SSAS (Multidimensional MDX) – an Introduction

Summary

Title: SQL Server SSAS (Multidimensional MDX) – an Introduction

Price: $89.99

Average Rating: 4.65

Number of Lectures: 92

Number of Published Lectures: 92

Number of Curriculum Items: 92

Number of Published Curriculum Objects: 92

Original Price: $69.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

Reviews:

“Good Stuff Overall!!! In my opinion, the instructor did great with the “How-tos” which helped for sure in grasping the whole concept of how to create cubes, set up data source and source views, dimensions, add attributes etc.” Lakeside David-Debo

“A fantastic course which gets you rolling very quickly and comfortably, thanks for the short and condensed knowledge delivery. Thanks, Phillip you made SSAS very simple for me.” – Anup Kale

“This is really the perfect course for beginners! Easy to learn and very inspirational for further investigations in SSAS. Thank you very much, Phillip!” – Marina Barinova

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

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 – Lets 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

Instructors

Phillip Burton
Best Selling Instructor – over 800,000 students so far

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

Rating Distribution

1 stars: 16 votes

2 stars: 46 votes

3 stars: 212 votes

4 stars: 818 votes

5 stars: 1134 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!