Microsoft SQL Server Analysis Services - SSAS (Tabular DAX)

Learn to master data analysis with SQL Server Analytical Services! This comprehensive course guides you through using the Tabular model in SQL Server SSAS to build powerful analytical solutions.

Get hands-on experience by installing SQL Server Developer (formerly $100!) with the SSAS extension. We'll walk you through creating your first analysis in minutes.

Beyond the basics, discover advanced Pivot Table options in Excel – unlock hidden potential with features like:

• Slicers: Easily filter your data for focused insights.
• Timelines: Analyze trends over time.
• Non-Visual Totals: Add insightful summaries without cluttering your report.

Dive deep into DAX (Data Analysis Expressions), the formula language for SQL Server Analysis Services. You'll learn to:

• Create calculated columns – replicate calculations across each row.
• Develop measures – perform powerful summary calculations.
• Utilize a wide range of DAX functions, including:
  • Logical functions
  • Aggregation functions
  • Statistical functions
  • Mathematical functions
  • Text functions
  • Information functions
  • Filter functions
  • Value functions
  • Time intelligence functions

Finally, see how to replicate your SQL Server Analysis Services analyses in Microsoft Excel for flexible reporting and data exploration.

By the end of this course, you'll be able to:

• Build reliable data analyses in Visual Studio.
• Deploy your models into SQL Server Analytical Services.
• Drill down into results quickly within Excel.
• Effectively assist others with their data analysis needs.

Important Note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.