SQL Server SSAS (Multidimensional MDX) – an Introduction

Udemy
Deal Score+1
Deal Score+1

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

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 | 8 hours on-demand video course

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.

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.

Recommended Course

The Complete PL/SQL Bootcamp : “Beginner to Advanced PL/SQL”

Complete SQL and Databases Bootcamp: Zero to Mastery [2023]

Affiliate Disclosure: Thank you for visiting Udemy Coupons ME. We want to let you know that some of the links on our website are affiliate links. By clicking on these links and making a purchase, we may receive a small commission. This is at no extra cost to you. Our content, including the guidance we provide on education choices, is created with integrity and based on the practical assessment and feedback from our community of users. We focus on helping you find the best online courses to meet your needs, while the affiliate commissions we earn are reinvested into enhancing our platform. We appreciate your support and trust in our recommendations!

Josh Smith
Josh Smith

The Couponos team has over ten years of experience finding free and 100%-off Udemy Coupons. We add over 200 coupons daily and verify them constantly to ensure that we only offer fully working coupon codes. We are experts in finding new offers as soon as they become available. They're usually only offered for a limited usage period, so you must act quickly.