SQL Server SSAS (Multidimensional MDX) – an Introduction. Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool). Exam 70-768
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.
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.
It will assist with the “Design a multidimensional business intelligence (BI) semantic model” section of Microsoft exam 70-768 “Developing SQL Data Models”.
Table of Contents
SQL Server SSAS (Multidimensional MDX) – an Introduction Description
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 2017 for FREE. Previous versions cost $100.
SQL Server Essentials in an hour The SELECT statement
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.
Who this course is 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.
SQL Server SSAS (Multidimensional MDX) – an Introduction Free Download
Content From: https://www.udemy.com/course/sql-server-ssas-multidimensional-mdx-an-introduction/
How to download