SQL Server SSAS (Multidimensional MDX) - an Introduction

Phillip Burton

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
24 Videos (2h 31m)
    • Introduction

    • Downloading SQL Server back engine - the Developer edition

    • Install SQL Server back engine

    • Installing SQL Server Front Engine

    • Downloading AdventureWorks

    • Investigating AdventureWorks in SSMS.

    • Creating our first project

    • Looking at our working environment, and Facts, Measures, Dimensions and Cubes

    • Creating a Data Connection

    • Creating a Data Source View

    • Creating a Cube

    • Creating a role, and playing with the cube

    • Looking at the cube using Excel

    • Adding an extra table, and Creating a dimension

    • Updating the cube, and using Excel again.

    • Looking at the cube using SSMS

    • Looking at the cube in SSRS

    • Practice Activity - Let's do it again!

    • Practice Activity - The Solution

    • Updating dimensions, and creating translations

    • Adding a new table into the Data Source View, and replacing it with a query

    • Adding a hierarchy - two levels

    • Adding a hierarchy - three levels

    • Congratulations


About This Class

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 to get information about? 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.






Reviews (0)

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.

He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.