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”.
SQL Server SSAS (Multidimensional MDX) – an Introduction Description
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.
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
How to download