Microsoft SQL Server Analysis Services - SSAS (Tabular DAX)

This course covers the Tabular model in SQL Server Analytical Services.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

We'll install SQL Server Developer onto your computer, which previously used to cost $100, together with the SSAS extension.

We'll then create our first analysis using SQL Server in just a matter of minutes.

After this introduction, we'll go into some detail into how to create your analyses in Excel, including advanced Pivot Table options that most people don't even know about, but which are very useful. This includes slicers, timelines, and non-Visual Totals.

Then we'll develop DAX formulas, to further extend the model. A lot of the formulas are based on Excel formulas, but there are several additional things too. We'll create calculated columns, which are replicated in each row, and measures, which are summary calculations. We'll have a look at logical, aggregations, statistical, mathematical, text, information, filter and value, and time intelligence functions.

Finally, I'll show you how you can do similar things in Microsoft Excel.

By the end of this course, you will be able to create reliable analyses in Visual Studio, deploy them into SQL Server Analytical Services, drilled down the results quickly in Excel, and you'll be able to help others with their data analysis.